Forum Discussion
SharePoint List - Assigned to Filed No Data
Hi all,
I imported a list from an online Sharepoint list but one of the columns is giving me no data
It gives me a [List] field instead of the data as shown below
Thank you all,
Hi Anonymous
Download PBIX file with these examples
You'd normally expect to see a double headed arrow at the top of the column containing the Lists but as the last row is blank that's not appearing.
You'll need to remove that blank to be able to use the expand icon in the column header.
Or you can insert a line of M code in the query to extract the values from the lists, for example
= Table.TransformColumns(#"Removed Columns", {"Assigned To", each if _ is list then Text.Combine(List.Transform(_, Text.From),",") else null, type text})regards
Phil
3 Replies
- PhilipTreacy
Super User
Hi Anonymous
Download PBIX file with these examples
You'd normally expect to see a double headed arrow at the top of the column containing the Lists but as the last row is blank that's not appearing.
You'll need to remove that blank to be able to use the expand icon in the column header.
Or you can insert a line of M code in the query to extract the values from the lists, for example
= Table.TransformColumns(#"Removed Columns", {"Assigned To", each if _ is list then Text.Combine(List.Transform(_, Text.From),",") else null, type text})regards
Phil
- PhilipTreacy
Hi Anonymous
Please @ mention me or I won't see your reply. Type @ then select my name.
Your data doesn't show a null it shows a blank or empty value or a space.
When you tried to rmeove it the row remained?
Have you tried the code I listed above to extract the lists?
Please supply your PBIX so I can help further.
Regards
Phil