Update rows errors within switch every other row.

[iainoneill]

Error for every other row not updating

I am using a flow to do the following:

1. Lots of other things not relevant.
2. Check if a row is present in a table:
1. if it isn't add a row onto the first table
2. get that row
3. add it into a second table
4. add it into a third table
5. update this first table saying the other two updates have been done.
1. Use a switch to do different things depending on the region:
2. update a row in the first table to say an email has been sent - This stage fails -
3. get the row which has been updated
4. Change a cell based on the organisation name
5. Make an image for emailing
6. Make an image for a word document
7. populate a MS Word Template
8. send an email with the word document attached.

The flow alternatively succeeds (1) and fails (0) at step 1.5.1 every other row in a pattern as follows. 1,1,0,1,0.

The error message indicates that the row which should have been added at step 1.1 has not been added.

When I reran with the final four rows it again errors with 1,0,1,0.   

When I rerun just the failed rows it succeeds 1,1

I thought it might be that attempting to complete the switch step (1.5.1) while it had the file locked for the subsequent apply to each so I set concurrency to 1 but got the same results. 

1. do you think it is to do with the way app access Spreadsheets for the apply to each at the same time as the switch?

I wanted to see what the community thought of my two ideas for the next steps?

1. add wait steps to try and give the app a chance to allow the excel sheet to unlock
2. add a rerun step at the end to scoop up failed rows and try to pass the failed rows through the switch again at the end of a run.