cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Helper II
Helper II

Button acting as Text Label Status from Sharepoint Choice

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

1 ACCEPTED SOLUTION

Accepted Solutions
Super User III
Super User III

@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."

 

View solution in original post

2 REPLIES 2
Super User III
Super User III

@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."

 

View solution in original post

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!!

Helpful resources

Announcements
New Badges

New Solution Badges!

Check out our new profile badges recognizing authored solutions!

New Power Super Users

Congratulations!

We are excited to announce the Power Apps Super Users!

Power Apps Community Call

Power Apps Community Call: February

Did you miss the call? Check out the Power Apps Community Call here.

Microsoft Ignite

Microsoft Ignite

Join digitally, March 2–4, 2021 to explore new tech that's ready to implement. Experience the keynote in mixed reality through AltspaceVR!

Top Solution Authors
Top Kudoed Authors
Users online (43,331)