Hi--I have a complex business process where the Filemaker DB we use for resource scheduling sends an email to a shared Outlook inbox; I have several Flows watching that inbox, that take different actions based on keywords in the subject lines, parsing out data for other actions in the Flow. Most of those actions involve sending/updating/cancelling Outlook Events for the involved staff, and a Sharepoint List that simultaneously stores that info (primarily so I have a place to keep the Outlook Event ID, which I can't get back into Filemaker).
It's God-awful complex, but overall it works quite well, and it's the best I can do with the software/technical support I have available at my organization. But: I'm running into sporadic throttling issues, which result in Failed Runs, and am struggling to understand why it is happening, and what I can do to improve matters. From my research and advice in another board, it sounds like there could be two major issues involved. Would value any suggestions the community can provide. Is my biggest problem...
1) The sheer number of Flows--I think at this point I've got 7 or 8 discrete ones each checking that same inbox for different keyboards, and that this may be running me into some sort of Concurrent Operations limit. Would it be better to consolidate these Flows, using branching logic? Will it also help if I reduce the number of Steps in each Flow (they are admittedly crude right now).
2) The sheer number of "Emails" (Outlook Events) the Flows are generating at once. I think this is the major place I'm getting the throttling, since it's definitely happening at that Step when I review the failed runs. In the grand scheme of things, it doesn't feel like a particularly massive load of data. The biggest operation sends about 75-100 of these emails from Filemaker into the Inbox (at one second intervals), and that results in an identical number of Flow-created Events going back out. It's not clear to me what determines how "compressed" these operations are. When I watch Runs being processed, it's clear that they are not all happening at once, or even in the order received.
Thanks for your time--if I've said anything that is unclear, please let me know. Not an IIT professional, so on a pretty steep learning curve here.