Unanswered

Linking Cascading Dropdown Box value/text to 2nd box with a Different Choice Column

(0) Share

Report

Posted on by LPlummer

I have a Form Powerapps I am needing help with. Basically, I have 2 drop down boxes. The first box contains 4 selectable choices, that have a corresponding SharePoint Choices Column containing the list of choices I want them to choose from. I have the first box working. I can pick one of the four categories needed.

I need to know how to have to second box display the Choices column that corresponds to the value of the first.

I know this isn't right, but it's the logic I'm trying to get and the best way to say what I'm thinking.

If box1 value or text = person, then, box2 displays person column choices

If that makes any sense

Thanks in advance!

Categories:

Building Power Apps

All responses (5)

Answers (0)

Sort by

HadynM 279 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @LPlummer
This is the best video I have seen for a foundation understanding on cascading dropdowns:
https://www.youtube.com/watch?v=pkZG2boN7jQ
Hope this helps.
Hadyn
LPlummer 6 on at

Like
a
(0)

Report
Copy link

Link copied!

That's actually one of the videos I've copied step by step from.

The only difference I can see is he's using an excel sheet to pull the data, and I need it to pull from columns in the same list on sharepoint.
HadynM 279 on at

Like
a
(0)

Report
Copy link

Link copied!
Awesome.
To continue using Shane's example and if the data is usually pretty static, just import the SharePoint list as a collection when the screen becomes visible or the app starts:
ClearCollect(JobTitles, mySPListDataSource)
Then reference the collection for the cascading dropdowns exactly as you would the original datasource.
Using this method I have managed a three-tier cascade that works fast for the end-users.
Cheers
Hadyn
LPlummer 6 on at

Like
a
(0)

Report
Copy link

Link copied!

Just confirming, this would also go in the "item" tab for it's function, where I am putting the second dropdown?
HadynM 279 on at

Like
a
(0)

Report
Copy link

Link copied!

For the example, the ClearCollect goes in the Screen1.OnVisible property.
Screen1.OnVisible = ClearCollect(JobTitles, mySPListDataSource)

The dropdown item values remain the same as the video.
DropDown_Dept.Items = Sort(Distinct(JobTitles,Department),Result)
and
Dropdown2.Items = Distinct(Filter(JobTitles,Department=DropDown_Dept.Selected.Value),JobTitle)
Cheers
Hadyn