Jun 08 2023
- last edited on
Aug 03 2023
I have a sharepoint page with embedded form and its used to make referrals for a clinic. The info on the forms really needs to go 2 places ( at least) afterwards
I'm not a techie but need to get some advice to sort this so hope someone can guide me
Thanks muchly in advance
Jun 08 2023 05:47 PMSolution
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.
Jun 13 2023 01:37 AM
Jun 13 2023 02:18 AM
@DeniseHD the best way to do this is with a flow Power Automate which will send an email to the people running the clinic with the questions and the answers as each form is submitted. It doesn't have to be a complex flow, something like the following simple example:
Microsoft Power Automate Community Super User
Jun 13 2023 02:52 AM
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...
Jun 13 2023 08:11 AM