Let's POWER Automate

From no-code to low-code

Menu
  • Expressions
  • Filters
  • General
  • Triggers
  • Application specific solutions
    • Dataverse
    • Excel
    • Forms
    • Planner
    • Outlook
    • SharePoint
    • Teams
  • Resources
  • Get help with flow
Menu

How to store input from MS Forms form into SharePoint list

Posted on August 9, 2020April 14, 2021 by Tom

“I built MS Forms form to gather data from other users, but I can export in only to Excel in the tool, how can I get it into SharePoint list for further processing?“


Storing data from MS Forms form into SharePoint list gives you many possibilities. You can share the data, organize it, or even add some logic on the background using Power Automate. But before you start with all of this, you must store it into the SharePoint list.

Prerequisites

  1. MS Forms form (you probably already have one since you want to store the submitted data, maybe even embedded into a SharePoint site)
  2. List in SharePoint to store the data, you need a separate column for each question on the form

Building the Power Automate flow

  1. Start from Automated flow (from blank) with a trigger When a new response is submitted (Microsoft Forms).
  2. Select your form in the Form Id field (flow will run if new response for this form is submitted). Add the Get response details (Microsoft Forms) action (to collect data from the submitted form).
  3. Add Create item (SharePoint) action, to create the new item for the submitted response in the list you prepared. Update the SharePoint item data with the data from the response (incl. date fields).
  4. Save the flow and test it.

Note: if you’ve got multiple questions with the same name, you can identify them with a single test run.


Do you struggle with the various expressions, conditions, filters, or HTTP requests available in Power Automate?

I send one email per week with a summary of the new solutions, designed to help even non IT people to automate some of their repetitive tasks.

All subscribers have also access to resources like a SharePoint Filter Query cheat sheet or Date expressions cheat sheet.

Zero spam, unsubscribe anytime.

3 thoughts on “How to store input from MS Forms form into SharePoint list”

  1. Reg Ferreira says:
    November 4, 2022 at 12:46 pm

    Hi Tom,
    I created a content type in SharePoint, then added columns of varying formats for the data that comes in via a MS Forms response, I then use a MS Word template stored in SharePoint document library to populate the responses from the MS Forms response.

    In the word template document, all content type fields are placed in strategic places using the MS Word quick parts option. The idea being that from this template a new document is created each time with the specific input from the MS form.

    Do you suggest that I should abandon the notion of using a template file in SharePoint and rather just store the values from forms in SharePoint then set-up a 2nd flow (or extend the current one) to extract SharePoint stored values to create my document? To be honest I would just like to optimise the flow and get to my objective of creating a document that can either be used as is or further edited at users’ discretion…

    Reply
    1. Reg Ferreira says:
      November 4, 2022 at 12:49 pm

      PS Tom, my post in power automate community is here: https://powerusers.microsoft.com/t5/Building-Flows/Dealing-with-NULL-s-in-Power-Automate-using-coalesce-function/m-p/1856042

      here you will see the mess I am getting myself into by following different ideas and methods just to actually try deal with NULL values coming in from MS Forms …

      Reply
    2. Tom says:
      November 13, 2022 at 6:34 pm

      Hello Reg,
      using a template file in SharePoint is a standard approach that I also use in some solutions. You can create the file directly using the data provided by the MS Forms, if you don’t need it for anything else. Get the Forms response, get the file content, create new file using the file content and update its properties.

      Reply

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Do you know what to do, but not how to do it?

Get The Ultimate Power Automate expressions cheat sheet and translate your thoughts into flows with ease!


NEW! Master the HTTP requests to SharePoint with a new cheat sheet!

Do you struggle with the various expressions, conditions, filters, or HTTP requests available in Power Automate?

I send one email per week with a summary of the new solutions, designed to help even non IT people to automate some of their repetitive tasks.

All subscribers have also access to resources like a SharePoint Filter Query cheat sheet or Date expressions cheat sheet.

Zero spam, unsubscribe anytime.

Hello and welcome!

My name is Tom and I'm a business process automation consultant and Microsoft MVP living in the Czech Republic. I’ve been working with Microsoft technologies for almost 10 years, currently using mainly Power Automate, SharePoint, Teams, and the other M365 tools.

I believe that everyone can automate part of their work with the Power Automate platform. You can achieve a lot by "clicking" the flows in the designer, but you can achieve much more if you add a bit of coding knowledge. And that's what this blog is about.

To make the step from no-code Power Automate flows to low-code flows: using basic coding knowledge to build more complex yet more efficient flows to automate more of your daily tasks.

  • Use Power Automate to forward Outlook events upon registrationJanuary 29, 2023
  • Why the condition is false for the same numbers (Power Automate)January 25, 2023
  • How to forward event invitation to other calendar (Power Automate)January 22, 2023
  • Run ‘For selected item’ flow from non-default environment (Power Automate)January 18, 2023
  • Hide button in SharePoint list after Power Automate flow startedJanuary 15, 2023

Power Automate blogs worth visiting

Damien Bird
Dennis (Expiscornovus)
Paul Murana

©2023 Let's POWER Automate | Theme by SuperbThemes