Share
Report
156Hi currently we have a Power Platform environment linking to a D365 FO environment, I we are using some D365 FO entities in our Canvas App via Virtual Entity, the virtual entity we are using from D365 FO is Employee V2. On Dataverse, we have 2 tables which are "Leave Request" and "Leave Transaction" with the relationship 1:M
In the "Leave Request" table, we created a Lookup field that Lookup to the Employee V2 Virtual Entity
As soon as we created this lookup field, our code in the Canvas app started getting this error: "Error when trying to retrieve data from the network: Sql error: Generic SQL error. CRM ErrorCode: -2147204784 Sql ErrorCode: -2146232060 Sql Number: 207". This error only happens for "Leave Transaction" table. For example, here we try to filter "Leave Transaction" and store the result in a collection.
We already tried to remove the table from the Canvas app datasource and add it back, but could not solve the issue. The issue only be resolved if we remove the Lookup field to Employee V2 Virtual Entity in "Leave Request" table.
All responses (
Answers (
