MS Forms query

Copper Contributor

Hello,

We have a form that we have set the permissions to Anyone so that external people/email addresses can submit their response. Is there a way to have the external people/submitters receive an email (Receipt) that they have submitted the form and get a link (or a copy of) the form they submitted. I know this is possible when changing permissions to people inside the organisation but unfortunately we can't change the permissions to that in this instance as the email addresses are all personal addresses. 

Thank you for any guidance and help that is provided.

Aiden

 

5 Replies

@AidenOwen 

 

Please check this feature 'Allow respondents to save their responses'. It may be helpful in your case.

https://techcommunity.microsoft.com/t5/microsoft-forms-blog/you-can-now-save-and-edit-your-survey-re...

@DingkunXie Whilst that is a valid point. We'd still prefer the submitters to receive an email to confirm we have received their response. Thank you though.

@AidenOwen 

 

Another possible way is by using Power Automate flow -

1. sending response to excel https://learn.microsoft.com/en-us/power-automate/forms/popular-scenarios?tabs=classic-designer#add-f...

2. sending emails to people in the excel worksheet - https://powerusers.microsoft.com/t5/Power-Apps-Community-Blog/Power-Automate-Flow-Sending-emails-to-...

Those options are not viable as we are not sending to the same email address on each response.
It needs to go to the person who submitted the Form and because they are external/outside the organisation they are automatically filling in the form as 'anonymous.'

Thank you again though for sharing suggestions.

@AidenOwen 

 

My understanding is that your form will have a question asking the respondent to provide their email address. The first flow aims to port the new response to an Excel worksheet in each row, and the second flow will read an Excel cell value containing the respondent's email address and send an email accordingly. I haven't tried it out, so I'm not sure whether it will work or not, but it's worth giving a try.