PowerApps form with cascading dropdowns from SP lookup columns

(0) Share

Report

Posted on by dfarrar

Hi all!

I'm desperate for some help here.

I have a form that links to a SP list called 'Info Items'. In that form I have two lookup columns. The first column 'KeyArea' pulls from the Title column of the 'KeyAreas' list and the second column 'SubArea' pulls from the Title column of the 'SubAreas' list. The 'SubAreas' form also has a lookup column the pulls the same 'KeyArea' list.

I have tried so many different combinations of functions, e.g.:

Filter(Choices([@InfoItems].SubArea),DataCardValue2.Selected.Value in SubAreas.KeyArea)
Filter(SubAreas,DataCardValue2.Selected.Value in KeyArea.Value) - This gives me the correct data in the dropdown but won't let me write it back to the 'InfoItems' list.
Filter(Choices([@InfoItems].SubArea),Value in Filter(SubAreas, DataCardValue2.Selected.Value in KeyArea.Value))

Any suggestions will be greatly appreciated.

Thanks!

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Sort by

StalinPonnusamy Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!
Hi @dfarrar
Filter(SubAreas,KeyArea.Value=DataCardValue2.Selected.Value).Title
And also below are MS articles for dependent dropdown
https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/dependent-drop-down-lists

Was this reply helpful? Yes No
dfarrar 21 on at

Like (0)

Report
Copy link

Link copied!

No luck I'm afraid. The dropdown works, but it won't write it back to the lookup field in SP.

Was this reply helpful? Yes No
Verified answer

dfarrar 21 on at

Like (1)

Report
Copy link

Link copied!

Never mind. I fixed it with:
Filter(Choices([@InfoItems].SubArea),Value in Concat(Filter(SubAreas,DataCardValue2.Selected.Value in KeyArea.Value),Title & ";"))

Was this reply helpful? Yes No