Unanswered

Flow execute multiple times

(0) Share

Report

Posted on by Need_Help123

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.

Categories:

Using flows

I have the same question (0)

All responses (4)

Answers (1)

Anupam.khasia 366 on at

Like (0)

Report

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)

Was this reply helpful? Yes No
Need_Help123 13 on at

Like (0)

Report

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!

Was this reply helpful? Yes No
Need_Help123 13 on at

Like (0)

Report

@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?

Was this reply helpful? Yes No
Verified answer

Need_Help123 13 on at

Like (0)

Report

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

Was this reply helpful? Yes No