Forum Discussion
Extracting a SharePoint List Person Picker with empty values
I think I found a different solution.
I adapted this:
https://community.powerbi.com/t5/Desktop/Extract-table-from-column/td-p/1022979
To create a new column but used Table.SelectColumns to specify the exact column I wanted as so:
if [Assigned to] is table
then
Text.Combine(
List.Transform(
List.Combine(Table.ToRows(Table.SelectColumns([Assigned to], "title"])))
, each Text.From(_)
)
,","
)
else [Assigned to]
Which returns the items in the specified column delimited by comma, unless the original column value is null, in which case it returns a null.
I think I found a different solution.
I adapted this:
https://community.powerbi.com/t5/Desktop/Extract-table-from-column/td-p/1022979
To create a new column but used Table.SelectColumns to specify the exact column I wanted as so:
if [Assigned to] is table
then
Text.Combine(
List.Transform(
List.Combine(Table.ToRows(Table.SelectColumns([Assigned to], "title"])))
, each Text.From(_)
)
,","
)
else [Assigned to]
Which returns the items in the specified column delimited by comma, unless the original column value is null, in which case it returns a null.