Unanswered

How to update dropdown selection based on another dropdown selection?

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hi,

I am working on an PowerApps that collects users' preferences on some issue.

There are multiple options and users need to rank them from 1 (most preferred) to 3 (less preferred). After collecting all users preferences, then I will make a decision based on their choices.

All the data are stored in a SharePoint list and all the controls are dropdowns.

e.g. List: Happy Friday Food Preferences

Author Chinese Food Japanese Food Italian Food

alice@example.com	1	3	2
bob@example.com	3	2	1

Chinese Food, Japanese Food and Italian Food are SharePoint list column that has data type Choice. Each Column has three items: 1, 2 and 3.

I want to limit the users, such that they cannot rank two options with the same rank, In other words, the ranking shall be unique. e.g. if Bob set Chinese Food with rank 1, then he shall not be able to rank any other options with rank 1 again.

Now I have rule to warn a user if he ranks two options with the same value and I want to improve the user experience by auto adjusting the rank if there is a conflict in ranking.

Let say user has the following preferences,

Author Chinese Food Japanese Food Italian Food

peter@example.com

If he assigns rank 1 to option Chinese Food, then the option Italian Food which is rank 1 will be degraded to rank 2.

However, I can't see any easy way to do so.

Is there any easy way to update dropdown selected value based on condition?
Is my SharePoint list structure fit for my need?
Is it a good idea to use the PowerApps to do this kind of survey?

Categories:

Building Power Apps

All responses (2)

Answers (0)

Sort by

v-yamao-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi tseki,

About 1), to update dropdown selected value based on a condition, please try if following functions will work for you:

For a test, I add two Dropdown controls, Dropdown1 and Dropdown2.

Set Dropdown1’s Items property as: ["1","2","3"]

Set Dropdown2’s Items property as: If(Value(Dropdown1.Selected.Value)=1,["2","3"],Value(Dropdown1.Selected.Value)=2,["1","3"],Value(Dropdown1.Selected.Value)=3,["1","2"])

Then the available selections for Dropdown2 will change according to the value you have selected for Dropdown1.

About 2), I guess that your SharePoint list structure should be OK.

About 3), in PowerApps, you can manage organizational data by running an app that you created or that someone else created and shared with you. Apps run on mobile devices such as phones, or you can run them in a browser by opening Dynamics 365. You can create an infinite variety of apps – all without learning a programming language such as C#. You can also extend PowerApps capabilities by registering and using custom connectors in PowerApps.

Please have a try with it. If you need more help, please feel free post back.

Best regards,
Mabel Mao
zhanie1991 2 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi Mabel Mao,

what is dropdown 1 is in text format like 'FY18' ? I am new to Powerapps, and not sure what formula to use.

Thanks
Yangjie