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

Announcements

News and Announcements icon
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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 101 Most Valuable Professional

#2
Haque Profile Picture

Haque 81

#3
VASANTH KUMAR BALMADI Profile Picture

VASANTH KUMAR BALMADI 70

Last 30 days Overall leaderboard