File already exists error Dropbox - when attemptin...

sudosaurus · ‎11-01-2023

Hello,

I am using Power Automate to copy files over to a Dropbox account and whilst this works for the majority of files, there are some which just do not want to copy.

The overall error being received is this:

File '/business continuity/battlebox/ooh rotas/LiveWest OOH Rota 2023-4.xlsx' already exists. Use the Update operation to update an existing file.
     inner exception: Exception of type 'Microsoft.Azure.Connectors.Dropbox.DropboxAdapterException' was thrown.
clientRequestId: e8149ff2-c4bd-48b8-a7d5-0a31a3f91101
serviceRequestId: 9880d8f7ed4941d2b6bf289cc3888a58

The flow starts on a recurring basis at 8pm every day

Next we use a Get files (properties only) action to get the files in the "OOH Rotas" folder - there are only files in this folder (no sub-folders). Below this we then use the Get file content action to get the content of each of the files in this folder (currently there is only one file).

Based on the above, we try using the 'Create file' (Dropbox) action and if that fails, we try the 'Update file' (Dropbox) action.

Again if that fails, we then try the 'Delete file' (Dropbox) action, followed by the 'Create file' (Dropbox) action.

As you will see from the below flow run, there is a conflict on the initial 'Create file' action' and then we get a WorkflowOperationParametersRuntimeMissingValue error on the 'Update file' action and the same again for the 'Delete file' action.

The final 'Create file' action is unable to run due to the previous action failing.

If I helped you solve your problem - please mark my post as a solution and consider giving me a like if you liked my response!

If you're feeling generous you can Buy me a coffee: https://www.buymeacoffee.com/sudosaurus

v-jefferni · ‎11-02-2023

Hi @sudosaurus ,

You can use a List files in root folder action, and then in Condition checking if the file name already exists in Dropbox listed files, in true branch update a file, in false branch create a file.

Best regards,

Community Support Team _ Jeffer Ni

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

sudosaurus · ‎11-02-2023

@v-jefferni - is this how you would structure it?

If I helped you solve your problem - please mark my post as a solution and consider giving me a like if you liked my response!

If you're feeling generous you can Buy me a coffee: https://www.buymeacoffee.com/sudosaurus

v-jefferni · ‎11-02-2023

Hi @sudosaurus ,

Not the same but similar. Please refer to below screenshot:

I was using OneDrive, but Dropbox should be the same.

Best regards,

Community Support Team _ Jeffer Ni

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

sudosaurus · ‎11-03-2023

@v-jefferni - what goes into the filter array? - that bit isn't clear..

If I helped you solve your problem - please mark my post as a solution and consider giving me a like if you liked my response!

If you're feeling generous you can Buy me a coffee: https://www.buymeacoffee.com/sudosaurus

v-jefferni · ‎11-03-2023

Hi @sudosaurus ,

It's just dropbox file name eq sharepoint file name.

Best regards,

Community Support Team _ Jeffer Ni

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

sudosaurus · ‎11-03-2023

@v-jefferni

Does this look right now?

Thanks! 🙂

If I helped you solve your problem - please mark my post as a solution and consider giving me a like if you liked my response!

If you're feeling generous you can Buy me a coffee: https://www.buymeacoffee.com/sudosaurus