Combining Multiple Values from a SharePoint List into a Single Cell in Dataverse Using Power Query a

Hi LsL,

Thank you for reaching out to the Microsoft fabric community forum. Thank you nilendraFabric, for your inputs on this issue.

I understand you are working with a SharePoint Online list and using a dataflow to import it into a Dataverse table. You have a column containing multiple values (such as a people picker or multi-select choice field), and you want to combine these values into a single cell separated by commas instead of expanding them into separate rows.

This is a common scenario when handling list or table-type columns in Power Query. Here’s how you can accomplish this in your dataflow using Power Query:

Combine Multiple Values into a Single Cell: Connect your SharePoint list in the Power Query editor. Identify the multi-value column (e.g., Assigned to). Add a Custom Column with the following formula:

Text.Combine(List.Transform([AssignedTo], each Record.Field(_, "DisplayName")), ", ")

This line extracts the display name from each item in the list and combines them into a single comma-separated string. If your multi-value column has a different name or contains different fields, update "display name" accordingly.

Remove the original multi-value column if it is no longer needed and rename your new custom column to align with your schema. Ensure your final output contains only flat columns (text, number, date) to ensure compatibility with Dataverse.

After completing these steps, save and refresh the dataflow. This will ensure each SharePoint list item remains in a single row, with the combined multi-value field in one cell as intended.

Kindly refer to the below following links for more information:
Text. Combine - Power Query M | Microsoft Learn
List. Transform - Power Query M | Microsoft Learn

If this post helps, then please give us ‘Kudos’ and consider Accept it as a solution to help the other members find it more quickly.

Thank you for using Microsoft Community Forum.