cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
OlafStetzer
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.

1 REPLY 1
Jcook
MVP

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

Jcook_0-1612479696269.png

 


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
FlowAltDelete





Helpful resources

Announcements
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)