Skip to main content

Notifications

Power Apps - Microsoft Dataverse
Suggested answer

Dataverse Flow Update a Row Action Failing to Upsert

Like (0) ShareShare
ReportReport
Posted on 29 Jan 2025 17:24:07 by 4
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?
  • Suggested answer
    Lukas Kormuth Profile Picture
    Lukas Kormuth 2 on 04 Feb 2025 at 19:11:57
    Dataverse Flow Update a Row Action Failing to Upsert
    Hello, it looks like Microsoft added separate action for this Upsert a row recently.
     
  • CU24011932-0 Profile Picture
    CU24011932-0 4 on 30 Jan 2025 at 15:57:43
    Dataverse Flow Update a Row Action Failing to Upsert
    @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?
  • Suggested answer
    ankit_singhal Profile Picture
    ankit_singhal 379 on 30 Jan 2025 at 06:03:41
    Dataverse Flow Update a Row Action Failing to Upsert
    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 

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,666

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,996

Leaderboard

Featured topics

Loading started
Loading complete