Sending an email at the end of flow

[Anonymous]

I am creating a flow that has multiple switches and preceeding approvals, at the end of the flow, I would like an email to be sent that sends a link to the sharepoint list. Though I only want the email to be sent for the Yes responses. I do not want 7 separate emails sent. Here is my flow

[ScottShearer]

@Anonymous:

Since you are using a switch statement, only one approval should run.  Why not add an a condition and an email action immediately after each approval.  The condition checks to see of the item was approved.

If this addresses your issue, please mark your post as solved.

Scott

[Anonymous]

Actually, multiple switches can apply. There are 7 switches, any combination of switches can apply. each have their own approval flow. If I do as you suggested, I will get up to 7 separate email. 

[ScottShearer]

@Anonymous:

In that case, initialize an array variable before the switch statements.  If an item is approved, then append to the array.  After the switch statements, evaluate the array and send an email as appropriate.  You could convert the array into an HTML table and insert the table into the email if you want.

You could use a compose action as well.

Scott

[Anonymous]

Here is my powerapp and sharepoint list, if it helps to show the workflow 

[Anonymous]

Thank you for your response Scott! Do you happen to know a good resource to help me set this up? I'm strugging to understand arrays and how to apply it to my flow.

[ScottShearer]

@Anonymous:

I'll update this post with an example later today or tomorrow.

Can you tell me if, for the purposes of your email, all you need to know is that a certain value is set to "yes" or is there additional info that should be there as well.  In other words, if "G Drive" is set to on, is that all you need in the email or is there other info that should be there as well that relates to the "G Drive".  Basically, I'm asking if there should be more than 1 column in the array/collection.

Scott

[Anonymous]

All I need to know for GDrive is that it is 'on'. Though, going back to the original idea, I need the email to bring together all switches that = 'on'. So the Array would be something like: (if i understand)

Gdrive Yes

Hdrive Yes

Idrive Yes 

Kdrive Yes 

and so on. 

If the answer is 'No' then it does nothing. 

[Anonymous]

I tried to do this, but its still not working. Here are my steps

1. When an item is created

2. compose- createarray

3. Initialize variable

4. switch

5. approval yes or no

6. if yes, append to an array

7. create html table

8. Filter array 

Here are some screenshots

[ScottShearer · Accepted solution]

@Anonymous:

Here is a simple example of how to accomplish you goal - there is more than 1 way to get there (I could have used an array).

I neglected to add a link to the list item but that can easily be added to the email.

 First, I declare a string variable before the switch statements

 

Next, in each switch statement, if the request is approved, I append to the string variable - note that the string ends with a <br>

  

Finally, I check to see if the variable has been populated.  If so, I reference it in an email.  The email must have "is HTML" set to yes.

 

The email looks like this:

 

Give it a try and let me know if this works for you.  

If so, please mark your post as Solved.

Scott

[Anonymous]

Scott- I cannot thank you enough! This works perfectly!

[Hsharma]

hi there

i am creating automate flow to send email at the end of (In person) event. In event i have 3 speakers and 1 event.

I am getting emails but if 3 spekaers want ot send there own surveys how i can do that.

thanks