cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
servicesGB95
Advocate I
Advocate I

Overwrite file when creating a file in SharePoint

Hey guys,

in the recent flows I created it was normal that an existing file in SharePoint was simply overwritten when it had the same name as the new file. 
Right now I am creating a flow and Automate doesn't behave like this anymore, whenever I try to create a file with the same name I get an error.
Any solutions for that?

Thanks, Julian

29 REPLIES 29
Luber
Frequent Visitor

In my case, I decided to skip it, wasn't critical since I was putting them into appropriately named folders.
But you could add an extra step to rename the file before copying it, or after. Adds unnecessary complexity but we're used to that.

Beat
Advocate V
Advocate V

@Luber I tried renaming the file before copying it but same error, file is locked for shared use, cannot rename. I've now added a delay before the Create File action, had to increment it to 9 minutes to work (hopefully) all the times, if I increase to 10, it times out. What could it be that locks that file 7-8 minutes before the flow will actually be creating (and overwriting) it?

Luber
Frequent Visitor

@Beat I've had that issue in other contexts, seems inconsistent. Then I guess try copying the file then renaming the new copy...?

hello @EnriqueC , can you kindly explain how this worked? or what does it do? 

Does it affect any long run functionalities / does it affect any data?

 

Kindly mention your answer.

Hi @soumya_12  - I do not know exactly what this does, however, it has work perfectly for the past year. One of my flows runs weekly and overwrites ~500 PDFs that are between 5MB - 50MB. No issues so far. 

 

Hope this helps. Regards.

Thanks a lot for your response @EnriqueC . 

this worked for me thank you so much!

This solution doesn't seem to work anymore. 

EnriqueC 's solution below to turn off Chunking works.

this is worked for me

Thanks a lot, it works for me.!!

Helpful resources

Announcements
MPA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

New Process Advisor Capabilities carousel.png

Read the blog for the latest news

Read the latest about new experiences and capabilities in the Power Automate product blog.

May UG Leader Call Carousel 768x460.png

What difference can a User Group make for you?

At the monthly call, connect with other leaders and find out how community makes your experience even better.

PA Survey Carousel Image.png

We want to hear from you!

If you are a small business ISV/Reseller, share your thoughts with our research team.

Users online (1,890)