Share via

Code to automate MS Form responses to a SharePoint list.

Anonymous
2023-04-26T22:05:34+00:00

I created a MS Form and want to send the form responses to a SharePoint list. Do I need VBA or XML code to achieve this? If so, where do I insert the code.

Microsoft 365 and Office | SharePoint | For business | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments No comments

9 answers

Sort by: Most helpful
  1. Anonymous
    2023-04-27T22:43:52+00:00

    Webbrewers,,

    I tried using a power automate template for this action. I got partial results. In fact, I haven't had much luck with the other templates. Not sure MS wastes time posting useless templates. I suspect it's a sales & marketing department ploy. I'll try building from scratch as you suggested.

    Thanks!

    1 person found this answer helpful.
    0 comments No comments
  2. Anonymous
    2023-04-28T04:53:36+00:00

    Dear TAL,

    Thanks for your updates.

    As Webbrewers mentioned, you can follow the steps to create the flow.

    Here is a demo flow for your reference.

    Result:

    If you have more requirements on the flow, please upload the screenshots showing the form and the SharePoint Online list you created and give some examples about your requirements for our reference.

    Note: Remove private information before uploading the screenshots.

    Thank you for your effort and time!

    Sincerely

    Cliff | Microsoft Community Moderator

    0 comments No comments
  3. matt howell 3,511 Reputation points
    2023-04-27T21:55:22+00:00

    I'm not sure my Microsoft has not created such a solution.

    They have - Flow (aka Power Automate), but you do have to build the Flow. It's easier than you might think and requires no code knowledge (unless you need a lot of customization).

    The basics are:

    Create a Sharepoint list with the fields you want to include from the form

    Create an automated Flow

    Trigger: when a new response is submitted to your form

    Action: get response details (Forms) (choose "response id" from the dynamic content option)

    Action: Create item (under Sharepoint options) and you'll see the list fields on the left. Map the form fields to the list fields using the dynamic content picker

    Save it and test using the manual test option or submit a form.

    0 comments No comments
  4. Anonymous
    2023-04-27T18:12:36+00:00

    Hi Cliff,

    The form I created is not for my use. It is for another staff member. I wanted to send Form responses in real-time to a SharePoint list that the staff person can view and analyze as the responses come in. My organization does have Power Automate licenses but the platform requires VBScript, JavaScript, PowerShell and Python coding, which I am not very well versed in to create any kind of solution. What is really needed is a solution to map data fields from data columns of one database to another database. I'm not sure my Microsoft has not created such a solution.

    0 comments No comments
  5. Anonymous
    2023-04-27T05:20:10+00:00

    Dear TAL,

    You don't need the code to do that.

    You can export the form result to Excel and then import the Excel data to a new SharePoint list.

    How do I export my form responses? - Microsoft Support

    Export an Excel table to SharePoint - Microsoft Support

    If you want to automatically populate the form response to a SharePoint list when a new response is submitted, you can consider using Power Automate.

    Record form responses in SharePoint | Microsoft Power Automate

    Types of Power Automate licenses - Power Platform | Microsoft Learn

    Welcome to share any updates when you have time if you need further help on this issue.

    Thanks for your understanding.

    Sincerely

    Cliff | Microsoft Community Moderator

    0 comments No comments