Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Error to extract values from a List

Hello!

 

I am trying to extract values from a List that come from my SharePoint, there is a column "Sponsor" that have some different data for Sponsor (title, email, sip account, id). i am connectiing to a SharePoint list and the table already come with his columns set as a list

Screenshot

When I  click on "Extract Values", all lines are filled with error, follow below the error details:

This is the Query in advance editor 

#"Extracted Values" = Table.TransformColumns(#"3e6548fe-3337-45e9-8bdf-c8bb21245a1a", {"Sponsor", each Text.Combine(List.Transform(_, Text.From)), type text}),

Could you help me?

 

Need Help

1 Reply

  • lbendlin's avatar
    lbendlin
    Super User
    5 years ago

    Use ODATA to pull just the ID, and then use the User Information List table from the same sharepoint site to map in the details.

     

    Lookup fields in lists are to be avoided if at all possible.