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")), "; ")
For anyone who runs into this issue:
https://www.youtube.com/watch?v=-By3WdkHlLU
Text.Combine(Table.ToList(Table.SelectColumns([ColumnWithTables], "TableColumn")), "; ")