Answered

Is there a way to NOT upsert a record with Dataverse Update row action?

(0) Share

Report

Posted on by arpost

464

Greetings, all. I am working with the Dataverse Update row action and just noticed it creates records if the record I am trying to update has been deleted. While I can see the value of this in other scenarios, I want to prevent this in certain cases. Does anyone know if this is possible?

UPDATE: Here is an idea (idea link) to fix this behavior. Currently, the only workaround is to do a conditional check before updating. Feel free to upvote.

EXAMPLE:

Here's my table before I run the Update; I deleted the record with the GUID I'm sending to Power Automate to update:

Here's my flow where the RowID is passed to the Update action:

Here's the table after I run the update:

Categories:

Building flows

I have the same question (0)

All responses (4)

Answers (1)

Verified answer

v-yueyun-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi , @arpost

Yes, If you provide a row Id that doesn't exist or generated with the guid() expression, the action performs an update or insert (upsert) operation, creating a new row with the Id you provide.

Use a flow to update a row in Dataverse - Power Automate | Microsoft Learn

And if you want to add the condition before "Update a row" action , you can refer to my flow:

empty(outputs('Get_a_row_by_ID')?['body']?['error'])

false

If this reply can help you , you can click mark this reply as solution (Accept solution) which can help more people, thanks in advance!

Best Regards,

Yueyun Zhang

Was this reply helpful? Yes No
arpost 464 on at

Like (0)

Report
Copy link

Link copied!

@v-yueyun-msft, thank you for the reply. So every update in every flow performing an update has to have an additional Get Row + Condition step? Ouch. That's going to add a lot of bloat to my flows.

Is there no way to configure the Update step itself in such a way as to simply error out if no record exists? Or, at minimum, just return nothing?

Was this reply helpful? Yes No
v-yueyun-msft Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!

Hi , @arpost

Thanks for your response!

According to my search and testing, there seems that it has no setting that can directly configure not to create a new row when the ID does not exist. If you want to avoid it, you may need to add a Get row by id and Condition in front like I did.

If this reply can help you , you can click mark this reply as solution (Accept solution) which can help more people, thanks in advance!

Best Regards,

Yueyun Zhang

Was this reply helpful? Yes No
arpost 464 on at

Like (0)

Report
Copy link

Link copied!

Thanks for checking. I've created a Power Automate idea (idea link) for others to upvote to fix this behavior.

Was this reply helpful? Yes No