Hello, could you advise on the syntax to enable me to switch between two strings of text depending on the text values that are stored in the SharePoint list, in combination with the color-switch that is already in place on the label - described below and in screenshot attached?
If the value in the data source is "Available" I need to show the string "Available" value in the label, in a green color. If the value is anything other than "Available" (because there are all sorts of other possible values in this field in SharePoint) I simply want the text in the label to show as "Not Available" in a grey color. I need to add this to existing properties on the label:
If(ThisItem.MatchStatus.Value<>"Available",DarkGray, Green)
Solved! Go to Solution.
Hi @alygator ,
You have two settings on the Label to adjust - the Color
If(
ThisItem.MatchStatus.Value = "Available",
Green,
DarkGray
)
and the Text
If(
ThisItem.MatchStatus.Value = "Available",
"Available",
"Not Available"
)
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.
Hi @alygator ,
You have two settings on the Label to adjust - the Color
If(
ThisItem.MatchStatus.Value = "Available",
Green,
DarkGray
)
and the Text
If(
ThisItem.MatchStatus.Value = "Available",
"Available",
"Not Available"
)
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.