I need this capability to move existing data to new versions of my Tool (see my project summary below). The data are all hosted and I think some of the workarounds I tried messed up some of the data, so I have to manually migrate and make sure the data are correct.
I have created a Tool using Survey123, web maps, hosted feature layers, ExperienceBuilder, and Microsoft Power Automate. There are several purposes of this Tool: 1) collect data regarding a landowner's interest in implementing conservation practices on their land (using 3 different surveys (with polygons) with 1 being the "Master" version that the other 2 write to and Microsoft PA), 2) keeping track of landowner contact information (survey), 3) tracking outreach efforts (using 5 different surveys with 1 being the "Master" version that the other 4 write to; point or no geometry), 4) tracking a project's implementation progress (Web maps, ExB, hosted feature layer), and 5) copying data into our organization's main reporting database (Microsoft PA). Data collected in Task 1 is also written to the "Master" database in Task 3 through Microsoft PA (more on this later). The Tool has been constantly evolving; it started out as a preliminary Tool for testing purposes, then in July I migrated the data to a production version (successfully) and now am finishing up version 2.
The data collected in Task 1 above is automatically copied to the layer in Task 3 (minus the geometry). The reason for this is to streamline reporting. The sites in the data in Task 1 can reference the same sites in Task 3, and vice versa. When there is outreach being done on a site that already has been referenced, the user fills out a survey that is automatically attributed with the GlobalID of the original record (using URL parameters). I have configured the attribute table in a map/app that when selected in the map, the user can see all records that reference the selected site, based on that GlobalID.
The problem I'm running into is that when I need to migrate data from one version of the Tool to the next, the GlobalIDs change, but the attribute that I have created (containing the GlobalID of the original record) doesn't update, too. So, the link is broken. At this point, I have just under 500 records and have to manually update this value, which is not easy. I did have a workaround the last time I had to migrate data (see
this Esri Community post), but as mentioned in update 2, it doesn't work anymore, and the subsequent "fix" did not work for me.
