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
MPA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

secondImage

Are Your Ready?

Test your skills now with the Cloud Skill Challenge.

Top Solution Authors
Users online (58,731)