Export Data from Different Survey Pages to Separate Excel Sheets

Question

Hello, Community!

I am currently trying to figure out a way to export survey data to excel, split based on the page. For example, page 1 of the survey should go to sheet 1 of the excel document, and so on. Is there a way to specify this using Power Automate? I appreciate any suggestions and thanks so much for the help!

abureaux · Answer

Short answer, yes, Power Automate can do that.

Excel in Power Automate is annoying. Stuff needs to be dropped into tables for the most part. There is a way to drop data into a non-table region of the document, but it was convoluted if i recall (I could always pull up that flow though).

How familiar are you with Power Automate? This could either be simple or super complex to do, depending on the requirements.

Neal_t_k · Answer

Not sure if python is an option for you but the script referenced here does that plus downloads all the attachments.

https://community.esri.com/t5/arcgis-survey123-blog/survey123-tricks-of-the-trade-download-survey-data/ba-p/1141835