Hello, I am trying to solve a flow problem and everything I try fails. This is extending on an existing flow that up to this point works.
I receive an email with a text file attached. That file is saved to a Sharepoint library, then the content is read in and then a new file is saved as a CSV as there is no way to change the file extension on the initial save.
However the email attachment file in txt form will overwrite with a new file each day, but the CSV file will not overwrite.
Any help to point me in the right direction would be appreciated.
Thanks
UPDATE: So after some time fiddling around I determined that I need to save the files in a temp directory, copy the file to the real directory which allows the "replace" option and then delete the source file from the temp directory.
All of this works except for the file deletion. The flow errors claiming that the file doesn't exist yet when I check the online Sharepoint directory the file is in there. Checking the outputs shows the correct path and filename.
I've solved this myself.
The solution was to save into a temp directory. Copy the update file to the real directory, then delete the file in the temp directory.
I'm already using Path. How would this method get a different result?
Hi @AK-47,
You could follow these steps to delete the temp file just created:
Best Regards,
Community Support Team _ Lin Tu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Best Regards,
Community Support Team _ Lin Tu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
WarrenBelz
146,645
Most Valuable Professional
RandyHayes
76,287
Super User 2024 Season 1
Pstork1
65,997
Most Valuable Professional