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

You can do this in Power Query before loading to Dataverse.

Steps:

In your dataflow, load the SharePoint list.

The multi-value column will appear as a table/list.

Use Transform → Extract Values on that column.

Choose a separator (, or ;).

Power Query will flatten the list into a single text string in the cell.

Load to Dataverse — now you’ll get one row with combined values instead of multiple rows.

So instead of expanding into rows, you extract values with a delimiter.