I've been trying to create 1 to 1 relation in Dataverse, and according to this post it's not added and not supported yet.
On the other hand, it was suggested to create 1:M and M:1 in both tables to make them related to each other. (which I've made).
I've tried to use power automate to make this step of syncing between two created records between both tables happen, but I keep getting errors while creation of child record.
What I'm attempting to do:
- On creation of a record in Table-A (Parent) a record on Table-B should be created and a related column in Table-B should be populated with Table-A ID (the newly created record in this table)
A small issue that I've is Table-A & Table-B primary keys (ID) are autogenerated so it tries to do the action of adding the record but always gets erros.
Errors that I get
Raw input from previous step
{
"host": {
"connectionReferenceName": "shared_commondataserviceforapps",
"operationId": "CreateRecord"
},
"parameters": {
"entityName": "cr855_testchildren",
"item/cr855_childid": null,
"item/[email protected]": "1"
}
}
Error
{
"error": {
"code": "0x80060888",
"message": "URL was not parsed due to an ODataUnrecognizedPathException. Resource not found for the segment provided in the URL."
}
}
I'm new to power applications (dataverse, power-automate, power-apps....), so please accept my apologize if I'm missing any information in my question.
If you want to set/update the lookup field value the content should look like /entitycollectionname(recordid), so something like /cr855_testparents(da1f3c80-70c2-4098-83a4-3e4e87f03d9e)