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

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

1 REPLY 1
dpoggemann
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.
Thanks,
Drew

Helpful resources

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