Flow sends one email per row, need only one email sent

[ktownley]

Hi,

I'm trying to create a flow that my teammates can enter a value using forms. Then, I need Flow to go see if the value is listed in the key column in an excel table. If Flow finds it in the table, then I need it to send one email to the submission user with all the info in the columns listed in the table for that row. If Flow can't find it, I need it to send only one email to the submission user. 

The problem I'm experiencing is that Flow checks each row in the table and sends an email for each row. So if there are five rows, you get five emails. I am too new to flow to figure out how to send one email only. Either saying it found it, or it didn't.

Any help is appreciated!

[v-alzhan-msft · Accepted solution]

Hi @ktownley ,

I understand your requirement and would offer you a proper workaround if you could provided more details about your excel tble and your flow.

You could check if the value is listed in each row in the excel table in the Condtions in the flow below:

And in the Condition 2 you could check if the value is listed in the excel table, the you could send the email based on the result.

Best regards,

Alice       

Community Support Team _ Alice Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[ktownley]

Thank you so much! This got me exactly where I needed to go. My flow works just like i need it to now!