cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
ktownley
Regular Visitor

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

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!

1 ACCEPTED SOLUTION

Accepted Solutions
v-alzhan-msft
Community Support
Community Support

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:

1.png

2.png

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.

View solution in original post

2 REPLIES 2
v-alzhan-msft
Community Support
Community Support

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:

1.png

2.png

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.

View solution in original post

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

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

Users online (2,807)