Showing results for 
Search instead for 
Did you mean: 
Advocate I
Advocate I

Dataverse: Filter List by m:n related tables

Hi forum,

I have a question related to the use of "List rows" using dataverse tables.

I have in total 3 tables that are related:

table_a, table_b, table_c
table_a is related to the other two tables with m:n relations.
I now want to filter the result of "List rows" on table_a using fields in both other tables.
e.g.: table_b__field_x eq 'a' and table_c__field_y eq 'b'.

Is this possible with just one function using filter and expand options? If yes, how do I do this? Or do I need
to manually lookup the related tables and relation tables? Thanks so much.


Hey @OlafStetzer 


Yes this is possible, You can use the Primary key (guid) to lookup the values in the tables with lookups


Using a List Rows with filter like this:

createdby eq '<LookupGuid>'



Did I answer your question? Mark my post as a solution!

If you like my post please hit the Thumbs Up

Proud to be a Flownaut!

Check out my blog for Power Automate tips,
tricks, and guides

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.

Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Users online (5,232)