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

Announcements

News and Announcements icon
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,828 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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Congratulations to the March Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Haque Profile Picture

Haque 594

#2
Valantis Profile Picture

Valantis 328

#3
David_MA Profile Picture

David_MA 281 Super User 2026 Season 1

Last 30 days Overall leaderboard