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")), "; ")
Thank you Anonymous...
I may not have been clear when describing my issue: When I query a SP Online List, the values in one of the columns (a multi-select lookup column) appear in the Pwer Query Editor as "Table." I need to extract the lookupValue from the table to leverage in reports.
When I try to "Expand" the column, the action returns only the first row.
I would appreciate any suggestions!