You’re offline. This is a read only version of the page.
13
Recently, I created a flow that append new rows of data from an Excel file (let's call this new_rows.xlsx) to the main excel file. The flow was able to run but it run more than once. Precisely, it ran twice and then it ran again after 5-10 minutes interval. in total, it has ran for four times and I have no idea why the flow is behaving like this. Fyi, the trigger I'm using is "When a file is modified (Property Only)" on the new_rows.xlsx which will be modified by my Python script.
Screenshot of my flow :
Screenshot of the flow running multiple times :
I have no idea why the flow is behaving like this. I am thinking of adding a condition into the trigger but I have no clue where to start! Any help will be appreciated, thanks.
I found out that using the trigger "when a file is modified" is very buggy and sensitive. Hence, I change the trigger into "when file is created" and the flow was able to run without errors or duplicates
It turns out the get trigger requires premium account and I want to avoid that since my project doesn't allow using on free trials software. Can you perhaps elaborate to me more on how to solve my problems by using different flows for updating?
Hello @anupam8555 ,
I have never used JSON before hence I'm not sure how to create the call format for appending data to xlsx file. Could you give me an example on how to do this???
thanks!
Hi @Need_Help123 ,
It looks like your flow is being triggered on file update and its getting called also when you are updating same file from flow. I think you should have separate file to update from python script and separate from flow which you are updating. Or if you just want to trigger your flow from python script than you can trigger your flow with action "HTTP Request recieved" .
https://flow.microsoft.com/fr-fr/blog/call-flow-restapi/
Let me know if it works for you.
Thanks
Anupam
(Please mark resolved or give kudos if it really helps you)
#1
WarrenBelz
146,609
Most Valuable Professional
#2
RandyHayes
76,287
Super User 2024 Season 1
#3
Pstork1
65,946
Most Valuable Professional
Share
Report
All responses (
Answers (
