cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Anonymous
Not applicable

Lookup column with cascading - filter problem

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

2 REPLIES 2
Highlighted
Skilled Sharer
Skilled Sharer

Re: Lookup column with cascading - filter problem

@Anonymous 

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

 

Highlighted
Anonymous
Not applicable

Re: Lookup column with cascading - filter problem

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

Helpful resources

Announcements
Check this Out

Helpful information

Featuring samples like Return to the Workplace and Emergency Response Applications

August 2020 Community Challenge: Can You Solve These?

August 2020 Community Challenge: Can You Solve These?

We're excited to announce our first cross-community 'Can You Solve These?' challenge!

secondImage

Return to Workplace

Reopen responsibly, monitor intelligently, and protect continuously with solutions for a safer work environment.

secondImage

Super Users Coming in August

We are excited for the next Super User season.

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors
Users online (7,695)