We will copy the Excel file that we processed to the Processed folder and then delete the original file. Here are the steps to do so:
- Add a new Step action with the title Move to Processed Folder.
- Add a File Copy action and choose the Source file as your original SO Excel sheet. Choose the Destination file/folder as the folder where you want to place the processed files (create one if you do not have one):
- We will now delete the original Excel file. Add a File Delete action and point the file property to the original SO Excel file.
- Finally, let's add a success message for the bot to confirm. Add a Message box with message to display as Success! All Sales Orders Created and file moved to Processed Folder.
That completes the configuration for the automation. Let's now run it.