Answered

Using IF formula for Chioces column in Share Point List

(0) Share

Report

Posted on by Hooi

Hi All,

Currently, I would like to change my button color to Dark Blue when my column - "Status as on date" is "Completed". This column is a choice column in SharePoint List. I have used the formula below but it have formula error. What is the issue for the formula?

If(ThisItem.'Agreed timeline'="Agreed",RGBA(72, 61, 139, 1 ),RGBA(136, 160, 209, 1))

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

WarrenBelz 154,494 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!
Hi @Hooi ,

I am not sure how your code posted relates to your question as it is a different field and value, but the one you want would be

If( ThisItem.'Status as on date'.Value = "Completed", RGBA(72, 61, 139, 1), RGBA(136, 160, 209, 1) )

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Visit my blog Practical Power Apps

Was this reply helpful? Yes No
Hooi 78 on at

Like (0)

Report
Copy link

Link copied!

Hi @WarrenBelz , yes it works. thank you so much!

Was this reply helpful? Yes No