Is it possiable to automate exporting form results

[jetimmer]

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

Thanks,

Jeffrey J. Timmerman

Site Reliability Engineer

Microsoft

[#2]

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

[#3]

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

[#4]

@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?

[#5]

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

Rob
Los Gallardos

[#6]

Hi @Daniel2019 

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

Cheers

Damien