I have the following used to count down the number of available seats for a class and I want to change the "Join" button to "full" when it gets to Zero.
"Available seats : " & 12 - CountRows(
Filter(
Event1, 'Event Session'="Course 1"
)
)
Event1 is the SharePoint list
Event Session is a Text field with "Course 1" entered.