Dataverse: Filter List by m:n related tables

[OlafStetzer]

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.

[Jcook]

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