Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Cannot load lookup field from a sharepoint list

Hi there

 

I am trying to expand a lookup field from a sharepoint list, but I got this error:

 

DataSource.Error: Value cannot be null.
Parameter name: entitySet
Details:
DataSourceKind=OData

DataSourcePath=

This is my step:

 

= OData.Feed("companysharepointurl/_api/web/lists/GetByTitle('Table1')/Items?$select=Title,cod_name,dsc_name,FieldValuesAsText/Title&$expand=FieldValuesAsText/Title")

 

I tried the same sintaxe in another lookup field and the query worked normally. 

= OData.Feed("https://hbsis.sharepoint.com/sites/EnterpriseIntelligence/_api/web/lists/GetByTitle('Table1')/Items?$select=Title,cod_name,dsc_name,Author/ID&$expand=Author/ID")

 

 

 

 

 

 

 

 

 

 

 

Can anynone help me on this?

Need Help

2 Replies

  • Icey's avatar
    Icey
    Community Support
    5 years ago

    Hi Anonymous ,

     

    Based on the error code, please check if there is any null value in the column.

     

     

     

    Best Regards,

    Icey

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      Hi Icey thank you for your return, there is null value in the column and the error persists.