
Announcements
Hello Everyone,
I have a button in a gallery and I am trying to changes the Text of the button depending if the current user(Judge) name appears in the concatenated field in the gallery.
I want text to say "Pending" when the name doesn't appear there and "Completed" when the name appears in the concatenated field.
I use the formula below to concatenate the names.
Concat( Filter( SPList, Nominee = ThisItem.Nominee && Nominator = ThisItem.Nominator && Category.Value = ThisItem.Category.Value ), If( IsBlank(Judge) || Len(Trim(Judge)) = 0, "", Judge & ";" ) )
I hope this possible to do. Any help is appreciated.
Hi @Caleb62881177,
If I understand correctly, you want to show "Pending" when the name doesn't appear in another concatenation label and "Completed" if it does. The expression would look something like this:
If(ThisItem.Name in ConcatLabel.Text, "Completed", "Pending")
Hope this helps!