Answered

Concurrency and running same flow in parallel

(0) Share

Report

Posted on by cantareroj

Dear.

I have a question about concurrency and instance of input parameters in flows. I have a flow which reads an Excel file stored in SharePoint, and this flow takes a long time (> 10 mins). What happens in the following scenario?:

I manually launch the flow. The flow open and read the input excel stored in SharePoint.
While the flow in the above point has not yet finished, I change the contents of the Excel and save the file (overwriting the file on SharePoint).

Questions:

Will the running flow get the last changes in the Excel file or is working with a "copy" snapshot of the Excel when it was started? Assume the Excel file has a lot of rows (> 100.000 for instance).
Can I manually launch the same flow again, as second parallel run, or the first flow instance must finish before?

Thanks in advance for your experienced help.

Categories:

Using flows

I have the same question (0)

All responses (2)

Answers (1)

Sort by

Sundeep_Malik 6,501 on at

Like (0)

Report
Copy link

Link copied!

Hey @cantareroj

As far as I know for excel files, they go in a lock mode and stay in locked mode for 6 minutes, so even if you run another flow it might fail with the error that file is locked.

Here is a link for it:

https://softchief.com/2022/08/03/solved-file-is-in-locked-state-sharepoint-while-working-with-power-automate/

I hope this helps 🙂

Was this reply helpful? Yes No
Verified answer

cantareroj 53 on at

Like (0)

Report
Copy link

Link copied!

Hi Sundeep.

Thanks for your comment. But based on my tests, I can launch a second flow run, while the first flow run is still running (and accessing the excel file). I do not get any error as you mention.

Regards.

Was this reply helpful? Yes No