Forum Discussion
Combining Multiple Values from a SharePoint List into a Single Cell in Dataverse Using Power Query a
I have an online SharePoint list that I want to import into a Dataverse table using a dataflow. The SharePoint list contains a column with multiple values (list or table type) that I need to expand. ...
Hello LsL
Ensure that the multi-value column is in text format. Use transformations like `Text.Clean` or `Text.Trim` if necessary
Use the Group By function from the Power Query
Edit the M Code generated by Group By to combine values using `Text.Combine`:
Table.Group(#"PreviousStep", {"ID"}, {{"CombinedValues", each Text.Combine([MultiValueColumn], ","), type text}})