cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
LTHANZR
Frequent Visitor

Microsoft Forms+Limited seats for courses+Power Automate

Hello, so I´m stuck, basically, I created a form with different class options but every class just has 12 seats so the first 12 people who answer the form get the seat, I don't know how to define the variable in power automate to automatically decrease the number every time a person registers into a class.

 

Help me please community.

 

Thank you in advance.

1 ACCEPTED SOLUTION

Accepted Solutions
v-yujincui-msft
Community Support
Community Support

Hi @LTHANZR ,

 

Do you just want to collect the first 12 records of each class?

I have made a test for your reference.

 

1. Here is my Form.

vyujincuimsft_0-1646377805026.png

2. Here is my SharePoint List.

vyujincuimsft_1-1646377815712.png

3. Create a Flow.

ColumnName eq 'DynamicContent'
length(outputs('Get_items')?['body/value'])

vyujincuimsft_2-1646377910982.png

vyujincuimsft_3-1646378113782.png

Result Screenshot:

vyujincuimsft_4-1646378213813.png

 

 

Best Regards,

Charlie Choi

View solution in original post

5 REPLIES 5
v-yujincui-msft
Community Support
Community Support

Hi @LTHANZR ,

 

Do you just want to collect the first 12 records of each class?

I have made a test for your reference.

 

1. Here is my Form.

vyujincuimsft_0-1646377805026.png

2. Here is my SharePoint List.

vyujincuimsft_1-1646377815712.png

3. Create a Flow.

ColumnName eq 'DynamicContent'
length(outputs('Get_items')?['body/value'])

vyujincuimsft_2-1646377910982.png

vyujincuimsft_3-1646378113782.png

Result Screenshot:

vyujincuimsft_4-1646378213813.png

 

 

Best Regards,

Charlie Choi

Hi Charlie 

Thank you 😊 you are a legend!    This flow worked beautifully.  Cheers Liz

Thanks for the tips! It worked for me!

Thank you Charlie and sorry for the late reply.

Cuba_RJ
Regular Visitor

Hi,  @LTHANZR  I would like to season a little this recipe...

 

How can I send an Outlook invitation to the person enrolled on the session? 

 

Thanks!

Cuba_RJ

Helpful resources

Announcements
Power Automate News & Announcements

Power Automate News & Announcements

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

Community Calls Conversations

Community Calls Conversations

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

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Top Kudoed Authors
Users online (4,526)