Answered

Switch buttons based on CountRows

(0) Share

Report

Posted on by send2mark

505

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.

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

Verified answer

rubin_boer 4,843 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

hi @send2mark you can set the Buttons Text with a conditional statement and display the text based on the evaluation.

Text = If(CountRows(Filter(Event1, 'Event Session'="Course 1")) = 0 , "Full","Join")

Hope it helps

Was this reply helpful? Yes No
send2mark 505 on at

Like (0)

Report
Copy link

Link copied!

If I was trying to hide the button, is this close?
Visible=If(CountRows(Filter(Event1, 'Event Session'="Course 1")) = 0 , false, true)

Was this reply helpful? Yes No
send2mark 505 on at

Like (0)

Report
Copy link

Link copied!

Actually, I tried using your with Text and it will not deviate from Join. I cannot get it to switch to Full even though it is at 0.

Was this reply helpful? Yes No
send2mark 505 on at

Like (0)

Report
Copy link

Link copied!

oh man I am sorry. So I had two buttons. The full button did not have any code. So what happened is that it was sitting above join. All I had to do was change the order. Thanks!

Was this reply helpful? Yes No