Answered

Dataverse Flow Update a Row Action Failing to Upsert

(0) Share

Report

Posted on by CU24011932-0

According to the documentation, the Update a Row action should perform an upsert (which is an update if row exists with a given row ID or an insert if it does not).

Instead, when a row with the row ID does not exist it is returning the following error:

Entity 'cr29f_JourneyLeadHistory' With Id = 01d33241-bb0f-168d-8bad-6cff6e2afc73 Does Not Exist

After that, this error, I added an Add a Row that triggers on a failure with the same parameter mapping and it did the insert. Re-running the same flow and the Update a Row works. This shows the upsert in the documentation is not working.

Is there a way to get the correct behavior?

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Suggested answer

ankit_singhal 614 Super User 2025 Season 2 on at

Like (0)

Report
Copy link

Link copied!

The update is not work like upsert directly. You need to write an expression in the ID column. If your ID is not present in table then assign a new GUID else provide existing GUID.

Note: Please mark verified, if it is useful for you

Was this reply helpful? Yes No
CU24011932-0 6 on at

Like (0)

Report
Copy link

Link copied!

@ankit_singhal Thank you. I want to make sure we understand. We are mapping in a GUID from another list output right now. Are you saying if we just use an expression formula instead that changes the behavior of the Update a Row action? Could we just put this in an expression instead or a special kind of expression?

Was this reply helpful? Yes No
Verified answer

Lukas Kormuth 7 on at

Like (1)

Report
Copy link

Link copied!

Hello, it looks like Microsoft added separate action for this Upsert a row recently.

Was this reply helpful? Yes No