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
DavidSmith's avatar
DavidSmith
New Member
9 years ago

I just downloaded this product to confirm that the editor (and problem) is the same as the Power Query engine in Excel 2013, and it is. Those of you changing your ApiVersion to 14 still get an error because the 15 version uses different filtering syntax than the 14 version - the error is with the second line.

 

If you delete the second step and have the query pull from source, you can then visually navigate through the UI to your list and it should work. Or, you can open the advanced editor from a blank query and just paste / replace the default text with this:

 

let
    Source = SharePoint.Tables("https://YourSharePointServerHere.com", [ApiVersion = 14]),
    List = Source{[Name="YourListNameHere"]}[Content]
in
    List

 

The alternative is to learn a little OData syntax and query through ListData.svc, which is a little trickier (but seems to be much more efficient).  Or, you know, maybe have the SharePoint team actually fix the 15 API.  But you shouldn't be holding your breath (or worse, giving up on it!) in the meantime.

ThoSch's avatar
ThoSch
Regular Visitor
9 years ago

same here:

 

i try this:

let
    Source = SharePoint.Tables("https://YourSharePointServerHere.com", [ApiVersion = 14]),
    List = Source{[Name="YourListNameHere"]}[Content]
in
    List

an get this error:

 

Expression.Error: The key didn't match any rows in the table.
Details:
    Key=Record
    Table=Table

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    Changing to [ApiVersion = 14] in Source fixed my problem with the SharePoint List column names not updating to the current column SharePoint title when pulling the list into power Bi. Microsoft should fix this for 15!

     

    The problem "Expression.Error:" went away for me if you rebuild the applied steps  in the query editor after the Navigation (default name) step. (Note:  in ThoSch's code step was called List.)