Create Change Log for Survey

[jdokemaps]

We can create a changelog via Integromat of Microsoft Flow to record a row in a spreadsheet every time a survey is submitted or edited via Survey123. I have set up a basic version of this and will continue to test.

[pjdohertygis]

We have taken this as far as we can - we need help with R&D. Microsoft Flow seemed really promising but we keep getting errors.

Is anyone proficient with Microsoft Flow or Integromat that wants to prove this out?

We are trying to create a backup of every waypoint and all changes made. Integromat may be better. https://flow.microsoft.com/en-us/connectors/shared_survey123/survey123/

[jdokemaps]

This is what I had running, but it failed so many times it turned itself off.

[afackler]

I can look into this. I've seen it work with Google Sheets but I haven't tried with Microsoft 365

[afackler]

Good news - I got it to update a spreadsheet using onedrive and a survey I have. I'm going to develop it a bit more but the concept is working as it should.

[nzjs]

Hi - Paul directed me to this thread.

We use MS Flow for this with our water quality samples. It logs any new records in Excel Online, we use a onedrive group shared folder.

I think the main thing you want to look into is: When a Survey123 response is submitted -> Add a row into an Excel Online (Business) sheet

One requirement is you need to create the Excel Online file first, and insert a new table into it. From there you'll be able to select the correct file/table to use.

Not sure how it works with editing existing surveys - interested to hear if that works for you.

Lastly, to display timestamps correctly, you'll need to use Excel formulas to convert the Unix timestamp to a human readable format: (where F2 is my original Survey123 date field, and D2 is a temporary column): D2 =LEFT(F2,10) & "." & RIGHT(F2,3) E2 =(((D2/60)/60)/24)+DATE(1970,1,1)

[pjdohertygis]

We should investigate if this will also be a capability within ArcGIS Velocity.

[pjdohertygis]

Added to our Velocity card in Planner https://teams.microsoft.com/l/entity/com.microsoft.teamspace.tab.planner/tt.c_19:WQQU-GLBt5PUCaamNqbuPkjLTt8tsICkDpvbXmW_T541@thread.tacv2_p_PQ35VCIfNU2Eeb0TdloUJmQADk0f_h_1636482835657?tenantId=e78bd32c-e20a-42de-9956-6429fc41698d&webUrl=https%3A%2F%2Ftasks.teams.microsoft.com%2Fteamsui%2FpersonalApp%2Falltasklists&context=%7B%22subEntityId%22%3A%22%2Fboard%2Ftask%2FJeq41V8xmk2ZI8YuqJ5CdmQAHQeY%22%2C%22channelId%22%3A%2219%3AWQQU-GLBt5PUCaamNqbuPkjLTt8tsICkDpvbXmW_T541%40thread.tacv2%22%7D