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

I have the same question (0)

All responses (5)

Answers (0)

HadynM 279 on at

Like (0)

Report

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

Was this reply helpful? Yes No
LPlummer 6 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
HadynM 279 on at

Like (0)

Report
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

Was this reply helpful? Yes No
LPlummer 6 on at

Like (0)

Report

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

Was this reply helpful? Yes No
HadynM 279 on at

Like (0)

Report

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

Was this reply helpful? Yes No