Export Data from Different Survey Pages to Separate Excel Sheets

[HenriettaK]

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!

[Neal-Kittelson]

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-da...

[abureaux]

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.