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 / Lookup column with cas...
Power Apps
Unanswered

Lookup column with cascading - filter problem

(0) ShareShare
ReportReport
Posted on by

Hi,

 

I found a nice tutorial for a cascading lookup list. I use this tutorial Link but my last formula is wrong, what do i wrong?

This my formula: 

Filter(Show Columns('Applicants List', "Title", "ID", "ApplicationsJobPositionLookup"), ApplicationsJobPositionLookup.Id = JobPositionDropdown.Selected.ID) It

This is the code for my second lookup column. This first column works fine, this is my formula

 

ShowColumns('Job Positions', "ID", "Title")

I have 3 lists:

List 1 - Job Position - Title column

List 2 - Application List - Title column and 1 lookup column to Job Position

List 3 - InterviewSchedule - 2 lookup columns to the first two lists

 

Lookup list.png

Categories:
I have the same question (0)
  • panand99 Profile Picture
    641 on at

    @Anonymous 

    First check why 'ShowColumns' has the space in your formula?

     

  • Community Power Platform Member Profile Picture
    on at

    The space was wrong but my formula still doenst work. See you what i'm missing?

     

    Filter(ShowColumns('Applicants List', "Title", "ID", "ApplicationsJobPositionLookup"), ApplicationsJobPositionLookup.Id =JobPositionDropDown.Selected.ID)

     Error app.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 739 Most Valuable Professional

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 343 Super User 2025 Season 2

#3
Power Platform 1919 Profile Picture

Power Platform 1919 268

Last 30 days Overall leaderboard