Answered

Use Flow to create Forms survey response files

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

I want to generate a report file for each response of a survey submission and save it in a SharePoint library.

So there would be a separate file for every submitted survey. I can’t seem to find the best way to do this - it’s not possible in Flow to crate a new excel spreadsheet for example.

And when I tried doing it as a SharePoint list item it wouldn’t show the questions in the Dynamic Content list for the survey.

Any help would be much appreciated!

Categories:

General topics

I have the same question (0)

All responses (5)

Answers (1)

yashag2255 24,769 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi @Anonymous

You could try creating an HTML table in flow from the responses and then create a temporary HTML file and convert this to a pdf file and then finally delete the HTML file from the library.

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
v-yamao-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @Anonymous ,

If you want to generate a report file for each response of a survey submission, please consider using Word document instead of Excel file.

When using Word document, we could upload a word template in the library first, then populate the word template with form responses, creating a new file in the destination library.

I have set up a flow likes below for your reference:

Besides, about how to generate word documents in your flow, please check the blog at here:

https://flow.microsoft.com/en-us/blog/generate-word-documents-in-your-flows/

Best regards,

Mabel

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

We only have the basic Flow licence so can't use the Word business connection.

Was this reply helpful? Yes No
yashag2255 24,769 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

@Anonymous

Yes. I have posted a method over here:

https://powerusers.microsoft.com/t5/Using-Flows/Autocrat-function/m-p/319778#M7909

This does not involve creatign word files and the process is a bit lengthy but it works as expected.

Please check and let us know if this works for you.

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
Verified answer

Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Thanks for you help - however it seems it's not viable to autogenerate a PDF from a response in Forms using Flow.

Therefore i'm using a more advanced online forms system to do what I need.

Was this reply helpful? Yes No