Duplicated MS Form

Question

Hello MS Forms Team:

I have an original form that was inherited to me by a colleague who already moved to another department. The form is owned by this colleague, and we are having issue with one of the questions (Upload file question) since it is looking for a folder that is no longer accessible.

So, I duplicated the form, and the upload file question looks working. The file went to my Apps folder.

There is a SP list that stores all the previous 140+ responses in the old form.

1. Can I also copy this SP list and so I can merge with the new form's responses? Can you please show me how to do this? Otherwise, what can I do so the responses from old form and the duplicated form are stored in one SP list.
2. Sorry for more questions but I forgot how to check the connection between the MS form and the SP list. How are the responses auto populating the SP list, where is the setting for this in the MS forms?

Thanks very much and I really appreciate any guidance you can provide.

Answer 1

To address your questions regarding Microsoft Forms and SharePoint:

1. Copying the SharePoint List: Unfortunately, you cannot directly copy a SharePoint list that stores responses from an old form to merge with the new form's responses. However, you can manually export the responses from the old form's SharePoint list to an Excel spreadsheet and then import or append this data to the new SharePoint list that is linked to your duplicated form. This process would involve ensuring that the columns in both lists match appropriately for a successful merge.
2. Checking the Connection Between MS Form and SP List: The connection between your Microsoft Form and the SharePoint list is typically established through Power Automate (formerly Microsoft Flow). You can check the flow that is responsible for moving responses from the form to the SharePoint list. In Power Automate, look for a flow that triggers on form responses and then creates an item in the SharePoint list. The settings for this connection will be found in the flow's configuration, where you can see the trigger (the form) and the action (creating an item in the SharePoint list).

If you need to set up a new flow, you can create one that triggers when a new response is submitted in your duplicated form and then adds that response to your SharePoint list.

If you have further questions or need more detailed steps on any of these processes, feel free to ask!