Forum Discussion

kris's avatar
kris
New Member
9 years ago

field lockup with picker sharepoint 2010 (multiple value)

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...
Need Help
v-yulgu-msft's avatar
v-yulgu-msft
Icon for Microsoft Employee rankMicrosoft Employee
9 years ago

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

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