Answered

Fill Circle On Column Selection

(0) Share

Report

Posted on by LaMakiry

This question has been answered several times but I can't seem to get my code to work. I have a circle that I would like based off of the manager approval column. Approved=Green, Pending=Yellow, Not Approved=Red. Here is the code I am placing in the "Fill" section of the circle:

Switch(
 ThisItem.'Manager Approval'.Value,
 "Not Approved", Red,
 "Approved", Green,
 "Pending Manager Approval", Yellow
)

I'm receiving numerous errors but I'm not sure why:

Categories:

Building Power Apps

I have the same question (0)

All responses (6)

Answers (1)

Sort by

CarlosFigueira Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
If you qualify the colors with the <<Color.>> enumeration prefix, will it work?

Switch( ThisItem.'Manager Approval'.Value, "Not Approved", Color.Red, "Approved", Color.Green, "Pending Manager Approval", Color.Yellow )

Was this reply helpful? Yes No
LaMakiry 92 on at

Like
a
(0)

Report
Copy link

Link copied!

No, I tried that as well 😞

Was this reply helpful? Yes No
CarlosFigueira Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Looking at your first error (see below), is that expression inside a gallery? The 'ThisItem' keyword is only available inside galleries, to refer to the item bound to the current row.

Hope this helps!

Was this reply helpful? Yes No
LaMakiry 92 on at

Like
a
(0)

Report
Copy link

Link copied!

No this is not a gallery, just a screen (if I'm saying that correctly). I also tried an if statement but that does not seem to work either.

Was this reply helpful? Yes No
Verified answer

CarlosFigueira Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!
I believe the expressions you showed is for a data card inside a form - inside the form it can also access a 'ThisItem' value. If your circle is outside the form, you can reference the value that is set to the Item property of the form. So if the Item property is set to 'Gallery123.Selected', for example, you can update your switch statement as

Switch( Gallery123.Selected.'Manager Approval'.Value, "Not Approved", Color.Red, "Approved", Color.Green, "Pending Manager Approval", Color.Yellow)

Another option would be to reference the control on which the user selects the approval value (which in your case seems to be called 'DataCardValue83'), so your expression would look like

Switch( DataCardValue83.Selected.'Manager Approval'.Value, // or DataCardValue83.Selected.Value, not sure what the properties of your control are "Not Approved", Color.Red, "Approved", Color.Green, "Pending Manager Approval", Color.Yellow)

Hope this helps!

Was this reply helpful? Yes No
LaMakiry 92 on at

Like
a
(0)

Report
Copy link

Link copied!

Thank you! The DataCardValue option worked perfectly.

Was this reply helpful? Yes No