Button acting as Text Label Status from Sharepoint Choice

[Gigaenvy]

Hi,

I am trying to make a highly visible status area inside a gallery to show the Status of an item. I could easily use a Text Label, but decided to use a Button to act as a Text Label due to the possibilities I have with rounding corners etc with Buttons.

The end result is working except I am getting a "True" text reading inside the Button text area when the SP List item is Yes . When the SP List is No the button is hidden. Everything is working with If and the color and vis being visible or hidden.

I am trying to use a Button as a Text Label. There is no functionality in the Button other than to display Text as per the Choice in the SP List and change in Color attribute.

How can I make the Choice appear as Canceled when the choice in the SP List is Yes or Canceled? No matter what I change the choices to in the SP List, it will result in True or False (always being hidden).

The Sharepoint column 'Canceled" is a Choice Dropdown of Yes and No. I tried with Radio Button as well.

If(ThisItem.Canceled.Value="Yes",ThisItem.Canceled.Value="Yes",ThisItem.Canceled.Value="No","No")

Any help is appreciated. 

Thanks,

Tom

[mdevaney · Accepted solution]

@Gigaenvy 

From reading your post I believe what you want is the button text to be "Yes" or "Cancelled" according to the value in the SP List. My assumption here is your Choices are text values either "Yes" or "No"

If(ThisItem.Canceled.Value="Yes","Yes",ThisItem.Canceled.Value="No","Cancelled")

---
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."

[Gigaenvy]

I was so close but passing the same with a dual ThisItem.Canceled.Value. Your correction worked with a slight change to the order.

Thanks again!!