Registration System

(0) Share

Report

Posted on by Canadiansal

310

I have courses with Max Capacity for each course.

I will like for students to use the App to register for a spot in a course. The Registration will only be allowed if the Max capacity has not been reached.

If the Capacity is reached, the student will have the option of being added to a waiting list.

Is this Possible in PowerApps? Has anybody built anything similar to manage Covid return to school?

Categories:

Building Power Apps

I have the same question (0)

All responses (8)

Answers (0)

Drrickryp Super User 2024 Season 1 on at

Like (0)

Report

@Canadiansal

You should be able to do that in Powerapps. Add a single line of text type column to your list and call it ClassStatus and in PowerApps set up an If() condition based on the capacity of the class to assign students to each status.

Was this reply helpful? Yes No
zmorek 3,272 on at

Like (0)

Report

Depending on the size of your data set, this could be done with a SharePoint list and a simple form. Create a SharePoint list with all the necessary columns (e.g. LastName, FirstName, StudentID, CourseID, CourseDescription, IsWaitListed etc.). Insert a form control onto a screen, set its data source to the list, add a "Submit" button to SubmitForm and you have your basic functionality.

You can use the OnStart property of the app to compare the number of items in the list to your MaxCapacity number; if number of items in the list = MaxCapacity, OnSubmit of the form set that IsWaitListed property = true.

Was this reply helpful? Yes No
Canadiansal 310 on at

Like (0)

Report

Thanks - so I have multiple courses with Multiple Capacity Limits. How do I set this up, as a separate table or if statements in the App?
Additionally, can I send a QR code notification back to the students? Powerautomate?

Was this reply helpful? Yes No
zmorek 3,272 on at

Like (0)

Report

All you're doing is checking if the sum of a group of row's value is greater than a given number - until you start running into delegation issues, you can just rinse and repeat!

You can still accomplish this with the same list (using our same example above); you can change your property to compare those different columns. An If or Switch statement can get it done:

If(
CountRows(Filter(SharePointList, Course1AttendeesColumn=true)=Number), xxx,
CountRows(Filter(SharePointList, Course2AttendeesColumn=true)=Number2), yyy
)

I know Power Automate well, but not in the realm of QR codes. Is this to generate some sort of confirmation? Or something like "You've registered for the course, download this file"?

You can connect the Flows to the app to trigger the Flow with a Run() formula, but I don't know the QR part.

Was this reply helpful? Yes No
Canadiansal 310 on at

Like (0)

Report

So here is my table. I have included column named Total - this is a number, and I will use this to keep a running total of the registrations.
On the Form OnSuccess, I tried to do this:
Patch(DB, ThisItem, {Total:ThisItem.Total+1})

Powerapps does not like this code. I also tried putting this on the OnSelect property of the Submit Button. Same error. Is this related to the "ThisItem" call?

Was this reply helpful? Yes No
zmorek 3,272 on at

Like (0)

Report

Maybe, can you share what the error message is?

Was this reply helpful? Yes No
Canadiansal 310 on at

Like (0)

Report

Was this reply helpful? Yes No
Canadiansal 310 on at

Like (0)

Report

So I have this working. Here is my next Challenge.
I have my students in 2 Groups. Group A will get first choice to come on Campus.
Group B will stay online remote.
I will like the Group A students to be able to Register up to a certain time. After that, the Group B students can start registering (if there are spaces). The Group B students will only be granted access after the expiration of the Group A time allocation. Please let me know if this needs a new thread.

Was this reply helpful? Yes No