Forum Discussion
SharePoint Event - Participant Registration
Hi,
Do we have a solution for event registration with SharePoint event?
I asked ChatGPT and it ensured me there is "Enable Event registration" under event details when you create an event. I couldn't find it anywhere, nor any online documentation. I guess the AI is having hallucination.
Right now, for SharePoint event, we use Forms in the detail for people to register. But we don't know how to control or limit the participants or having a waiting list function.
Or online Zoom events, Zoom provide registration function so we could kind of managing using Zoom. But it is less relevant as you want participants registration more for in-person events.
Any ideas?
Thanks.
The flow I mentioned in the previous post looks like this.
After the when a new response is submitted trigger and the get response details action add a get user profile action to get the details of the user who has registered. Then initialise a variable set the type to float.
In your SharePoint list make sure you have a number column for the number of participants registering - for some of our courses a user might register 2 or 3 people from their team. You can set the default to 1.
To count the number of people registered add a set variable action, select the variable and then add the following expression (changing the NumberOfParticipants column to whatever name you've given your number column):
xpath(xml(json(concat('{"root": { value:', outputs('Get_items')?['body/value'], '}}'))), 'sum(//root/value/NumberOfParticipants/text())')Next, add a condition of varCount is less than 25
In the green if yes channel add a create item action to add a new iten into the list. Then add a Send an email (v2) action or a send an email from a shared mailbox action and add the "you're registered" text.
Finally in the red if no channel just add the email action with the "sorry...." text. You could then have a create item action to add this user to another list for a future event.
Rob
Los Gallardos
Microsoft Power Automate Community Super User
- AFAIK,
The SharePoint Events list does not provide that feature and the only place where we have something similar to this in Microsoft Teams nhtkid from an event registration request from Forms we use a flow in Power Automate to check a list in SharePoint and count how many people have registered. If the number is less than the maximum number of participants, for example 25, the flow saves the form response into the list and sends a "you're registered" email. If it's more than 25 it sends a "sorry, the event is fully booked" email.
Rob
Los Gallardos
Microsoft Power Automate Community Super UserThe flow I mentioned in the previous post looks like this.
After the when a new response is submitted trigger and the get response details action add a get user profile action to get the details of the user who has registered. Then initialise a variable set the type to float.
In your SharePoint list make sure you have a number column for the number of participants registering - for some of our courses a user might register 2 or 3 people from their team. You can set the default to 1.
To count the number of people registered add a set variable action, select the variable and then add the following expression (changing the NumberOfParticipants column to whatever name you've given your number column):
xpath(xml(json(concat('{"root": { value:', outputs('Get_items')?['body/value'], '}}'))), 'sum(//root/value/NumberOfParticipants/text())')Next, add a condition of varCount is less than 25
In the green if yes channel add a create item action to add a new iten into the list. Then add a Send an email (v2) action or a send an email from a shared mailbox action and add the "you're registered" text.
Finally in the red if no channel just add the email action with the "sorry...." text. You could then have a create item action to add this user to another list for a future event.
Rob
Los Gallardos
Microsoft Power Automate Community Super User- Hi Rob,
Thank you so much for your detailed explanation.
I will follow your example and give it a go.
One question, we are adding the Forms link into each SharePoint event details for people to sign up. And the count would only happen once user submit the registration form and trigger the flow.
That means the exceeded person will always fill the form not realising it wasn't successful until the email arrives?
