You’re offline. This is a read only version of the page.
61
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,
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!
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
Share
Report
All responses (
Answers (
