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.

Super User III
Super User III

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

MPA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group


Experience what’s next for Power Virtual Agents

See the latest Power Automate innovations, updates, and demos from the Microsoft Business Applications Launch Event.

New Super Users

Meet the Power Automate Super Users!

Many congratulations to the Season 1 2021 Flownaut Crew!

Power Platform ISV STudio

Power Platform ISV Studio

ISV Studio is the go-to Power Platform destination for ISV’s to monitor & manage applications post-AppSource publish.

Users online (59,343)