if the file already exists at the target with the same name then the power automate will thorws an error.
if the expectation is to overwrite the file in the target then a simple setting needs to be turned on in Sharepoint Create File control
Turn Off Allow Chunking