Unanswered

list rows from parent table using child id

(0) Share

Report

Posted on by DariuszSzwabo

Hi All,

Is there a way to fetch rows from Parent table basing on Child ID? Its very simple use case when using SQL, query select from parent where child = '123' should give me all records form 'parent' where FK = '123',

Is there a way to do the same in Power Automate? eg. using list rows,

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (0)

v-yueyun-msft on at

Like (0)

Report

Hi , @DariuszSzwabo

Do you mean you want to filter the rows from your table? If this , you can refer to this blog if it can help:
Power Automate List Rows Present in a Table Filter Query + 10 Examples - Enjoy SharePoint

Best Regards,

Yueyun Zhang

Was this reply helpful? Yes No
Inogic 1,135 Super User 2025 Season 2 on at

Like (0)

Report

Hi,
Yes, it is possible to fetch rows from a parent table based on a child ID in Power Automate. This typically involves the use of the "List rows" action and possibly some additional filtering or lookup actions depending on your data source and structure. You can see the same in the below screenshot where we are trying to fetch accounts linked to certain contact.

Hope this helps.

Thanks!
Inogic Professional Services: Power Platform/Dynamics 365 CRM
An expert technical extension for your techno-functional business needs
Drop an email at crm@inogic.com
Service: https://www.inogic.com/services/
Tips and Tricks: https://www.inogic.com/blog/

Was this reply helpful? Yes No