Creating a file on Sharepoint Failing to Show Up

[Nicci]

Hi Everyone!
So I was working on a power automate flow this morning and it grabs data in the database and creates and excel file and uploads it to sharepoint. It was working up until about 10 minutes ago, where the flow will succeed with no errors but the file is not showing on Sharepoint.

If I re-run the job I get an error saying "A file with the same name is currently being saved to this site. Change the filename and try to save again."

Is this me, or is this another glorious Microsoft services broken issue? Thanks.

Editing for clarity: This is not a unique name issue. I have 3 unique identifiers in the naming convention that works flawlessly. The job ran fine, should have created the file, file is not there, I run it again, and that is when I get the above error message and it says 'currently being saved' meaning it is still pending which is why I dont see it on sharepoint yet. Its been 20 mins and files (new jobs coming through) are MIA still on Sharepoint with no initial error from power automate when the job ran for those files.

[SanmeshG]

Hi @Nicci  ,

As the error message states , a file with the same name already exists on the doc library , so try having a dynamic string in your filename , maybe a timestamp by using utcnow() function or by using guid() function both of these generate a unique string every time the power automate flow is run.

If this helps , please give this a thumbs up and mark this as a solution.

Thanks,
Sanmesh 

[Nicci]

Nope, sorry let me rephrase. It ran with no errors, no file has been posted, I run it again and then it states this. However in Sharepoint the file is MIA and based on the error it says 'is currently being saved' meaning it's still pending.

So my question was more is this another connector service issue from Microsoft.

[Kanika_arora]

@Nicci were you able to solve the problem? i am facing similar issue while creating/updating file from Power automate desktop. Flow runs without any error but file is not visible in sharepoint. I am doing this in a loop so few of the files are visible and few are not.

[aakashmarasini]

@Nicci I had also same issue. I had used a table for creating files which consist of unique columns to make each file name  unique. However, I ran into the issue as below.

Disabling the "Allow chunking" option on 'Create file' setting allows me to create all files correctly.

Regards,
Aakash