Answered

Gallery buttons being visible or hided issue

(0) Share

Report

Posted on by DarkRoboHunter

I am currently creating an "Event Registration" app. I have a Gallery that has all the sessions that people can sign up for. There is a "Seats Available" column and a "Seats Taken" column. When an event is added the user will input how many seats are available for the event. I have two button in the gallery called "Registered" and "Unregistered". There are multiple events in the gallery and when someone registers for an event I want to hide that button and show the unregistered button if they change their minds. The issue I am running into is that my current way of hiding and showing the buttons only work if only one account is using it. Once someone else signs up for an event the buttons get all weird and people can start unregistering other people and mess up everything. Any suggestions?

Categories:

Building Power Apps

I have the same question (0)

All responses (6)

Answers (1)

Sort by

WarrenBelz 156,458 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @DarkRoboHunter ,

Please share the code (in Text) you are currently using to hide the button and why it only works on one account.

Was this reply helpful? Yes No
DarkRoboHunter 31 on at

Like
a
(0)

Report
Copy link

Link copied!

Registered button Visiable: If(ThisItem.Seats=0,false, true) And If(LookUp('Event Registration',SessionID=ThisItem.'Event ID',SessionID),false, If(LookUp('Event Registration',UserEmail = User().Email,UserEmail),true,If(ThisItem.SeatsTaken=0,true,false)))

Unregistered button visible: If(LookUp('Event Registration', Title= ThisItem.Title,Title), true, false) And If(LookUp('Event Registration',User().Email='User Email','User Email'), true, false)

Was this reply helpful? Yes No
WarrenBelz 156,458 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @DarkRoboHunter ,

]It is doing what it is asked

If( LookUp( 'Event Registration', Title= ThisItem.Title, Title ), true, false ) And If( LookUp( 'Event Registration', User().Email='User Email', 'User Email' ), true, false )

The second part is only showing if the 'User Email' field matches the current user's email - if you want an Orf(0 statement here, all you need on the Visible is

LookUp( 'Event Registration', Title=ThisItem.Title ).Title || LookUp( 'Event Registration', 'User Email' = User().Email ).'User Email'

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Visit my blog Practical Power Apps

Was this reply helpful? Yes No
DarkRoboHunter 31 on at

Like
a
(0)

Report
Copy link

Link copied!

It still isn't quite there. It is showing in all gallery items. I have 2 lists that these buttons are tied to. One called, "Event Registration" where when you click the "Registered" button it creates an item from the "Sessions" list where the items in the gallery are hosted to the "Event Registration" where itt adds all required columns and also adds the user's info to it.

Then all I am trying to do is see if the items' SessionID(from "Sessions") is equal to EventID(from "Event Registrations) and the User().Email is equal to User Email(from "Event Registrations") then the "Registered" button hides. Then the opposite happens on the "Unregistered" button where it shows the button.

I added and played around with the logic you (@WarrenBelz) provided but I am facing the same issue. Thank you for your help! I really appreciated!

Was this reply helpful? Yes No
WarrenBelz 156,458 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @DarkRoboHunter ,

If you simply want alternate visibility and the first formula is working for you, just change the second button Visible to

!YourFirstButton.Visible

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Visit my blog Practical Power Apps

Was this reply helpful? Yes No
Verified answer

DarkRoboHunter 31 on at

Like
a
(0)

Report
Copy link

Link copied!

Nothing was working quite right once someone else tried to sign up for an event. However, I did figure out a workaround that took out the LookUps and instead used MS Flow to update an event item to add the individuals' emails then check the User().Email is in Attendees' Email column. Thank you for your help!

Was this reply helpful? Yes No