field lockup with picker sharepoint 2010 (multiple value)

[kris]

When I try to connect me to a sharepoint 2010 list using odata (/_vti_bin/ListData.svc),
I get to retrieve almost all my tables.

But, In a table I have a fields "lookup with picker" (multiple value) that points to another list. And this column does not appear anywhere in my query as if it did not exist.

What do I do to retrieve this type of fields?

Please, I need to help.

[v-yulgu-msft]

Hi @kris,

Based on my test, when we data from SharePoint task list, the lookup field column will not display detailed information.  The column can be expanded in order to include any attribute of the source item.

In your scenario, please open Query Editor, find the lookup field column, then click it’s value section to open the list that provides corresponding data. Here is a similar thread as yours: SharePoint list - missing data in columns

For more introduction about lookup fields in SharePoint list, please see: Using Power Query with SharePoint Lists and Lookup Fields

Best regards,
Yuliana Gu

[kris]

Thank you for your answer but my problem is a little different
I have all the other columns (type choice, simple search) that I can effectively expand. But the "lookup with picker" (multiple value) column does not exist.
Before I can expand it, The column must appear with the other and then i could click it’s value section to open the list thatprovides corresponding data.

 

Thank you for your help 😉

Krislaine