Unanswered

drop down list options based on another drop down

(0) Share

Report

Posted on by Guru6

Hi All,

I am creating skill profile. I used same collections for Current Level and Target Level drop down options. I received feedback that the target level has to be higher or the same as Current level. Please provide your suggestions how to proceed on this.

Categories:

Building Power Apps

I have the same question (0)

All responses (6)

Answers (0)

Sort by

v-dezhili-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Guru6 ,

Could you please tell me what type of column you are using in the drop down box?
I have a test that I hope can help you.
In my scenario, my data source is SharePoint, and my grade column is a choices column that only supports single selection.
LastN( Choices(List4.grade), LookUp( AddColumns( Choices(List4.grade), "lvl", Switch( Value, "level1", 5, "level2", 4, "level3", 3, "level4", 2, "level5", 1 ) ), Value = Dropdown3.SelectedText.Value ).lvl )

Best Regards,
Dezhi

Was this reply helpful? Yes No
Guru6 38 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi Dezhi,

Thank you for your reply. I'm using the Sharepoint List as Data Source and the Type is Single Line of Text. The choices in the drop down is from different Data Source Share Point List.

I added Item formula as below but If I select the first row, it updates in all the target level.

Also, I changed my Choices similar to the one you mentioned in your post. But again when I do changes down the User Level columns, suddenly it resets to all the target user level drop down lists.

Was this reply helpful? Yes No
v-dezhili-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Guru6 ,

Please try:
Switch( Dropdown6.SelectedText.Value, "level1", [ "level1", "level2", "level3", "level4", "level5" ], "level2", [ "level2", "level3", "level4", "level5" ], "level3", [ "level3", "level4", "level5" ], "level4", [ "level4", "level5" ], "level5", ["level5"] )

Best Regards,
Dezhi

Was this reply helpful? Yes No
Guru6 38 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi Dezhi,

Thank you for your detailed suggestion.

I still have the issue with auto-update to rest of the TargetLevel Drop down if I change the first user level drop down. I believe it is something to do with patching.

Here is the code snippet for on change(). I have this code for both userlevel and targetlevel drop downs (change only in the level field in patching).

Was this reply helpful? Yes No
v-dezhili-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Guru6 ,

I replaced my drop down with a combobox that only supports single selection, and used the following formula under the combobox's on change property, and it works fine.
When I change the options of the first combobox, the data source can be automatically updated, and the option set of the second combobox will change according to the first one.

Best Regards,
Dezhi

Was this reply helpful? Yes No
Guru6 38 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi Dezhi,

The suggested solution caused Patch issue and no response I had to revert it.

My code has Patch to the Sharepoint and also reload the collection immediately. I am not sure where it cause the problem. Also, the selection updates the rest of the Target user column for this recommendation as well !

Was this reply helpful? Yes No