web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / How to Filter Rows in ...
Power Automate
Unanswered

How to Filter Rows in Power Automate based on a Many to Many dataverse relationship

(0) ShareShare
ReportReport
Posted on by 62

I have setup a Many-to-Many relationship between two tables Process Templates and Task Templates in Dataverse.  This is to allow for one task template to be part of many processes and a process template to have many tasks. 

Alastair_0-1626169650988.png

 

In Dataverse the relationship that’s been setup between the two tables is as follows

Alastair_1-1626169650992.png

 

I have been able to relate the two tables data together as desired however I am then struggling to utilize Power Automate to retrieve the tasks related to a process template on demand.  I.e. I want to return all task templates that are related to the Quarterly Reports 1 process template.  How would I achieve this in Power Automate?  

 

Apologies if this has been answered before but its gotten really confusing with all the renaming Microsoft has done.

Categories:
I have the same question (0)
  • PrasadAthalye Profile Picture
    on at

    Can you please check following thread and see if it helps?

     

    https://powerusers.microsoft.com/t5/Microsoft-Dataverse/Flow-to-list-records-from-a-Many-to-Many-relationship/td-p/929612

     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 522 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 364 Moderator

#3
abm abm Profile Picture

abm abm 243 Most Valuable Professional

Last 30 days Overall leaderboard