Answered

Send a file generated from Forms to an email

(0) Share

Report

Posted on by acotter

Hi everyone,

I've been trying to set up a flow that gets triggered by a Forms submission. Depending on what they select for one of the questions, a response will be sent to a number of different individuals. I am able to set this up easily. What I'm looking for advice about is how to attach a file with the Forms responses to the email that is sent. I don't care if it is a PDF, Excel file, Word etc... it just needs to contain the Form responses. I looked at the Muhimbi converter (HTML table to PDF) but I do not want to pay any subscriptions. I also do not want to host the file in my OneDrive. Any thoughts on this?

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (2)

Verified answer

yashag2255 24,769 Super User 2024 Season 1 on at

Like (0)

Report

Hey @acotter

If you want to send as a PDF, it either needs to be on OneDrive or needs any of the premium actions. Same goes for Word. If you don't care about the file format and do not want to save it any where on SharePoin or OneDrive, you can send it as a .html file.

Hope this Helps!

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

Was this reply helpful? Yes No
acotter 10 on at

Like (1)

Report

This was perfect! appreciate the help, one final caveat. I created a CSV table instead of HTML, is there a way to transpose the row data into column data for the "append to array variable" step?

Was this reply helpful? Yes No
Verified answer

yashag2255 24,769 Super User 2024 Season 1 on at

Like (0)

Report

Hey @acotter

Nope. The append to array will get you the key value pairs and the keys will be the headers (columns) and individual elements as row items.

Hope this Helps!

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

Was this reply helpful? Yes No