You’re offline. This is a read only version of the page.
One of my flows (trigger = 'when a file is created or modified') conditionally sends an email based on the value of a cell in an Excel file ('Status' = 'FA SUBMITTED'), and also updates the 'Status' field (to prevent repeated emails being sent). It ran for months without any issue, but recently it has sometimes sent multiple emails if runs happen very close together (e.g. 30 s apart). As you can see from the images below, the flow ran twice in quick succession, and I suppose the updating of the Status action from the first one did not happen quickly enough for the second run to return 'True' on the condition, which resulted in a redundant email being sent. (On the data-entry side, the 'Status' field is the last field to be entered.)
I am not sure whether multiple people editing the spreadsheet at the same time is causing this, or whether putting the condition in the trigger instead of the body of the flow might fix things, in which case, I am not sure of how to formulate the condition. Any help would be greatly appreciated!
Flow Condition
Update Status
1st Run (1/20/20 10:47:21 AM)
2nd Run (1/20/20 10:47:51)
Thanks everyone for your responses! I sort of solved the issue by inserting a Compose action that gets the last row of the Excel table and changing the multiple Condition actions to a single Switch, which is much faster and avoids the multiple triggering.
@Anonymous wrote:
The flow runs fine most of the time, it is only on occasion that it sends multiple emails, so I tend to think it is a data-entry issue. I am completely open to starting from scratch, but would also like to definitively diagnose what is causing the issue.
This is because the Excel connector has many Known issues and limitations. In recent years, Microsoft has greatly reduced the overall functionality of the Excel connectors to try and convince users to migrate off of it.
For this reason, the Excel connector is not recommended if at all possible. If you can, you may want to consider migrating your Excel table(s) to a SharePoint List. Due to the issues, the reliability of the Excel connectors for heavy workloads is spotty, at best.
👨🏻💻 If this reply answers your question or solves your issue, please ACCEPT AS SOLUTION ☑️. If you find this reply helpful, please consider giving it a LIKE 👍.
Hi Barry,
Thanks for your response. I understand the idea of an infinite loop, but that doesn't seem to be what is happening (in part because the update row only happens if the condition returns 'true', and since the update row changes the status, even if it triggers another run, then the next run should return 'false' and not modify the file thereby preventing an infinite loop, unless I'm missing something, which it completely possible).
The flow runs fine most of the time, it is only on occasion that it sends multiple emails, so I tend to think it is a data-entry issue. I am completely open to starting from scratch, but would also like to definitively diagnose what is causing the issue.
Hi @Anonymous ,
This seems to be the expected result because the trigger you set and the Update a row action conflict.
The role of the Update a row action is to change the file. After the execution of this action ends, Flow will be triggered again, and it will be triggered infinitely.
It is not recommended to configure a trigger such as When a file is created or modified and action with the ability to change files in the same Flow.
Best Regards,
#1
WarrenBelz
146,651
Most Valuable Professional
#2
RandyHayes
76,287
Super User 2024 Season 1
#3
Pstork1
65,999
Most Valuable Professional
Share
Report
All responses (
Answers (
