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 / list rows for Many to ...
Power Automate
Unanswered

list rows for Many to Many relations

(0) ShareShare
ReportReport
Posted on by 1

I have a Model Driven app and when you click a button I run a Power Automate Flow

I have two tables with a many to may relationship between them

Requests and Candidates

 

When the user click the button Power Apps send the request Guid to the flow
Now I need a way to find all the candidates related to the request Guid. 

List rows does not work because you cant see the table in the dropdown 


How do I do that?

Categories:
I have the same question (0)
  • Expiscornovus Profile Picture
    33,195 Most Valuable Professional on at

    Hi @MariTheron,

     

    You might be able to work this out by using the $expand query. In that field you can also retrieve data from your relationships (many-to-many should be supported for collection-valued navigation properties):

    https://docs.microsoft.com/en-us/power-automate/dataverse/list-rows#expand-query

    https://docs.microsoft.com/en-us/power-apps/developer/data-platform/webapi/retrieve-related-entities-query#retrieve-related-records-by-expanding-collection-valued-navigation-properties

     

    Below is an example of the Accounts table and the many-to-many relationship with Web Role table.

     

    expandquery_manytomany.png

     

     

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 525 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 324 Moderator

#3
abm abm Profile Picture

abm abm 232 Most Valuable Professional

Last 30 days Overall leaderboard