Send e-mail once capacity has been reached

[nikkiperales]

Hello, 

I am trying to create a flow that will return an e-mail indicating that capacity has been reached once "Total" for either AM or PM sessions has reached 400 attendees. 

The capacity is calculated in an excel table "AMResponses" and "PMResponses" because it is based on an input from a MS form for "number of attendees". I receive the below error. I am unsure if the error is because of the previous condition which is based on a yes/no input from the form if the user is a contractor. 

Thank you

[wskinnermctc]

I'm trying to understand where the numbers are.

A MS Form can be submitted and it has a question "Number of Attendees" which has how many attendees will be coming from that submission?

Example:

• Form is submitted and has Number of Attendees: 30
  • A row is created in the Excel Sheet AM
• A second form is submitted and has Number of Attendees: 15
  • A row is created in the Excel Sheet AM

You Excel table for AM has 2 rows and the total equals 45 attendees?

[nikkiperales]

That is correct

[wskinnermctc]

Ok, here is an example of using Increment Variable.

There will be two blank variables that are integer/number type.

• AMTotalAttendees
• PMTotalAttendees

What I am going to do is fill each one of these variables with the totals from each row in the Excel table. This is done by using an Increment Variable action which is basically like adding. So for each row/apply to each loop, the variable will be added/incremented by the value from the Excel row.

Then with each one of those variables filled with the total attendees, you can use them in a condition or where ever you want in the flow.

In my example I have a table with 5 rows and AttendeeTotal in each row:

1. Row 1 - 30
2. Row 2 - 15
3. Row 3 - 10
4. Row 4 - 5
5. Row 5 - 45

So total attendees from all of the rows is 105.

Within the Apply to Each the action Increment Variable is run on the first row it will be 30, then the next row will change it to 45, and next row changes it to 55, etc.

Each one of the variables will be filled/added within their own Apply to Each. Then they can be compared in a Condition.

Note: I used the int() function which is the Integer function that converts text to number. You should use the int() function around your values because increment variables only works with number. 

See the Integer function in Expression Function Reference

Here are screenshots of my basic flow:

Basic Overview of Flow StepsPart 1 - Increment Variable of AM AttendeesPart 2 - Increment Variable of PM Attendees and then use Condition

So this is a basic example of how to use variables and increment them to add up totals. Hopefully this is enough for you to see how it works and then incorporate it into your flow.

[nikkiperales]

Thank you! 

I'm not sure where I went wrong.