Is it possiable to automate exporting form results

Microsoft

Is there a way to either export or query form results using some form of automation?

 

Thanks,

Jeffrey J. Timmerman

Site Reliability Engineer

Microsoft

5 Replies

Hi @jetimmer 

 

If your form is a Group form then there should be an Excel file in SharePoint under the Documents library.

 

If the Excel file isn't there, try opening your results in Microsoft Forms and then try again.

 

Could be automated using MS Flow from there as an example.

 

Hope that makes sense?

 

Cheers

Damien

Hi @jetimmer, if you don't want to use the built-in excel spreadsheet of results in Forms, you can use Flow to send each response to a new row in a spreadsheet. Make sure you've formatted your spreadsheet as a table, and then the flow is quite simple as shown in the image below.

Rob
Los Gallardos

Flow.png

 

@Damien Rosario  Hi Damien, I would have to have an export in a .csv file and not an .xlsx file. Is there any way to do that?

@Daniel2019  you could just export it as an excel file then in Excel save as a csv.

Rob
Los Gallardos

 

Hi @Daniel2019 

 

What Rob said is correct. There's a few CSV formats to choose from such Comma delimited.

 

Cheers

Damien