Microsoft Forms+Limited seats for courses+Power Automate

[LTHANZR]

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.

[v-yujincui-msft · Accepted solution]

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.

2. Here is my SharePoint List.

3. Create a Flow.

ColumnName eq 'DynamicContent'

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

Result Screenshot:

Best Regards,

Charlie Choi

[lhowlett]

Hi Charlie 

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

[Cuba_RJ]

Thanks for the tips! It worked for me!

[LTHANZR]

Thank you Charlie and sorry for the late reply.

[Cuba_RJ]

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