Announcements
I have a single SharePoint list to sign up for multiple events based on a choice drop-down field. Is there a way to keep from having a person filling out the form again to avoid signing up for multiple events?
Right now the form uses a Person column. If there is a way to run through the list items and find that User1 has already been added providing a message and hiding the submit button would be ideal.
@send2mark
Yes, you can utilize a formula such as this:
LookUp(yourList, yourPersonColumn.Email = User().Email, true)
This will return true if they have completed a record and allow you to alter your app based on that true result.
I hope this is helpful for you.
Hi @send2mark
Over the long run, it sounds like you have a one to many relationship between enrollees and events. Ideally, there should be two lists, possibly even three lists with a junction table for a better description of what events the enrollees are in and to be able to list events and view the enrollees. To see how to design such an system please see my blog post https://powerusers.microsoft.com/t5/News-Announcements/Relational-Database-Principles-and-PowerApps-Step-3-Keys-and/ba-p/188640 and then how to implement it in PowerApps. https://powerusers.microsoft.com/t5/News-Announcements/Relational-Database-Design-fundamentals-Implementing-a-One-to/ba-p/200521
Thanks for the reply. I created a button for testing and set a variable. OnSelect=Set(MyVar,LookUp(Event1, Name.Email = User().Email, true)) and added a label to view if it is false or true. The variable never changes to true. Am I using this incorrectly? Event1 is the list and Name is the Person column.
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Congratulations to our community stars!
Expanding mentorship, skilling, and AI innovation
These are the community rock stars!
Stay up to date on forum activity by subscribing.
WarrenBelz 358 Most Valuable Professional
11manish 214 Super User 2026 Season 2
Mohsin Ali 185
