Showing results for 
Search instead for 
Did you mean: 
Regular Visitor

list rows for Many to Many relations

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?

Super User
Super User

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):


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





Happy to help out! 🙂

Interested in more #PowerAutomate #SharePointOnline or #PowerVirtualAgents content?
Visit my blog, Subscribe to my YouTube channel or Follow me on Twitter

Helpful resources

Power Automate News & Announcements

Power Automate News & Announcements

Keep up to date with current events and community announcements in the Power Automate community.

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Users online (3,199)