Multiple flows concurrently adding/updating rows in excel sharepoint

[ngchumin]

Hi, 

I have a use-case of multiple flows inserting / updating rows of a table excel. 

It seems like this creates issues of concurrent updating of the xlsx (causing duplicates).

Is there any way to make the updates atomic?

Thanks!

[v-litu-msft]

Hi @ngchumin,

You could consider using the Check Out file and Check In file actions to prevent others from editing the document, and your changes from being visible until the documented is checked in.

Best Regards,
Community Support Team _ Lin Tu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[ngchumin]

Hi @v-litu-msft , 

Just a quick clarification, if I have multiple flows wanting to do checkout, is it the case that only one would succeed and the rest would block? Subsequently, after the file gets checked-in, then the other flows waiting to check out would proceed and try to acquire the check-out on the file... and so on ....

Regards, 

Chu-Ming

[v-litu-msft · Accepted solution]

Hi @ngchumin,

If a file is checking out, other flows that try to check out will fail.

You could add Do until action into the Flow, do a loop until the file check-in:

outputs('Check_out_file')['statusCode']

Configure run after setting of Delay action:

Best Regards,
Community Support Team _ Lin Tu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.