cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Karen_H
Helper I
Helper I

Power App to track registrations for classes

I have the following use case

 

Users need to be able to register for a class that has different date and time options.  Each class has a maximum 15 attendees.  If a class session has received the maximum 15 registrations it needs to drop off the options of available classes in registration app or form.


are there ant templates for this type of scenario?

1 ACCEPTED SOLUTION

Accepted Solutions
v-qiaqi-msft
Community Support
Community Support

Hi@Karen_H

Based on the issue that you mentioned, do you want to remove the class from the dropdown if it has already received the maximum 15 registrations?

Could you please share a bit more about the scenario?

I have a test on my side, please take a try as below.

In my scenario, I have a SP list to store the class related data.

ert.png

Create an App generated based on the SP list directly from the list page so that you could get an App containing 3 screens:

1. BrowseScreen for a Gallery to display all the records.

2. DetailScreen for a detail form to delete the records.

3. EditScreen for an edit form to edit the records.

Collect the Choice options for the Class column>> Set OnStart property of the App as below:

Collect(ColClass,Choices(EditGallery.Class))

Set the OnSelect property of the Combo Box corresponding to the Class column as below:

If(CountIf(EditGallery,Class.Value=DataCardValue10.Selected.Value)>=15,Remove(ColClass,DataCardValue10.Selected),ColClass)

Set the OnSelect property of the submit button as below:

If(CountIf(EditGallery,Class.Value=DataCardValue10.Selected.Value)>=15,Notify("Exceed the maximum number of applicants!",NotificationType.Error),SubmitForm(EditForm1))

Set the Items property of the Combo Box as below:

ColClass

Note: Once you select a class that has more than 15 registrations, the error message popping out to prevent you from submitting.

Hope it could help.

Regards,

Qi

Best Regards,
Qi

View solution in original post

7 REPLIES 7
JayMagness
Solution Specialist
Solution Specialist

HI,

 

I have done a couple of these for churches and other types of tracking.

 

I will send you a note and see if I can help you.

Can you also share this with me?

 

 

v-qiaqi-msft
Community Support
Community Support

Hi@Karen_H

Based on the issue that you mentioned, do you want to remove the class from the dropdown if it has already received the maximum 15 registrations?

Could you please share a bit more about the scenario?

I have a test on my side, please take a try as below.

In my scenario, I have a SP list to store the class related data.

ert.png

Create an App generated based on the SP list directly from the list page so that you could get an App containing 3 screens:

1. BrowseScreen for a Gallery to display all the records.

2. DetailScreen for a detail form to delete the records.

3. EditScreen for an edit form to edit the records.

Collect the Choice options for the Class column>> Set OnStart property of the App as below:

Collect(ColClass,Choices(EditGallery.Class))

Set the OnSelect property of the Combo Box corresponding to the Class column as below:

If(CountIf(EditGallery,Class.Value=DataCardValue10.Selected.Value)>=15,Remove(ColClass,DataCardValue10.Selected),ColClass)

Set the OnSelect property of the submit button as below:

If(CountIf(EditGallery,Class.Value=DataCardValue10.Selected.Value)>=15,Notify("Exceed the maximum number of applicants!",NotificationType.Error),SubmitForm(EditForm1))

Set the Items property of the Combo Box as below:

ColClass

Note: Once you select a class that has more than 15 registrations, the error message popping out to prevent you from submitting.

Hope it could help.

Regards,

Qi

Best Regards,
Qi

Thank you so much for this suggestion!  I will perform the steps mentioned and provide feedback as I believe this will meet our need.

unfortunately this did not work for me, i setup a  list exactly like yours and attempted to follow the instructions but my app has several errors with the formulas

Hi@Karen_H,

Could you please share your error message with me?

I have a test and the situation is confirmed on my side, everything works great.

Please make sure that you have the same column type!

Regards,

Qi

Best Regards,
Qi

My scenario has a list called Add Events that has session numbers and available seats for each event.  I have a list called Register. I would like to update the Seats by Session ID when some one registers for a session.  Currently, I have a button on the Registration form. 

 

I will try the logic provided above, but the seat count varies by session id. 

Any help is appreciated.

 

Helpful resources

Announcements
Power Apps News & Annoucements carousel

Power Apps News & Announcements

Keep up to date with current events and community announcements in the Power Apps community.

Community Call Conversations

Introducing the Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Apps Community Blog Carousel

Power Apps Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Top Kudoed Authors
Users online (1,349)