Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

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-jingzhang's avatar
    v-jingzhang
    Community 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