Problem with limit for concurrency control

(1) Share

Report

Posted on by Henning81

Hello,

I'm fairly new to Power Automate and this forum, so please forgive me if I have missed something obvious.

I'm using the Outlook trigger - When a new event is created (V3) on a special calendar, where all my shifts are added. That happens every evening for all events at the same time. Meaning all events of the previous months and three weeks in the future. So in total there are over 100 events deleted and created within seconds losing all references to the events created the evening before. I reformat those events and depending on the subject create a new event in my standard calender with availibility turned on or off. I have to keep track of the event IDs and delete the events that my flow created before to avoid duplicates.

If I leave concurrency control switched off, it kind of works with all events, but then it hangs at getting data from other connectors like deleting events (Error 204) because of to many requests at the same time. And I can't keep track of days where there are more than one shift as I fill an Excel sheet with one row per day. If that runs concurrently it is not predictable which event gets created first.

But if I turn on the concurrency control with 1 as parallel runs I get the error:

Unable to process template language expressions for trigger 'When a new event is created (V3)' at line '1' and column '110859': 'The number of items to split exceeded the limit for concurrency control enabled trigger 'When a new event is created (V3)': maximum '100' and actual '115'.'.

I did put in a condition in the trigger itself:

@greaterOrEquals(triggerOutputs()?['body/start'], addDays(utcNow(),-7))

to limit the trigger of past events. But that doesn't seem to have an influence.

What else can I do? Is there anything I miss?

Thanks in advance,

Henning

Categories:

Building flows

I have the same question (0)

All responses (6)

Answers (0)

v-jefferni on at

Like (1)

Report

Hi @Henning81 ,

The maximum 100 concurrent runs limit is by design:

Limits of automated, scheduled, and instant flows - Power Automate | Microsoft Learn

The only way I can think of is create more flows for different subjects/durations, etc.

Best regards,

Was this reply helpful? Yes No
Henning81 13 on at

Like (1)

Report

Thanks for your reply.

"The only way I can think of is create more flows for different subjects/durations, etc."
But how can I limit that? Where can I place those conditions?

Regards,

Henning

Was this reply helpful? Yes No
v-jefferni on at

Like (1)

Report
Hi @Henning81 ,

Conditions should be applied in trigger conditions as what you previously did. For example, the flow for subject A:

@and(greaterOrEquals(triggerOutputs()?['body/start'], addDays(utcNow(),-7)), equals(triggerOutputs()?['body/subject'], 'SubjectA'))

Best regards,

Was this reply helpful? Yes No
Henning81 13 on at

Like (1)

Report
Hi @v-jefferni,

thanks for your reply.

I followed your advise and reduced the matching events even more. I used the following condition in the trigger:

@and(greaterOrEquals(triggerOutputs()?['body/start'], addDays(utcNow(),-7)), not(contains(triggerOutputs()?['body/subject'], 'Abteilung')))

That would only return a few events. But still, it is trying to process all events.
Here is the whole trigger code:

{ "type": "OpenApiConnection", "inputs": { "parameters": { "table": "XXX" }, "host": { "apiId": "/providers/Microsoft.PowerApps/apis/shared_office365", "connection": "shared_office365", "operationId": "CalendarGetOnNewItemsV3" } }, "recurrence": { "frequency": "Minute", "interval": 5 }, "conditions": [ { "expression": "@and(greaterOrEquals(triggerOutputs()?['body/start'], addDays(utcNow(),-7)), not(contains(triggerOutputs()?['body/subject'], 'Abteilung')))" } ], "runtimeConfiguration": { "concurrency": { "runs": 1 } }, "splitOn": "@triggerOutputs()?['body/value']", "metadata": { "operationMetadataId": "15538dbc-b181-4e09-8ae5-7be49d5e2e51" } }

And the error messsage:

Unable to process template language expressions for trigger 'Wenn_ein_neuer_Termin_erstellt_wird_(V3)' at line '1' and column '110927': 'The number of items to split exceeded the limit for concurrency control enabled trigger 'Wenn_ein_neuer_Termin_erstellt_wird_(V3)': maximum '100' and actual '115'.'.

Was this reply helpful? Yes No
Henning81 13 on at

Like (0)

Report

Hello,

the problem still exists. Any ideas? I reduced the items that should trigger the workflow by using the trigger conditions to less than 20 items. But still it gives me this error.

Best,

Henning

Was this reply helpful? Yes No
Henning81 13 on at

Like (0)

Report

Hello everyone,

my problem still exists. The condition still doesn't reduce the number of items. Is there any other way to get my flow working again?

Or what be a good way to escalate?

Thanks.

Henning

Was this reply helpful? Yes No