Create .csv file from FORMS answers and add it to an e-mail

Like (0) Share

Report

Posted on 6 Nov 2023 08:52:17 by Tobias_PCI

HI all,

I've created a Power Automate Flow where the Answers from Forms are combined in an e-mail. This looks like this:

Gets the response details. Then there is a switch, which differs multiple answers, but that's not important for now.

These questions are parsed into an e-mail. One with possible attachment and one without. The condition will define if there is an uploaded attachment or not. And the e-mail looks like this:

Those green entries are the answers from the Forms.

So the question is:

"I want to parse all of those e-mail answers in a .csv file and add it to the same e-mail."

It would be highly appreciated if someone could help me with this. This is a feature we want really bad.

Thanks in advance and have a great day!

All responses (1)

Answers (0)

ManishSolanki 15,085 Super User 2025 Season 1 on 06 Nov 2023 at 11:52:45

Like (0)

Report
Re: Create .csv file from FORMS answers and add it to an e-mail

Hi @Tobias_PCI

I have a sample flow for you. In this example, the MS form has 3 fields - Title, PM Name, PM Email. Here are the actions that you need to add for creating the csv file:

1. Add compose action to store the header & data row of csv file. Enter the headers in compose action & then press an enter key. In the next line, select the values from the MS form. Each header & data values are separated by comma (,) as shown below:

Title,PM Name,PM Email
@{outputs('Get_response_details')?['body/ra9a50b6b15814a51b32f6a809cc96637']},@{outputs('Get_response_details')?['body/rc8b5ed66a30e42afaa1c1813f6b7a929']},@{outputs('Get_response_details')?['body/re0245d0f5b734ff7abe650253edb4cdb']}

Now, we have csv content in compose action, we can pass it into the attachment content parameter of send an email action:

For attachment name, I have used responseId.csv in the sample flow but you could change the logic of generating the file name as per your need. Pls remember to have .csv as its file extension.

If this helps & solves your problem, please remember to give a 👍 and accept my solution as it will help others in the future.

Thanks