cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
MariTheron
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?

1 REPLY 1
Expiscornovus
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):

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...

 

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

 

expandquery_manytomany.png

 

 



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

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