Code to automate MS Form responses to a SharePoint list.

Question

Code to automate MS Form responses to a SharePoint list.

Anonymous

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.

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

9 answers

Answer 1

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!

Answer 2

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

Answer 3

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.

Answer 4

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.