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 flowNow 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?
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.
Keep up to date with current events and community announcements in the Power Automate community.
Check out the latest Community Blog from the community!