cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
New Member

File create triggered flow runs multiple times

I have a flow that is triggered by the creation of a file in One Drive for Business.  The flow itself functions as expected, but the majority of the time when I upload a file to One Drive, the Flow runs two times.  The flow is reading a file, inserting data to a database, running a stored procedure, and then sending an email.  Running more than once is problematic as a result.

 

 

 

3 REPLIES 3
Highlighted
New Member

Re: File create triggered flow runs multiple times

FlowExample.pngFlowExampleHistory.png

Highlighted
New Member

Re: File create triggered flow runs multiple times

Narrowed this down to the Excel Get Rows step.  If I use the File Identifer as the file name instead of selecting a specific file, it is causing a second flow to be spawned.  Perhaps getting the file causes a temporary file to be created and it thus triggers the flow again? 

I have found multiple references that say to use the file identifer so that you don't have to worry about what the file is called.  Seems like this is a bug.

Any thoughts on how to overcome this?

 

Also determined that if I abandon the "created file" trigger and go with an update and hard code the file name for get rows that this ALSO fires the flow a second time.  Only when I trigger based on file create and hard code the file name to be used in get rows does it properly run just one flow.

Highlighted
New Member

Re: File create triggered flow runs multiple times

I ended up doing a work around here where I added a step to copy the created file to a consistently named file.  I then reference that consistently named file in the get rows file reference.  It then runs only one time.  So, I got my flow to work, but this is still a bug in my mind.

Helpful resources

Announcements
firstImage

Super User Program Update

Three Super User rank tiers have been launched!

firstImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

firstImage

New & Improved Power Automate Community Cookbook

We've updated and improved the layout and uploading format of the Power Automate Cookbook!

thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

Users online (7,298)