Microsoft Forms and lists

Extracting Data From Forms Into SharePoint

Microsoft Forms can be considered one of the most underrated Office 365 services available on the market. However, MS Forms is an excellent resource for enabling efficient user experience within the Microsoft cloud universe.

Although it is often thought of as a simple surveying tool, its new features have been designed to streamline and enhance your experience of accessing, creating, and distributing forms.

In this third installment of our Power Up With Power Apps series, we will cover how to Extract Data from Microsoft Forms into SharePoint.

Storing MS Forms Responses in SharePoint Lists

You can easily store MS Forms responses in SharePoint Lists. You can also create a PDF document from the responses of the Forms and store it in SharePoint.

To do this you can use one of theTemplatesin Power Automate calledRecord form responses in SharePoint.

Prerequisites:

• Create an MS Formby going to //www.office.com/launch/forms and selecting New Form.
  Create a SharePoint List in your SharePoint site with the Form fields as Columns.
• You can quickly do this by:
  • Saving the MS Form Response as an Excel spreadsheet.
  • Creating a SharePoint List in your SharePoint site > Selecting From Excel > Uploading the Excel spreadsheet > Customizing the columns you want.

Modifications required:

• Change the Form ID to point to your MS Form.
• Change the Site Address to point to your SharePoint site.
• Change the List Name to point to your SharePoint list.
• Add the Forms Response fields to each SharePoint Column in the Create Item action.
• Save and test the workflow.

Automating the Forms Process

When a new response is submitted, each response will be saved in the SharePoint list.

To create PDF documents of the Forms response, customizations will have to be made to the Power Automate workflow.

For the next part of the workflow,

• UseData OperationComposeaction to create an HTML file.
  • You can use a HTML code generator to create the format like //html-css-js.com/html/generator/
  • Add theSharePoint Create ItemorGet response detailscolumns next to each field you want to show in the PDF.

• UseOneDriveCreate fileaction to create a .html file.
  • You can create a folder in your OneDrive to save all the .html files.
  • Add this path to theFolder Pathby navigating to it by selecting the Folder icon.
  • Add a file name then add [FileName].htmlto theFile Namefield.
  • Add theOutputsproperty from theComposeaction to theFile Contentfield.

• UseOneDriveConvert fileaction to convert the .html file to a .pdf file.
  • Add theOneDrive Create fileIDproperty to theFilefield.
  • Change theTarget typetoPDF.

• UseSharePoint Add an attachment to itemaction to attach the pdf file as an attachment to the list item. You can also store it in another location of your choice.
  • Change theSite addressto point to your SharePoint site.
  • Change theList nameto point to your SharePoint list.
  • Add theIDof the SharePoint Create Item action.
  • Add a file name then add [FileName].pdfto theFile Namefield.
  • Add theOneDrive Convert File File Contentproperty to theFile Contentfield.

• Save and test the workflow.

When a new response is submitted, each response will be saved in the SharePoint list as an item, and a PDF file of the responses will be created and saved as an attachment to the list item.

Your final workflow should look like this:

Learn More

Want to discover more about Power Apps? Read more here

Learn more concepts like Extracting Data From Forms Into SharePoint through our Power Up with Power Apps Series.

Contact us to get started or learn how you can implement and use the SharePoint Integration in Power Apps for maximum collaboration and productivity.