Forum Discussion
Getting info from MS Forms as email in addition to populating an excel.. How to
Maybe you can tell us what kind of readable format you want, and I can see if there are any relevant solutions that can meet your requirements.
What I would need is the information in an outline like the actual form so either each question with its answer or a pdf of the same.
Is that possible?
The excel is just not helpful
Ask any further questions for clarity
Regards
Denise
Microsoft
Thank you for the information. Forms does not currently provide a feature that allows you to automatically generate the format you need for responses, but we can manually generate a PDF format for each submitted data using the following steps -
1. Navigate to "Responses" view and click "View results" button.
2. Click navigation button to select the response you want to export as PDF.
3. Click "More options for Responses" button and select "Print response".
4. Select "Save as PDF" and click "Save" button to export as PDF file.
Another approach is to leverage the Power Automate tool to help you automatically create a PDF for each row (response data) in an Excel workbook that is synced with your form's response data, you can refer to this thread for the details of how it works - https://powerusers.microsoft.com/t5/Building-Flows/Create-PDF-FOR-EACH-row-in-Excel-table/m-p/340597#M37229
- Thanks very much for this
I will check out if Power automate is a feature available within the organization but if not then I can manage the other method of getting the pdf
Huge thanks for taking the time to help me . You've been brill
