Hello Team ,
I have created a Logic App to send data from a Excel file in SharePoint Online to D365FO Custom Entity.
when I run the LogicApp I observe that the values from SharePoint Online Excel is retrieved and as per mapping values are not being stored into D365FO instead it errors out as BadRequest.
{
"status": 400,
"message": "An error has occurred. Write failed for table row of type 'XX'. Infolog: Warning: The value '10646' in field 'Vendor account' is not found in the related table 'Vendors'.; Warning: validateField failed on field 'XX.VendorAccount'.\r\nclientRequestId: aa122e58-621b-477d-85a8-6c46fd9afa19",
"error": {
"message": "An error has occurred. Write failed for table row of type 'XX'. Infolog: Warning: The value '10646' in field 'Vendor account' is not found in the related table 'Vendors'.; Warning: validateField failed on field 'XX.VendorAccount'."
},
"source": "XXXXXXX.sandbox.operations.dynamics.com",
"errors": []
}
Could someone let me know what could be the reason .
