Forms to Excel plus email to respondent

[alacastie]

Hello, I'm trying to build a flow for this purpose, but can't find the correct way. This should be the process:

- A user of my organization fills in the Microsoft Forms

- When the user completes the Form and sends it:

- he receives an email thanking him with an excel file attached that contains the responses 

- I receive an email telling that a new response has been submitted, again with the excel file that contains the responses

How can I manage to build this flow?
Can you help me?

Thanks!

[v-liwei-msft]

Hi @alacastie ,

Could you please tell me:

Where are your excel files stored: SharePoint or OneDrive? 

Do you want respondents to see everyone's replies or their own replies?

If you want to save the replies received by the Form in excel, you need to set up a table in excel to store the replies.

I assume you are using SharePoint's library to save the excel file.

I have made a test for your reference: 

1. Get the reply of the Form. 

2. Add the reply to excel. 

3.Get file content Get the file content. 

4. Send an email and add the excel file as an attachment

Best Regards,

Levi

[alacastie]

Hello @v-liwei-msft, thank you for your reply!

Here are my answers:

Where are your excel files stored: SharePoint or OneDrive? I can choose both: Sharepoint would be my company's space area, Onedrive it's my personal - both are okay, depends where it works better

Do you want respondents to see everyone's replies or their own replies? I would like respondents to receive a mail with only their own replies. Equally, I would like to receive a mail with only the replies of the respondent.

One thing: the Forms that respondents fill in contains a lot of fields. Hence, when I have to tell Power automate to get the content, the best thing would be to avoid specifying each single field, otherwise it would be very time consuming to specify all the single fields...  (however in the many tutorials that I saw, people always have to specify each field..)

Thank you very much,

Alessandro

[v-liwei-msft · Accepted solution]

Hi @alacastie ,

If you want each respondent to receive an excel file that only contains their own replies, you just need to add a Delete a row after sending the email.

Best Regards,

Levi