Forms auto populate a field based on another fields dropdown selection

Like (0) Share

Report

Posted on 2 Apr 2024 07:47:39 by chris_scott

Hi,

I am new to power apps and trying to work my way through a basic app for submitting requests. The ultimate aim is for this to feed into planner using automate. One function I would like to take advantage of is planners priority system. It works off numbers, where specific numbers refer to the level of priority.

In my forms I have a dropdown for urgency. I want this to auto populate another field based on what is selected, where I can use the numbers that correspond in planner. The priority number field will be hidden so the user will not see this.

Can someone help me with the formula please and where to put it? I have been trying to use IF statements with field names to try get it to work, but I can't, and put it in the 'update' section of the data card.

Priority Field is Priority_DataCard4, but Priority (Priority0) under thisItem list.

Priority Number field is Priority_DataCard1, but Priority Number under thisItem list.

Categories:

Using Apps Using Formulas

All responses (2)

Answers (1)

chris_scott 56 on 03 Apr 2024 at 10:50:07

Like (0)

Report

Re: Forms auto populate a field based on another fields dropdown selection

Thank you!
Verified answer

Ami K 15,665 Super User 2024 Season 1 on 02 Apr 2024 at 16:25:10

Like (0)

Report
Re: Forms auto populate a field based on another fields dropdown selection

@chris_scott - in the Update property of Priority_DataCard1, you can use.

Switch( Dropdown1.Selected.Value, "Urgent", 1, "High", 2, "Medium", 3, "Low", 4 )

I understand that this DataCard will be hidden, but if you want to display the priority number for testing purposes, you can apply the above to the Default property of the Text Input control instead.