Survey123 Edit Data - Edit existing row

Questions
1

:bullseye: What is your goal?

I want to make a scenario using the Survey123 Watch Survey module that is triggered by New Data and Edits and exports to Excel. I want 2 options. 1. If the Global ID exists in the current export then Update Worksheet row based in Global ID not Row ID. 2. If the Global ID does not exist then Add Worksheet row

:thinking: What is the problem & what have you tried?

I have tried Excel List Worksheet Rows but there are over 1,000 rows and increasing. I have used a Filter based on GlobalID but does not work properly.

5

Hi @Angela_Reid,

The best way to search for a row and update or create a new row is by using the following setup (Which would work the same for Excel):
low

Based on Global ID, use List Worksheet Rows: if it doesn’t find a match, create a new row and if it does find a match, update it.

Cheers,
Henk