Cannot load lookup field from a sharepoint list

Question

Hi there&nbsp;I am trying to expand a lookup field from a sharepoint list, but I got this error:&nbsp;DataSource.Error: Value cannot be null.Parameter name: entitySetDetails:DataSourceKind=ODataDataSourcePath=This is my step:&nbsp;= OData.Feed("companysharepointurl/_api/web/lists/GetByTitle('Table1')/Items?$select=Title,cod_name,dsc_name,FieldValuesAsText/Title&amp;$expand=FieldValuesAsText/Title")&nbsp;I tried the same sintaxe in another lookup field and the query worked normally.&nbsp;= OData.Feed("https://hbsis.sharepoint.com/sites/EnterpriseIntelligence/_api/web/lists/GetByTitle('Table1')/Items?$select=Title,cod_name,dsc_name,Author/ID&amp;$expand=Author/ID")&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Can anynone help me on this?

icey · Answer

Hi&nbsp;Anonymous&nbsp;,
&nbsp;
Based on the error code, please check if there is any null value in the column.
&nbsp;
&nbsp;
&nbsp;
Best Regards,
Icey
&nbsp;
If this post&nbsp;helps, then please consider&nbsp;Accept it as the solution&nbsp;to help the other members find it more quickly.

anonymous · Answer

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

Forum Discussion

Related content

Lookup help

Sharepoint list mirroring

Extract Data from sharepoint

SharePoint Access

Concatenated Lookup