You’re offline. This is a read only version of the page.
8
I have a SharePoint list for which I have created several different workflows, mostly to send automated emails to those individuals that have added items to the list, have been assigned items, or an item that they added has been updated. The emails are relatively simple, with a paragraph of text and a few Dynamic content elements added. There are a number of nested branches within the workflow with conditions based on the value of a drop-down field called "Status". When users are updating the list, if they edit more than 2 or 3 items within a short (5-minute period), the flow becomes throttled, and sometime fails due to a "time-out". The list is being "Edited in Grid View" for efficiency. Any suggestions on how to prevent this from happening?
There is also a secondary issue....if the user spends more than a few seconds editing one of the items (rows) in the Grid view, the workflow will fire more than once, causing duplicate emails to be sent (sometimes with incomplete information if the edit is still in progress). I am using the trigger "When an Existing Item is modified" to kick off the flow. Is there a change to the flow or the list settings that can precent issue?
Oh and also you said you have conditions throughout the flows.
But do you have Trigger Conditions?
Just want to make sure we are talking about the same conditions. not the condition action, but actual ODATA style / expression filtering conditions on the trigger
If I have helped you, I would really appreciate if you please Mark my answer as Resolved/Answered, and give it a thumbs up, so it can help others
Cheers
Thank You
Michael Gernaey MCT | MCSE | MCP | Self-Contractor| Ex-Microsoft
https://gernaeysoftware.com
LinkedIn: https://www.linkedin.com/in/michaelgernaey
Hi @kmathis
unfortunatley with quick edit, there is auto save etc, so its doing that almost assuredly, plus in that mode its much more finicky, so are people clicking around accidentally etc dunno.
But would appreciate if you can mark my suggestions as the answer if it helped.
If I have helped you, I would really appreciate if you please Mark my answer as Resolved/Answered, and give it a thumbs up, so it can help others
Cheers
Thank You
Michael Gernaey MCT | MCSE | MCP | Self-Contractor| Ex-Microsoft
https://gernaeysoftware.com
LinkedIn: https://www.linkedin.com/in/michaelgernaey
Thanks for the response, Michael! I actually have Conditions set up throughout the flow, so I don't think that there is anything additional that I can do there. I was looking at the flow yesterday, and stumbled upon the Concurrency setting, and after enabling and setting it to 3, it seems to have resolved the throttling issue.
Do you have any insight on my second issue regarding the premature firing of the workflow during list quick edit?
Thanks again,
Kevin
HI @kmathis
There are 2 issues really
1. Duplicate firings due to them taking a while and or changing things to the same thing
2. You are throwing too many events in general so it is using up your resources and causing 429s(most likely) and timeouts happen.
Both of these are difficult and in many cases impossible to give you example what you want AND to stop it from happening.
1. If for instance you have a specific column you are looking for, then make sure to put a Trigger Condition on them so they dont fire all the time and across each other even if they dont need to
2. You can add some code (its not full proof) to try to check if the current condition is a duplicate. It stinks though so meh #1 is way better
You can also turn on Concurrency and limit how many can fire at a time.
Having a lot of Triggered Flows, without Conditions on the Triggers will cause massive of extra triggers so do #1 as much as you can if you haven't
If I have helped you, I would really appreciate if you please Mark my answer as Resolved/Answered, and give it a thumbs up, so it can help others
Cheers
Thank You
Michael Gernaey MCT | MCSE | MCP | Self-Contractor| Ex-Microsoft
https://gernaeysoftware.com
LinkedIn: https://www.linkedin.com/in/michaelgernaey
#1
WarrenBelz
146,601
Most Valuable Professional
#2
RandyHayes
76,287
Super User 2024 Season 1
#3
Pstork1
65,946
Most Valuable Professional
Share
Report
All responses (
Answers (
