I need some help with the below and would appreciate any help / advice.
I have a created a survey whereby our personnel collect information from around the community using mostly the Survey123 mobile phone application.
When a survey response is submitted the information is displayed in a webmap, and using power automate it is also collated to an excel spreadsheet - this all works fine.
However, when a survey response undergoes an edit, currently it duplicates, adding another row with all attributes, including the edited attribute to the excel spreadsheet.
What I want to do is update the row of the initial survey response - not add a row.
The solution I had is to ensure each survey response has a unique ID that is automatically generated (I have no idea how to do this, or if I can use an object ID etc) ....
and then set a condition in power automate that once a survey response is submitted it checks to see if the Unique ID is already in the excel spreadsheet:
If it IS NOT, it adds a row
If it IS, it updates the attributes that requires updating
So my question is - will this work? and if so, what is the best way to go about creating a unique ID that automatically generates for each survey submitted? Or can I use the GlobalID somehow to do this?
Or if any one has come across a similar issue how did you go about fixing the solution.