Build an Event Registration App with Power Apps, SharePoint & Power Automate (No Code Tutorial)

Summary

In this video, Korab from KnowHow Academy walks viewers through the process of creating an event registration application using PowerApps and SharePoint. The tutorial covers key steps, such as setting up a SharePoint list for event registrations, building an app with two screens (one for user registration and one for an admin dashboard), and incorporating custom validations. Additionally, Korab explains how to integrate Power Automate to send confirmation emails upon registration. The video offers practical insights into building a streamlined event management system with minimal screens and functionalities.

Takeaways

• 😀 Create a SharePoint list to store event registration data, including fields like name, email, phone, event type, and number of attendees.
• 😀 PowerApps can be used to create a simple event registration form with data validation, including restricting phone numbers to 10 digits and marking fields as required.
• 😀 The event registration app consists of two main screens: one for registering attendees and another for the admin dashboard to view registrations.
• 😀 The admin dashboard in PowerApps uses a vertical gallery to display registration data, including participant names, event type, and the number of attendees.
• 😀 PowerApps allows you to calculate the total number of attendees and categorize them based on the event type, using functions like `count rows` and `sum`.
• 😀 You can control visibility in PowerApps by setting conditions, such as showing the admin dashboard button only for event organizers based on their email.
• 😀 The app can be enhanced by sending a confirmation email to users upon successful registration using Power Automate.
• 😀 Use Power Automate's 'when an item is created' trigger to automate the process of sending confirmation emails after a new registration is added to the SharePoint list.
• 😀 Custom validation can be added in PowerApps for fields like phone numbers and email, ensuring accurate data entry from users.
• 😀 The app can be made more user-friendly by providing success notifications upon registration, informing users they have successfully signed up for the event.

Q & A

What is the main purpose of the event registration application discussed in the video?

The purpose of the event registration application is to allow users to register for an event, manage the event data, and send confirmation messages to those who have registered.

What are the key features of the event registration list created in SharePoint?

The event registration list in SharePoint includes columns for user name, email, phone number, event type (seminar, webinar, or workshop), and the number of attendees.

How does the event registration form in Power Apps handle user submissions?

In Power Apps, the registration form uses a submit button to submit the form. After successful submission, the form resets, and a success notification appears to confirm the registration.

What is the purpose of the admin dashboard in the Power Apps event registration application?

The admin dashboard allows event organizers to view the registration data, including attendee names, emails, event type, and the number of participants. It also displays the total number of registrations and attendees.

How is data validation implemented in the event registration form?

Data validation ensures the phone number is exactly 10 digits, and it makes the name and email fields required. If the phone number format is incorrect, an error message is shown, and the border color of the input box turns red.

How does the Power Automate flow work to send confirmation emails?

The Power Automate flow is triggered when a new item is created in the SharePoint list. It sends a confirmation email to the user’s email address with their registration details, including the event type they registered for.

What is the function of the visibility condition for the admin dashboard button in the Power Apps?

The visibility condition ensures that only users with a specific email (like the organizer’s email) can see the 'admin dashboard' button, preventing unauthorized users from accessing the admin features.

How can the total number of attendees be calculated in the admin dashboard?

The total number of attendees is calculated by using the 'sum' function on the attendees column in the event registrations SharePoint list. Additionally, categories like seminar, webinar, and workshop can be filtered and summed separately.

What steps are taken to ensure the phone number field in the registration form is validated correctly?

The phone number field is validated by checking that the entered number has exactly 10 digits. If the number is incorrect, an error message appears, and the border color of the input box turns red.

How does the registration process work for users and admins in the app?

Users can register for an event via the 'Register Event' screen, while admins can manage the registrations and view attendee details via the 'Admin Dashboard'. The app also includes a main screen with buttons that navigate to these screens.