Answered

Conditional Formatting-Getting an Error

(0) Share

Report

Posted on by Sherri

I am working on a machine ordering App and I copy and pasted in a value, however it is giving me an error and an "invalid argument". Does anyone know of an alternate value I can use for a conditional formatting to highlight machines over $10,000.

Here is the value: If(ThisItem.Price>10000,OrangeRed,Gray)

Categories:

Building Power Apps

I have the same question (0)

All responses (8)

Answers (1)

Sort by

turnerj3 2,039 on at

Like
a
(0)

Report
Copy link

Link copied!

Your color values aren’t being accepted, try using quotes around the colors or another syntax

Was this reply helpful? Yes No
turnerj3 2,039 on at

Like
a
(0)

Report
Copy link

Link copied!

Color.Gray ColorValue( "#808080" )
ColorValue( "Gray" )
Color.OrangeRed ColorValue( "#ff4500" )
ColorValue( "ORANGERED" )

Was this reply helpful? Yes No
TheRobRush 11,128 Moderator on at

Like
a
(1)

Report
Copy link

Link copied!

yah, I would double check the colors like turner suggested, easiest way is just delete until you are at the If(statement, and then start typing the first color then select form the choices it suggests, then add comma start typing second color and again click on one of its suggestions.

sometimes if you just copy and paste from elsewhere the prog doesnt recognize it as a color

Was this reply helpful? Yes No
Sherri 15 on at

Like
a
(0)

Report
Copy link

Link copied!

Thank you @turnerj3 & @TheRobRush I have tried all suggested variations. Unfortunately, I am still getting errors. Not sure why the color is not being recognized. Thanks for your help.

Was this reply helpful? Yes No
turnerj3 2,039 on at

Like
a
(0)

Report
Copy link

Link copied!

Keep showing the errors, we can figure

Was this reply helpful? Yes No
TheRobRush 11,128 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

works fine for me, maybe save close and reboot

Was this reply helpful? Yes No
turnerj3 2,039 on at

Like
a
(0)

Report
Copy link

Link copied!

If(ThisItem.Price>10000,Color.OrangeRed,Color.Gray)

Was this reply helpful? Yes No
Verified answer

Sherri 15 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi,
I actually changed the value to: If(ThisItem.Price>10000,Color.Red) and it cleared the error. Thanks

Was this reply helpful? Yes No