How To Update Records In Dynamics 365 By Using FetchXml Query Through Power Automate

Introduction

This blog explain about how to update records in dynamics 365 by using fetchxml query through power automate.

Step 1
Login to the required Power Automate environment using URL make.powerautomate.com by providing the user name and password and click on Create on the left-hand side and after chose the Automated Cloud Flow as shown in the below figure.

Step 2
After step 1, click on the trigger as When an item is created, and Give the Flow Name Then click on Create as shown in the bellow figure.

Step 3
Click on + New Step, find and select the “List Row” action and chose “Table Name” as show in the below figure.

Step 4
After step 3, go to “Advance Find” and select entity and “Status” equal to “Active” then click on “download Fetch XML” as show in the bellow figure.

Step 5
After step 4, copy the Fetch XML code and past in the list row as show in the below figure.

Step 6
Click on + New Step, find and select the “Apply To Each” action after select the value form “List Row” as show in the below figure.

Step 7
Click on + New Step, find and select the “Update a row” action after give the “Row id” form “List Row” then update any field it will reflect to all records as show in the below figure.