Hi @Anonymous @lschafroth ,
To check for any existing file exists with same name, you can use the following solution
- Set a variable to collect the file number to append
- Add a Do until - the loop runs until it finds no conflict with file name, if a conflict is there, it will increase file number and loop continues
- Once there is no conflict, the loop exits and we can decrement the file number to use it in file name
I have passed a static file name here "Book.xlsx". In case it's dynamic for you, you can split the file name with "." and the file name to check would be first(split(#filename, '.')) + fileNumber + last(split(#filename, '.'))
Hope you find this helpful! 🙂
Kind Regards,
Shaik Sha
________________________________________________________________________
If I have answered your question, please mark the post as Solved.
If you like my response, please give it a Thumbs Up.
