Answered

Dropdown Fill Change When Value is Changed from Current Record

(0) Share

Report

Posted on by jaanihsm

300

Hi. How do I change the fill of a dropdown when the value is changed in Edit Mode? I am able to do it with Text and Date fields but not with dropdowns. Thanks.

Categories:

Building Power Apps

I have the same question (0)

All responses (6)

Answers (1)

Sort by

Rajkumar_M 3,747 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @jaanihsm

Try this formula in dropdown Fill Property:

If(
Dropdown1.Selected.Value = "1", // Change this condition based on your dropdown values
Color.Red,
Dropdown1.Selected.Value = "2",
Color.Yellow,
Color.Green
)

You can use "Switch" function instead of "If"

Switch(
Dropdown1.Selected.Value,
"1", Color.Red,
"2", Color.Yellow,
Color.Green
)

Thanks!

If my response has been helpful in resolving your issue, I kindly request that you consider clicking "Accept as solution" and "giving it a thumbs up" as a token of appreciation.

Was this reply helpful? Yes No
jaanihsm 300 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks for the response @Rajkumar_404 ! I'll try this.

Is there a way to simplify though? White fill if the value has not been changed from record, yellow if value is changed to whichever (regardless of dropdown value) as long as value is not the same in the SP list, they want to change it in Edit Mode. Thank you for your help!

Was this reply helpful? Yes No
jaanihsm 300 on at

Like
a
(0)

Report
Copy link

Link copied!

HI @Rajkumar_404. Is it possible to have something similar to this? This is what I have for texts and dates fields. Thank you!

If(Parent.Default <> Parent.Update, Color.Yellow, RGBA(255,255,255,1))

Was this reply helpful? Yes No
Verified answer

Rajkumar_M 3,747 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!
Try this

If(
Dropdown1.Selected.Value <> ThisItem.YourColumnName,
Color.Yellow,
Color.White
)

Was this reply helpful? Yes No
jaanihsm 300 on at

Like
a
(0)

Report
Copy link

Link copied!

I get the <> in error. And the message is:

This formula uses scope which is not presently supported for evaluation.

Was this reply helpful? Yes No
jaanihsm 300 on at

Like
a
(0)

Report
Copy link

Link copied!

Oh this worked! I just had to switch some codes:

If(ThisItem.'ColumnName'.Value <> DropdownName.Selected.Value, Color.Yellow, Color.White)

Thank you @Rajkumar_404 ! 😊

Was this reply helpful? Yes No