Create a Process to update fields within same entity

(0) Share

Report

Posted on by Community member

Hello All-

Looking for directions for creating a Workflow (or Action?) that will update all records (within the same entity) that have matching field values.

Example:

When Field X in Record A changes and is updated to Yes value, then I'd like to update multiple fields in all other Records where Field Y is equal to Field Y in Record A. Field Y is a Lookup Field from another Entity. The multiple fields to be updated in subject Records are not parent/child.

Any help is greatly appreciated!

Bill Reinking
Executive Director
State Basketball Championship

I have the same question (0)

All responses (1)

Answers (0)

Suggested answer

Leah Ju Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi Partner,

Depending on your needs, workflow can't help and you need use power automate to make it happen.

In power automate, creating one automated flow:

1.Trigger:

--The When a row is added, modified or deleted trigger runs a flow whenever a row of a selected table and scope changes or is created.

https://learn.microsoft.com/en-us/power-automate/dataverse/create-update-delete-trigger

2.List rows:

--Use the List rows action to retrieve multiple rows at once from Microsoft Dataverse with a structured query.

https://learn.microsoft.com/en-us/power-automate/dataverse/list-rows

3.Update a row

--Use the Update a row action to make changes to a row in Microsoft Dataverse.

https://learn.microsoft.com/en-us/power-automate/dataverse/update

I hope you can verify my answer if it helps you! If you have any questions, please feel free to contact me.
Regards,
Leah

Was this reply helpful? Yes No