Cannot load lookup field from a sharepoint list

[Anonymous]

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?...")

Can anynone help me on this?

[Icey]

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]

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