Power Automate - Get data from multiple entities

(0) Share

Report

Posted on by AndreTheDev

Hey there,

Let's say the creation of a new record in a certain table fired my power automate flow.

What's a better way of gathering related data from several dataverse entities than querying one by one with multiple "List rows" functions (available in power automate). I've already done one "List rows" to table 2 with a lookup field equal to the value I am passing. Now I need to pick another column from table 2 and send its value to another related on in table 3 and so on.

Thanks

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (2)

Answers (0)

AhmedSalih

6,678 Moderator on at

Like (3)

Report

Hello, @AndreTheDev. You can utilize the Expand Query or the Fetch Xml Query options in the List Rows Action in Power Automate:

If my reply helped you, please give a 👍 , & if it solved your issue, please 👍 & Accept it as the Solution to help other community members find it more.

I am primarily available on weekdays from 6-10 PM CT and 5-10 PM CT on weekends.

Visit my Blog: www.powerplatformplace.com

Was this reply helpful? Yes No

João Santos 323 on at

Like (1)

Report

Hi @AndreTheDev ,
Just to expand a bit on what @AhmedSalih said, as long as the data you're looking for are from N:1 relationships from your main entity then you should be able to do it.
To focus on FetchXml specifically, you can create a FetchXml that brings columns from related tables on the result.
I'd suggest either using the Advanced Find editor to build your query and bring whatever columns you need from related tables, or use a tool like the FetchXml Builder on the XrmToolbox.
Then just paste that FetchXml on the FetchXml query field on Power Automate and that's it, that'll bring the data.
hope that helps

Was this reply helpful? Yes No