PowerApps Event Management App 12-07-2020 17:43 PM - last edited 12-07-2020 17:49 PM

[jready]

An Event Management App my boss and I created for use on our company SharePoint. Users can register for events and admins can add or edit events. It gets the data from 3 SharePoint list: Event List, Event Registration, and Event Admins. We have created some simple PowerApps before for request ticket purposes but this is the most complex PowerApp we've tasked ourselves to create to make life easier for our users. Again we are pretty new to PowerApps so please be kind in your comments. 🙂

[Faatimah]

Hi. I'm currently in the process of creating something similar to this. I just opened your msapp. Can you share the columns in the 3 SharePoint List being used for this app? trying to recreate the list as there's some errors because couldn't connect to the list. tried refreshing the connection already. I want to try to run it and see how it work for some inspiration. Appreciate it!

[jready]

@Faatimah , The 3 lists and their columns are listed below. Hope it helps.

Event List:

Title                         Single line of text
Start Time               Date and Time
End Time                 Date and Time
Seats                        Number
Canceled                  Yes/No
Notify Attendees      Yes/No
Event Location          Choice
FilledSeats                Number
RemainingSeats       Calculated (calculation based on other columns) [=Seats-FilledSeats]
Event Details            Multiple lines of text
Status                       Choice
EventTitle                 Single line of text
OpenSeats               Number
Session                    Single line of text

Event Admins:

EventAdminName       Single line of text
EventAdminEmail        Single line of text

Event Registration:

Title                              Single line of text
Registered User           Person or Group
Event ID                       Single line of text
Event Location             Single line of text
Event Details               Multiple lines of text
Event Title                    Single line of text
Event List ID                 Single line of text
Event Session               Single line of text

[artford333]

Hi --- Thanks for posting. I'm super new to all of this, and I was wondering if you could post some sample data for the SharePoint lists so that I can see how the different lists interact with each other.

[CheridBell]

Thank you for your post.  This is exactly what I'm looking for.  The problem is, I can't upload the msapp file.  Is it possible for you to provide the process you used to count the seats per session, and close the session when there are no remaining seats?  Any assistance is greatly appreciated.

Thanks 

C Bell

[Woltier]

many thanks, I was deploying this, but the registration was not working, by the fact it is not updating the Event Registration list by the submission of button 4. Was this the correct version or do you have an update? Thanks

[Johnnymald2016]

I really like they layout of this app and downloaded it. When I tried to import it though it kept giving me an error. This is my first time ever trying it out. Could you explain to me how to do it? 

[Trickity]

Greetings,

This is exactly what I am looking for. I used your source code connected to the 3 Lists as instructed but for some reasons, the app is dotted with errors (image attached). I deleted the started from scratch multiple times with same errors. 

I am wondering if you can share the logic behind the app, relationship between the 3 tables. Any additional information or instructions would greatly appreciated! Maybe you can share the app source again?

I am fairly new to Power App but I am learning about Microsoft Power Fx language so I can understand more about the structure of your app, but with so many errors, I don't even know where to begin.

Thank you!

[Trickity]

Updates ---

I made a correction on one of the headers of the Event Registration table by removing a space between the words Event and Session for the Event Session column. I also added the ID columns that were generated automatically by the system in Event Registration and Event List. This seems to have removed a whole bunch of errors, down to 2 formula errors from 23 and still have 31 in Accessibility. Will keep going at it, just want to provide an updates. 

Please let me know if anyone figured it out and got this app to work ok.

Thanks!