Hi community,
Could you please help to resolve my issue?
I'm trying to build the following flow.
- Answers from Microsoft Forms are sent to Excel Online.
- Based on some conditions it should update a row or add new row to my table.
The conditions are the following:
- If record doesn't exist - create new record;
- If record(s) exists and status is in (Done, Canceled, On Hold) - create new record;
- If record(s) exists and status is not in (Done, Canceled, On Hold) - update record.
For me challenge here is that there are several rows can be present in the Excel that need to be updated.
Here is my flow:
Once I get an answer from my form I'm checking if the record for this user already exists in the table
Return this as an array and add a condition to add new row or update a row:
Issue is with "Yes" branch -> Update a row:
I'm trying to find rows that match requestor names and updates only some of them that aren't done.
But now it updates only the first row.
Here is my table example:
Based on the desired outcome:
Rows 1396, 1397, 1398 shouldn't be touched.
Rows 1399 and 1400 should be updated.
