I have a flow that runs on a schedule, once per week. It has been running without issue for several months.
Today the flow failed to complete. The flow queries a series of SmartSheets to get their rows, then applies a process against every row. Some sheets have app 100 rows, the largest sheet has over 2,000 rows.
The flow stalled in the middle of processing the rows of the largest sheet. I have no way of identifying where it is stalling (I cannot get access to that detail on a running flow). I modified the flow to add "logging", essentially saving to a SharePoint list before processing each row the current data and time and counter value for the row being processed. I ran this audit version of the flow. It always stalled at between 1,000 and 1,200 rows. Not always stalled at the same point. I even deleted the first 1,000+ rows from the SmartSheet to see if it was either stuck on a particular row or if there were too many rows (even though that that was not an issue in the past few months). After deleting many rows, when I run the flow, it stalls at between 40 and 60 rows? The number of rows it can process keeps dropping.
I typically cancel the run after it has stalled for a long time, but I have seen it stall for a while and then start back up after a long pause, only to stall again.
I am wondering if I am hitting some sort of license or throughput limit I am not aware of.
