Answered

Disabling a button based off multiple factors

(0) Share

Report

Posted on by QuikStudy

I have a Power App that users can use to sign up for various events. What I'm looking to do is disable the signup button for only the events in the gallery that meet one of two criteria - if either the user has already registered that the event, OR if there are no available spaces left. I previously had all of the buttons disabling if a user had enrolled for any event, with a separate condition for if there were no spaces available for a specific event.

What I have been asked to do is allow users to sign up for multiple events but prevent them from registering for the same event multiple times while still allowing them to sign up for others.

What I have sort of works. The only issue is that it's disabling the buttons for more than just what the user is signed up for. Here's the code I have for the DisplayMode property:

If(
    Value(ThisItem.OpenSeats) = 0,
    DisplayMode.Disabled,
    Text(LookUp('Event Registration',Email = varUserEmail, Email)) = User().Email, DisplayMode.Disabled, DisplayMode.Edit
)

How can I amend this to only disable the specific events that the user is registered for without affecting anything else? So far everything I've tried has broken it completely and refuses to disable anything.

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

Sort by

ronaldwalcott 3,906 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

What is your data structure? Are you looking up the same table that you are navigating in the gallery?

Was this reply helpful? Yes No
QuikStudy 29 on at

Like
a
(0)

Report
Copy link

Link copied!

What is your data structure? Are you looking up the same table that you are navigating in the gallery?

I have a SharePoint list that populates the gallery with the information for the events (Events List) which includes and maintains the number of available seats. I'm using the value from the OpenSeats column in that list to determine if there are no seats available. User registrations are stored in a separate list (Event Registration), that includes the Name of the event they signed up for from 'Events List' along with their full name and email.

I know there are probably cleaner ways to handle the data, but we're still pretty new to this and we needed something on short notice that would allow whoever would be managing it to easily add/remove events as well as easy access to the registration information.

Was this reply helpful? Yes No
Verified answer

RyanAutomates 141 on at

Like
a
(1)

Report
Copy link

Link copied!

Hi QuikStudy,

I think your problem is in using the "Lookup" function, as it will return the first record in the Event Registration table that meet your condition. I haven't done Power Fx so recently, but I think if you could put something like this to match the ID of the record you are retrieving to the ID of the item selected in your gallery, it might fix your problem:

LookUp('Event Registration', Email = varUserEmail And EventRegistrationID = ThisItem.Id, Email)

(Or whatever you use in your situation to address a unique ID for each record - perhaps the ID column in the SharePoint record)

Additionally, rather than using nested IF conditions, you could write your statement using "And"/"Or" operators like so:

If(

Value(ThisItem.OpenSeats) = 0 Or Text(LookUp('Event Registration', Email = varUserEmail And EventRegistrationID = ThisItem.Id, Email)) = User().Email,

DisplayMode.Disabled,

DisplayMode.Edit

)

Hope this helps! :)

Was this reply helpful? Yes No
QuikStudy 29 on at

Like
a
(0)

Report
Copy link

Link copied!

I needed to modify this slightly, but it did the trick.

If you're ever in the Philly area, I owe you a frosty beverage! 🍺

I think your problem is in using the "Lookup" function, as it will return the first record in the Event Registration table that meet your condition. I haven't done Power Fx so recently, but I think if you could put something like this to match the ID of the record you are retrieving to the ID of the item selected in your gallery, it might fix your problem:

LookUp('Event Registration', Email = varUserEmail And EventRegistrationID = ThisItem.Id, Email)

(Or whatever you use in your situation to address a unique ID for each record - perhaps the ID column in the SharePoint record)

Additionally, rather than using nested IF conditions, you could write your statement using "And"/"Or" operators like so:

If(

Value(ThisItem.OpenSeats) = 0 Or Text(LookUp('Event Registration', Email = varUserEmail And EventRegistrationID = ThisItem.Id, Email)) = User().Email,

DisplayMode.Disabled,

DisplayMode.Edit

)

Hope this helps! :)

Was this reply helpful? Yes No