Forum Discussion
Solved
Multi Select Lookup Column shows as Table in Power Query
I am attempting to build a report from our Sales List in SP Online. One of the columns ("Bid To") is a multi-select lookup column in which we select all of the clients the project bid was snt to. The...
For anyone who runs into this issue:
https://www.youtube.com/watch?v=-By3WdkHlLU
Text.Combine(Table.ToList(Table.SelectColumns([ColumnWithTables], "TableColumn")), "; ")
Hi COR2 ,
I would suggest you try the Group By feature in Power Query.
Grouping or summarizing rows - Power Query | Microsoft Learn
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.