Dynamics Community Forum Thread Details

"Update a record" action fails with composite key on PersonEducations entity

I'm using the Fin & Ops Apps (Dynamics 365) connector in Power Automate to upsert records into the PersonEducations entity in Dynamics 365 Finance & Operations (Human Resources module).
The entity has a composite key of 4 fields: PartyNumber, EducationDisciplineId, EducationInstitutionId, EducationLevelId.

First, I check that the record exists in PersonEducations. Then I run the "Update a record" action. I've noticed that when my record has both EducationInstitutionId and EducationLevelId empty — example: 001323,0002,, — this action works and correctly updates the record. But when the field EducationLevelId has a value such as "5" — example: 001375,0013,,5 — it returns the error 404 - Not Found.
I confirmed via a separate "List rows" (Get items) call on the same entity that the record does exist with exactly those key values.

I've also tried fixing this in several different ways:

Changing the order: 001375,0013,5, (here I get a different error: 400 "An error has occurred. No resources were found when selecting for update.")
Wrapping the empty segment in escaped single quotes ('') — also fails
Using ItemInternalId (the GUID returned by "List rows") as the Item id instead of the composite key — this doesn't work either, because I noticed ItemInternalId for the exact same record changes between calls.

Both EducationInstitutionId and EducationLevelId are String fields according to the official documentation.
Could someone help me identify the correct format/order for building this composite key when one or more segments are non-empty? Is there any documentation on how this connector serializes composite keys for the "Update a record" action, or a way to inspect the exact request sent to F&O?

Thank you

Categories:

Dynamics 365 general

Quick Links

Leaderboard > Microsoft Dynamics 365 | Integration, Dataverse, and general topics