Answered

Cascading drop-downs on SharePoint lists with lookups in Power Apps

(0) Share

Report

Posted on by beverlyg

Hey there!

I've tried doing a Google search and reaching out to ChatGPT for a solution, but I'm not having any luck. Can you help me out?

I have an app with the form and 3 SharePoint lists (Station NEW, Department NEW, Job Title NEW) with lookups.

Station NEW

Title

Admin

AKS

REF

TGD

SVG

Department NEW

Title	Station Lookup
Admin	Admin
Service	Admin, AKS, REF, TGD, SVG
Ramp	Admin, AKS, REF, TGD, SVG

Job Title NEW

Title	Station Lookup	Department Lookup
Manager	Admin	Admin
Officer	AKS, REF, TGD, SVG	Service
CEO	Admin	Admin
Driver	AKS, REF, TGD, SVG	Ramp

I have a form with 3 drop-downs: cmbStation, cmbDepartment, cmbJobTitle. I set the Items function to'Station NEW'.Title and similar for other components.

How can I establish a connection between these three drop-downs? I tried to set for cmbDepartment Items:

Filter(Department_NEW, IsBlank(cmbStation.Selected) || Station.Title in cmbStation.Selected.Title).

And for cmbJobTitle Items:

Filter(Job_Title_NEW, IsBlank(cmbStation.Selected) || Station.Title in cmbStation.Selected.Title).

It's not working. Is it even possible to make this relationship work?

I would be extremely grateful if you could assist me. Thank you in advance!

Categories:

Building Power Apps

All responses (5)

Answers (1)

Sort by

mmbr1606 14,629 Super User 2026 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!
hey try this please

cmbStation Dropdown items property:

'Station New'.Title

cmbDepartment Dropdown

Filter('Department NEW', 'Station Lookup' in cmbStation.Selected.Title)

cmbJobTitle Dropdown

Filter('Job Title NEW', 'Station Lookup' in cmbStation.Selected.Title && 'Department Lookup' in cmbDepartment.Selected.Title)

Let me know if my answer helped solving your issue.

If it did please accept as solution and give it a thumbs up so we can help others in the community.

Greetings
v-mengmli-msft Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @beverlyg ,

Please try this.

1/cmbDepartment Items.

Filter(Department_NEW, IsBlank(cmbStation.Selected) || cmbStation.Selected.Title in StationLookup.Value)

2/cmbJobTitle Items.

Filter(Job_Title_NEW, IsBlank(cmbStation.Selected) || cmbStation.Selected.Title in StationLookup.Value)

Best regards,

Rimmon
beverlyg 27 on at

Like
a
(0)

Report
Copy link

Link copied!

Thank you!
The error I get..
Verified answer

beverlyg 27 on at

Like
a
(1)

Report
Copy link

Link copied!
The solution for my case:

cmbStation Items:

'Station NEW'.Title

cmbDepartment Items:

Filter('Department NEW', IsBlank(cmbStation.Selected) || cmbStation.Selected.Title in 'Station Lookup'.Value)

cmbJobTitle Items:

Filter('Job Title NEW', (IsBlank(cmbDepartment.Selected) || cmbDepartment.Selected.Title in 'Department Lookup'.Value) && (IsBlank(cmbStation.Selected) ||cmbStation.Selected.Title in 'Station Lookup'.Value))
v-mengmli-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @beverlyg ,

It seems that you make some modifications. If my answer helps you solve the problem, please accept it as a solution as well. Thanks!

Best regards,

Rimon