Right now, Forms doesn't send the form creator a notification email with the form response as an email attachment. So, I'm trying to building a Flow that takes the responses from a Form I've created and sends me an email with all of the responses in the body of the email.
So far, all of the users have the url link to my form. I've found a template that sends an email notifcation that a Form has been completed, but it doesn't deliniate the responses in an easy-to-read email message. Basically, I'm looking for the Flow to function as follows.
The Flow below works and can serve as a prototype for you.
You'll notice that you have an expression one of the send email actions. Here is the expression that I used.
Here's what I"m working with:
Where do I put the "formatDateTime(body('Get_response_details')?['submitDate'],'MM-dd-yyy')" expression?
In my photo above, under "Get Response details 2" what should I put in the "Form Id" field and the "Response ID" field>
You want to reference ResponseID from Dynamic properties for ResponseID
The expressions is used in the subject line of the email where you want to include the response date - see my earlier screen shots.
After I added the Response ID as you instructed, I hit save and I got an error message in the red banner that says:
The error message relates to the send email actions. Can you please expand the send email actions and post a screen shot so that I can see what the issue might be?
Can you post a screen shot of the full FormatDateTime expression?
I don't know how to grab the full screenshot (see below), but the full text reads -
Try changing the date format to 'MM-dd-yyyy'
I just noticed that I had a type in my post where I had 'MM-dd-yyy' - it should be either yy or yyyy.
Thanks @ScottShearer . Now I have two new issues:
The email to my team looks like one giant, run on paragraph (see below). How can I separate the information so that it looks more like this:
1. Username: Name
2. User email: email@example.com
Plus I received the following Flow Run failed response
Can you verify that the "Is HTML" question in th advanced section of the send email config is set to true?
Three Super User rank tiers have been launched!
Features releasing from October 2020 through March 2021
We've updated and improved the layout and uploading format of the Power Automate Cookbook!
Fill out a quick form to claim your user group badge now!