Answered

Getting a Dropdown field to auto populate text to another field

(0) Share

Report

Posted on by chucksta

I am having the issue with the naming of the combobox of a sharepoint list item.

What I am trying to do is make what ever selection a user selects in the RTO dropdown box, that it will autofill a text field box labeled "Critical".

What I am doing is a form that is running from Sharepoint list.

I select Customize with Powerapps and enter this if statement in the Default field of the Critical text box,

Currently I have a support intake form that I am currently building for my company and we have a Sharepoint list that has a:

I also have a "Critical" field on the form that is currently a text field which I want to make this field autopopulate which ever dropdown item a user chooses from the Recovery Time Object (RTO) field and also color code based off the selection from the RTO field.

Screenshot 2

RTO Color Field needed to popluate to Critical field:

Example of what I an requesting: if a user pick option "A" from RTO dropdown in the screenshot 1. above, it then places the selection RTO Rating in the Critical Field in red as High (Critical) as seen screen shot 2 above.

I wish it could make the whole field turn the color of the selection, like highlighting the whole field in the selection in the corresponding collors but not sure if that could be done, so the critical field would look like this:

Categories:

Power Apps portals

All responses (10)

Answers (2)

Sort by

Verified answer

Edwin-Abdalian 641 on at

Like
a
(1)

Report
Copy link

Link copied!

I created a comboBox called cmbRTO with Values of A,B,C,D,E
Table({RTO: "A"}, {RTO: "B"}, {RTO: "C"}, {RTO: "D"}, {RTO: "E"})
1- Make sure to set the SelectMultiple property to false
2- Set the Text property of your label to cmbRTO.Selected.RTO (replace cmbRTO with your control, and RTO with your column's name)
3- Set the Fill property of your label to:
Switch(cmbRTO.Selected.RTO,"A",Red,"B",Yellow,"C",Green,"D",GreenYellow,"E",LightBlue)------------------------------
Please Accept as Solution if this post answered your question so other members can find it. If you found this post helpful consider giving my post a Thumbs Up!
chucksta on at

Like
a
(0)

Report
Copy link

Link copied!

@Edwin-Abdalian Thanks for replying sir.

So this is the part that is currently hard to change as I am not sure what the combo cards name would be to change it. The value shows datacardvalue35 for the field, now would I need to change the whole RTO card or the RTO card field?

Whole RTO Card:

OR the Field value: DataCardValue35
Verified answer

Edwin-Abdalian 641 on at

Like
a
(1)

Report
Copy link

Link copied!

use DataCardValue35.Selected.Value(or the column name, it will suggest you when you start typing in)
chucksta on at

Like
a
(0)

Report
Copy link

Link copied!

@Edwin-Abdalian You are a GOD send sir!! Thats works as it should per your instruction.
One more thing is there a way that instead of getting the RTO text to populate to the text field, i could instead get it to populate to the text below: if a selection was made something tlike this below:

SO basically instead of "A. 0-8 Hours" showing in my text field, it would show ?
Edwin-Abdalian 641 on at

Like
a
(1)

Report
Copy link

Link copied!

Yes you can, use the switch function again on the Text property of your textbox
Switch(DataCardValue35.Selected.Value,"A. 0-8 Hours","High(Critical)","B. 8-24 Hours","Elevated", ...so on)

--------------------------------------------------------------------
Please Accept as Solution if this post answered your question so other members can find it. If you found this post helpful consider giving my post a Thumbs Up!
chucksta on at

Like
a
(0)

Report
Copy link

Link copied!
@Edwin-Abdalian it seems when i changed it it didnt make the change.
I just added one line to check but it stayed the same am I supposed to be editing it at the Text mode or format. text field in the shot:

I also used this to test first, before completing the whole statement:

Switch(RTO.Selected.Value,"A. 0-8 Hours","High(Critical)")
Edwin-Abdalian 641 on at

Like
a
(1)

Report
Copy link

Link copied!

I thought that red box is a label. but it's a text input. you need to add the switch function to the Default property of it
chucksta on at

Like
a
(0)

Report
Copy link

Link copied!

@Edwin-Abdalian so I can have two switch functions in the default field for the datacard29(Critical) text box?
The Default property for the critical text box is where I added the first switch you gave me for the RTO to show up, is that where i need to add the switch also for the text to show up instead of the drop down entries as well?
Edwin-Abdalian 641 on at

Like
a
(1)

Report
Copy link

Link copied!

No, the first Switch was onthe Fill property to change the color, the second swaitch is on the Default property to set the value
chucksta on at

Like
a
(0)

Report
Copy link

Link copied!

@Edwin-Abdalian I got it to work. Should have tried it before prematurely responding. Man thank you a lot for your help this completes my form! You sir will be blessed! So easy a process thanks to you and your knowledge. I cant wait to go to Ignite next month to learn more about this product. Powerapps and Flow has been a life saver for me. Thanks again sir. I will mark your suggested solutions sir.