Unanswered

Microsoft forms

(0) Share

Report

Posted on by Community Power Pla...

Hallo 🙂 I have a question about the flow. I want to get one E-Mail after 10 people fill the Form. How can i change the option to get only one E-Mail after ten people fill the Form? Thank you in advance for the Information.

All responses (2)

Answers (0)

Community Power Pla... on at

Like (0)

Report

Re: Microsoft forms

Hallo,
so I need to copy the URL Link of the Form that I create and paste the link in the documents right? After that create a Sharepoint list with a number type column? What is the next step because it doesn`t work. Thank you for the complete information and please paste screenshots of the complete process.
with best regards
v-yuazh-msft on at

Like (0)

Report
Re: Microsoft forms

Hi @Anonymous，

If you want to get only one E-Mail after ten people fill the Form, you must save the person response number somewhere so when the number is equal to 10, send the email in flow.

For example, you could create a sharepoint list with a number type column, and then create a item to save the person response number, the Initial value is 0, the you could create the flow to update the item to add 1 to the person response number when a new response is submitted.

I have made a test on my side, you could create the Number type column as below:

And you could create the first item in the new list as below (Because the first item's id would be 1):

You could refer to screenshot below to create the flow:

The expression in the Number column in the Update item action as below:

add(body('Get_item')?['Number'],1)

The expression in the Condition as below:

@equals(add(body('Get_item')?['Number'], 1), 10)

When the response is submitted for 10 timea, the flow would send the email as below:

Best regards,

Alice