list rows for Many to Many relations

[MariTheron]

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?

[Expiscornovus]

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.