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)