cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Need_Help123
Frequent Visitor

Flow execute multiple times

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 :

Need_Help123_0-1613984718519.png

 

Screenshot of the flow running multiple times :

Need_Help123_1-1613984767889.png

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.

1 ACCEPTED SOLUTION

Accepted Solutions
Need_Help123
Frequent Visitor

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

View solution in original post

4 REPLIES 4
anupam8555
Helper V
Helper V

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)

Need_Help123
Frequent Visitor

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!

Need_Help123
Frequent Visitor

@anupam8555 

 

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?

Need_Help123
Frequent Visitor

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

View solution in original post

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Welcome Super Users.jpg

Super User Season 2

Congratulations, the new Super User Season 2 for 2021 has started!

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Users online (2,143)