Forum Discussion

stvcdms's avatar
stvcdms
Frequent Visitor
10 years ago

Power Query SharePoint List Error with Allow Multiple Selection on People or Group Field

Hello,   I noticed today that if I am trying to connect to a SharePoint list and that list has a People or Group field with the allow multiple selection option enabled, that it causes a null value ...
Need Help
jup's avatar
jup
Frequent Visitor
8 years ago

same problem for me with multi selection columns and even the version column !

  • Veles's avatar
    Veles
    Advocate V
    8 years ago

    I'm still getting this problem. I have a few Person columns that are single selection only and I am able to exapnd those fine. I have one multi select column which shows as a table rather than a record and I get an error when I try and expand it.

     

    I just want to get a colon separated list of names like you do when you export to Excel.

     

    Very frustrating!