Forum Discussion

PerfPC's avatar
PerfPC
Copper Contributor
Nov 14, 2018

Retrieve existing MS Forms Data into SharePoint List (FLOW)

Hi All,

 

Currently I have a multitude of forms all working well in the below function;

 

When a user submits a form, the required fields I have selected are exported into a SharePoint list, all working fine but... this raises a question!

 

Existing form data on a few forms were not setup with this existing flow, is there anyway to export the "existing" data responses to the form into a SharePoint list, I know this works well on a "live" submission but I have some forms which have many responses but can't seem to find a way using Flow etc. to export this data to a SharePoint list, hope this makes sense?

 

Any help on this would be appreciated.

 

Goal for me if possible is to export "several" forms data responses into 1 SharePoint list and only with the query above will I be able to achieve this.

 

Kind Regards

SharePoint Online

2 Replies

  • ChrisWebbTech's avatar
    ChrisWebbTech
    MVP
    Nov 15, 2018
    Only options really are to do a flow reading an exported file. Or use that file and edit the destination sharepoint list on quick edit and copy and paste the results into the list.
    • PerfPC's avatar
      PerfPC
      Copper Contributor
      Nov 15, 2018

      Hi Chris,

       

      Yes I fear your right as currently we can only manually control this, it would be great for a FLOW to be able to do this, I've suggested this on the ideas.

       

      https://powerusers.microsoft.com/t5/Flow-Ideas/Retrieve-existing-MS-Forms-Data-into-SharePoint-List/idi-p/180287#M10538

Resources