web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / how to filter based on...
Power Apps
Unanswered

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

(0) ShareShare
ReportReport
Posted on by 5

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

I have the same question (0)
  • Drew Poggemann Profile Picture
    9,287 Most Valuable Professional on at

    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

     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 717 Most Valuable Professional

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 329 Super User 2025 Season 2

#3
Power Platform 1919 Profile Picture

Power Platform 1919 268

Last 30 days Overall leaderboard