Forum Discussion
Anonymous
4 years agoNot applicable
Imported Sharepoint List omits data
Hi there,
I imported a Sharepoint List that has a column called "Managers" where each row has a list. I use
Extract values...
to extract the values which generates this dax code
= Table.TransformColumns(#"Renamed Columns", {"Managers", each Text.Combine(List.Transform(_, Text.From), ";#"), type text})
Expected behaviour
Each row should contain the name of one or multiple managers and their ID's seperated by ;# i.e.
Bill Gates ;#1;#Satya Nadella;#3
Actual behaviour
1;#3
Alternative
I got the correct result when I exported the Sharepoint List to a .iqy file and opened it in Excel.
Does anyone know what I have to do to keep the manager names?
Thanks
1 Reply
- v-jingzhangCommunity Support
Hi Anonymous
Does this "Managers" column have both manager names and manager IDs in it? Can you provide some sample data to show how the list looks like in each row?
Best Regards,
Community Support Team _ Jing