Unanswered

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

I have the same question (0)

All responses (5)

Answers (1)

mmbr1606 14,605 Super User 2025 Season 2 on at

Like (1)

Report
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

Was this reply helpful? Yes No
v-mengmli-msft on at

Like (1)

Report
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

Was this reply helpful? Yes No
beverlyg 27 on at

Like (0)

Report

Thank you!
The error I get..

Was this reply helpful? Yes No
Verified answer

beverlyg 27 on at

Like (1)

Report
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))

Was this reply helpful? Yes No
v-mengmli-msft on at

Like (0)

Report

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

Was this reply helpful? Yes No