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? 

[HEATFreight]

Oh and another thing to add!

The SharePoint "AddAttachment" action in Power Automate does not seem to be capable of concurrently editing the same record. So, in my use case, we can't use "AddAttachment" to simultaneously upload several files to the same list item. However, "CreateFile" has no such limitation, so you can concurrently upload as many files as you need to.

I suspect that if you are working with document libraries instead of list items, then maybe you don't have to worry about the concurrency issue because you are already working with a folder path, like how "CreateFile" works. I suspect in that situation, other methods besides "CreateFile" may be able to concurrently upload multiple files, because your target is a folder. But when the target is a list item (still a folder but not treated as such when using "AddAttachment"), multiple simultaneous uploads are not allowed, except when you specify the list item using folder notation, as with the "CreateFile" action.

tl;dr: Treat it like a folder ("CreateFile") and you can go asynchronous with your uploads. Treat a list item like a list item ("AddAttachment"), and you face the limitation of one file at a time.

[Anonymous]

Great!

Have you also checked setting concurrency control to 1 in the 'add attachment' step? And maybe building in delay after each attachment?

Just a suggestion. But as usual involves trial and error. Even if you build it correct it might still not work.

[HEATFreight]

No, the whole point is for everything to run as fast as possible so the user doesn't have to wait.

The concurrency must be set to some number greater than 1, ideally something just larger than the maximum number of expected files to be uploaded, otherwise they would run sequentially and take N times as long, where N is the number of files.

That's a terrible user experience. You can run "CreateFile" with as much concurrency as your heart desires (up to the max of 50) and it will add as many files simultaneously to the same record as you need it to.

"AddAttachment" is limited in that it can only upload one file to a SharePoint list item at a time. Simultaneous file uploads to the same list item will error out with something like "the record is already being modified".

"CreateFile" just works.

Like I said previously, the run time of this flow has been reduced by roughly 50% or more simply by concurrently running "CreateFile" instead of (first deleting all existing conflicts before) synchronously running "AddAttachment".

My flow is already just about as optimized as it can get.

[vikas1606]

It's an old thread but worth sharing if someone has the same issue. As @HEATFreight  mentioned above. I recently did this by turning off "Allow Chunking" in Create File setting. You can try to replace the existing file with a new file.

[Nic-AF]

I don't have "Chunking" in my CreateFile action settings.

I simply put a Delete action before the Create.  It doesn't seem necessary to check if the file already exist or not.  If file doesn't exist, the Delete doesn't complain.  To be safe, I configure the Create to run after Delete even though Delete fails.

[Anonymous]

Hmm that will work but then can use the replace option. Also deletes the file.

And also removes history.

But anyway thanks for the suggestion