We encounter an error when inserting data into a lookup column by OData.
We have two tables: Table1 and Table2, with logical names new_table1 and new_table2.
In Table2, We added a column named Table1 (logical name new_table1), which is a lookup column referencing Table1.
When inserting data into the column new_table1@odata.bind with the value
/new_table1s(8feb3d3a-71cf-f011-bbd3-000d3a26b7dc), we receive the following error:
"HttpError: Error identified in Payload provided by the user for Entity :'new_table2s'.
For more information on this error please follow this help link https://go.microsoft.com/fwlink/?linkid=2195293
----> InnerException : Microsoft.OData.ODataException: An undeclared property 'new_table1'
which only has property annotations in the payload but no property value was found in the payload.
In OData, only declared navigation properties and declared named streams can be represented as properties without values."
Interestingly, when we add another lookup column named Test (new_test) that also references Table1, the issue does not occur (the only diffrence is the column name)
After testing with different tables and column names, it seems the problem arises specifically when the column name is identical to the name of another table.
In Dataverse, there is no issue when adding a column with the same name as another table, nor when creating a table with the same name as a column in a different table. Everything works correctly in Dataverse — the problem only occurs with OData.
We encounter an error when inserting data into a lookup column by OData.
We have two tables: Table1 and Table2, with logical names new_table1 and new_table2.
In Table2, We added a column named Table1 (logical name new_table1), which is a lookup column referencing Table1.
When inserting data into the column new_table1@odata.bind with the value
/new_table1s(8feb3d3a-71cf-f011-bbd3-000d3a26b7dc), we receive the following error:
"HttpError: Error identified in Payload provided by the user for Entity :'new_table2s'.
For more information on this error please follow this help link https://go.microsoft.com/fwlink/?linkid=2195293
----> InnerException : Microsoft.OData.ODataException: An undeclared property 'new_table1'
which only has property annotations in the payload but no property value was found in the payload.
In OData, only declared navigation properties and declared named streams can be represented as properties without values."
Interestingly, when we add another lookup column named Test (new_test) that also references Table1, the issue does not occur (the only diffrence is the column name)
After testing with different tables and column names, it seems the problem arises specifically when the column name is identical to the name of another table.
In Dataverse, there is no issue when adding a column with the same name as another table, nor when creating a table with the same name as a column in a different table. Everything works correctly in Dataverse — the problem only occurs with OData.