Overwrite file if it already exist

[pnr]

I am having a flow where I convert some Word documents to PDF, when the Word document are being updated or created. Then it move the PDF to another location. This is all fine, but sometimes a PDF is already on the location when the flow creates a new one (step Create file 2), and then the flow fails 😐 Isn't it possible to make so that it will overwrite the existing file, if it is already there? 

[stephankline]

Hello,

Thank you very much for the screenshot and general idea of how you'd like the flow to operate.

In looking at what you have so far and your proposed result, it looks as though you may be missing a Condition control to check if the pdf already exists in the destination.  The basic logic looking something like this:

• If file exists equals "Yes", then delete the found file with the recently converted pdf. 
• If file does not exist, then create file (as you already have set up in an Action).

To see a similar working version of this for attachments, I was able to locate another thread that used a different trigger, but the end result matching up with what’d you like to do:

Save attachment to One Drive and OVERWRITE an exis... - Power Platform Community (microsoft.com)

Community Support Team - Stephan Kline

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[tom_riha]

Hello @pnr ,

the 'Create file' action doesn't have a possibility to replace an existing file. I'd say you've got two options:

1. If a file with the name already exists, delete the current file and create a new one as proposed by @stephankline .
2. Create one more "shadow" document library on the site, create the file in the new library, and then use 'Move file' action to move the file to the main library. 'Move file' will allow you to replace the file if it already exists = Power Automate will take care of the deletion/creation of the new file in the main library.

[JanHogerwerf]

I am using the replace option and it somehow works. 

But what I don't like is that it moves the old file to the recycle bin instead of overwriting.

Some files get replaced a lot and then get many files in my recyble bin. 

Can it not just overwrite the existing file? And use version history if you want to see the file that has been replaced?

Thank you!

[tom_riha]

Hello @JanHogerwerf ,

you can, but it's a bit more work: https://tomriha.com/how-to-update-not-replace-an-existing-file-in-power-automate/

[JanHogerwerf]

@tom_riha I know but was trying to avoid the extra work by using the standard function 😛

[tom_riha]

I can't even count how many hours I wasted by trying to avoid extra work... 😁