cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Tshulha
Level: Powered On

sending approval email to the form respondent

Hi. I want to send an approval email to the form respondent if an answer to the question "Is SAP access required?" is yes. Is there any way to build this flow? The respondent's  email is recorded automatically in the form's responses spreadsheet.

Thank you!

1 ACCEPTED SOLUTION

Accepted Solutions
Tshulha
Level: Powered On

Re: sending approval email to the form respondent

Thank you, Ed.

I reconfigured my task to just send a notification with instructions is SAP was selected.

I used the following approach with condition to solve my task:

https://flow.microsoft.com/en-us/blog/using-forms-with-flow-to-automate-onboarding/

Tanya.

2 REPLIES 2
Highlighted
Super User
Super User

Re: sending approval email to the form respondent

@Tshulha 

Hi there, totally possible.  There might be a more elegant way, but here's how I did it:

 

You've got your Forms trigger "When a form is submitted", right?  And we know that as soon as we add the response stuff, Flow kicks off an Apply to Each loop, which means that if we put the approval inside that, we'll get an approval for each response answered (ie 10 approvals if 10 questions on the form).  So we need to collect the email address inside the loop, and then do the approval outside of the loop.  

What I did after the trigger was initialize a String variable.  This will give me someplace to store the email address and carry it out of the loop.20190725a.PNG

Then, we add the "Get Response Details" and let Flow make an Apply to Each loop.  Right after that (inside the loop) we add our condition to check the answer of the SAP question:20190725b.PNG

and if it's Yes, then we append the Responders eMail to the String variable.  I added a semi-colon just in case it added the email address more than once, but it didn't.20190725c.PNG

 

Then, outside of the loop, we look to see if there's anything in the string variable.  If they checked "no", it should be blank, and we don't want to start an approval.  If it's Yes, then we start the approval and use the variable as the Assigned User (I'm presuming all of the form responders will be on your tenant).20190725d.PNG

 

Everything else should be how you probably already have the approval.  What do you think?  

Either way, keep us posted.

 

-Ed-

 

 

If this reply has answered your question or resolved your challenge, please consider marking it as a Solution. This helps other users find it more easily via search.

 

Tshulha
Level: Powered On

Re: sending approval email to the form respondent

Thank you, Ed.

I reconfigured my task to just send a notification with instructions is SAP was selected.

I used the following approach with condition to solve my task:

https://flow.microsoft.com/en-us/blog/using-forms-with-flow-to-automate-onboarding/

Tanya.

Helpful resources

Announcements
firstImage

Microsoft Business Applications Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

firstImage

Watch Sessions On Demand!

Continue your learning in our online communities.

Power Platform 2019 Release Wave 2 Plan

Power Platform 2019 Release Wave 2 Plan

Features releasing from October 2019 through March 2020

thirdimage

Flow Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

fifthimage

Microsoft Learn

Learn how to build the business apps that you need

sixthImage

Power Platform World Tour

Find out where you can attend!

seventhimage

Webinars & Video Gallery

Watch & learn from the Flow Community Video Gallery!

Top Kudoed Authors
Users Online
Currently online: 224 members 4,588 guests
Please welcome our newest community members: