Forum Discussion
Marking Forms as Complete
Hi Megan MHumphrey77507, there's no way to add that to Forms but you are right that the way to do this is to use Power Automate to save the response to a SharePoint list and send an acknowledgement email to the responder. Then when the comments and status columns in the SharePoint list are updated a further update or "Completed" email is sent to the responder. Let me know if you want detailed steps.
Rob
Los Gallardos
Microsoft Power Automate Community Super User
RobElliottI am interested in knowing the steps on how to use Power Automate to save the response to a SharePoint list and send an acknowledgement email to the responder.
KristiLarson ain the images below the flow below grabs the form submission, emails an acknowledgement email to the submitter and also sends an email to our Wellbeing Director and saves it to a list in SharePoint. On other flows we make a bit more complex by adding the company logo or taking other actions, but hopefully this will give you some idea of a simple example.
In Power Automate the flow's trigger is the Forms "when a new respoinse is submitted". This is always immediately followed by the Forms "get items" action (NB this is quite an old flow and they've changed the name in the dynamic content box when you click in the Response Id field to just Response ID).
Next we grab the submitter's details from the Responder's email in the dynamic content box.
Next, add a Send an email (V2) action. In the first image we are sending an email to the Wellbeing Director. In the second we're sending a personalised email back to the submitter:
Finally we create an item in our SharePoint list:
Rob
Los Gallardos
Microsoft Power Automate Community Super User