Use Fetch XML to list record in Power Automate using Common Data Service Connector.

In this post, we will look at how to use FetchXML in Microsoft Flow / Power Automate using a common data service connector to retrieve records using List Records Action.

Login to make.powerapps.com and create a solution and add a Flow

From All connectors select "Flow Button for mobile"

Select Manually trigger a flow

Once selected you need to add a step and select List record action from the current environment's Common Data service action.

Add FetchXML in Fetch Xml Query section.

Enter your Query, save changes and click on Test

Select I'll perform the trigger action.

Once flow runs you can use data in various ways, in this post we will create HTML page from data and send email to the user.

Once flow runs successfully it gets data from FetchXML and creates an HTML table from JSON Data.

Moving forward lets forward active accounts data via email, Here I am using Gmail connector to send data to my personal email.

Now lets test flow, if flow runs successfully you would get an email with a list of contacts.

Email received from Power Automate.

You can also use Microsoft Teams connector to post a similar message in any team group.

Hope this helps you..!