Error to extract values from a List

[Anonymous]

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?

[lbendlin]

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.