Concurrency Control troubles.. Multiple instances of the same flow runs at the same time.

(0) Share

Report

Posted on by Liminity_Sammy

Hello.

I've made a flow where one part of it is as following:

Get Date from API > Check if Excel document contains the date >
IF not > insert date to excel > send mail saying row updated.
IF yes > send email saying row already exists.

The flow will run twice since there is two dates from API. I want it to run them after eachother, and not at the same time.

Best case scenario the first run will insert a date and send email. The second run will detect that row already exists in excel and send email saying it already exists.

But since Flows runs at the same time, both runs will write to excel and create accounts..
I've enabled Concurrency Control and set it to 1 but it still runs twice at the same time.

Note: The second time I trigger the Flow it detects that there is input in Excel. So the "flow chart" is okay..

Categories:

General topics

I have the same question (0)

All responses (3)

Answers (0)

JohnAageAnderse 1,986 on at

Like (0)

Report
Copy link

Link copied!

Hello @Liminity_Sammy

Did you find a solution to your issue or is it still relevant?

If still relevant, what did you mean by "The flow will run twice since there is two dates from API. ..."?

Are there two calls to the flow or does the one call contain two dates?

Kind regards, John

Was this reply helpful? Yes No
RPAmateur on at

Like (0)

Report
Copy link

Link copied!

@Liminity_Sammy and @JohnAageAnderse,

Any updates on this?

I have checked everywhere and no answers. Everything from my flow (trigger set to concurrency control 1) shows it would be working correctly (in theory), however the Excel updates are still not behaving correctly. The flows show they run one after another concurrently but it is like the Excel cell value is only being read and update at the same exact moment. Only thing I have seen is to set a delay of a couple minutes allowing the change to excel to 'stick' before the next flow run is in the excel changing the value again.

PAD flows never give me this issue, but I am needing this flow to be an instant cloud flow trigger to run in the background all day.

Any insight or workarounds would be great, thanks!

Was this reply helpful? Yes No
JohnAageAnderse 1,986 on at

Like (0)

Report
Copy link

Link copied!

Hello @RPAmateur
Use a list instead to catch the data coming in. Then have second flow trigger on entries being created in that list and use the flow to update your Excel. Set concurrency control to 1 in this second flow.

Additionally you can have the second flow update the list item with a value like "Used", "Not used" to indicate which one was used to update Excel.
Kind regards, John

Was this reply helpful? Yes No