Showing results for 
Search instead for 
Did you mean: 
Frequent Visitor

how to filter based on the id from a data verse lookup column

I have 2 data verse tables the first table 'table1' have a lookup column to the table2 named parent id

and I want to filter the table2 based on the lookup column

Filter (table2,'table2id' in Filter (table1, my filter based on other columns).

but I can't get this work if anyone can help me

Super User
Super User

Hi @mf123 ,


I did a test that I think is what you are trying to do here where I have a table called Header and a table called Child where I have a lookup on the Child table back to the Header.  I am filtering the child information based on the selected Header record in the gallery.  

Filter(Children,Header.Header = Gallery1.Selected.Header)

Screen Shot 2021-12-05 at 8.12.31 AM.png


Hope this helps. Please accept if answers your question or Like if helps in any way.

Helpful resources

2022 Release Wave 1 760x460.png

2022 Release Wave 1 Plan

Power Platform release plan for the 2022 release wave 1 describes all new features releasing from April 2022 through September 2022.

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Users online (2,199)