Forms auto populate a field based on another fields dropdown selection

(0) Share

Report

Posted on 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:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

Ami K 15,685 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!
@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.

Was this reply helpful? Yes No
chris_scott 56 on at

Like (0)

Report
Copy link

Link copied!

Thank you!

Was this reply helpful? Yes No