Bot send the excel sheet to the user(Manager). User will check and update the Excel sheet and give approve. After getting approval from User bot will send the updated excel sheet to the end user (Vendor).
Is is possible to do the above scenario in UiP ath?
You have to put it in the loop your getOutlookMailMessage activity and try to get emails with some interval, once it received send the update mail to end user and come out of the loop.
—Along the workflow once after the excel file is ready use SEND OUTLOOK MAIL ACTIVITY and mention the filepath as attachment with a Unique subject line
The reason for a unique subject line is if the user responds on top of it bot should be able to identify that and send it to vendor
—now the user at the other end will receive the file and he will approve and bot will receive the mail with the same subject
—here bot has to check for all time when the mail is approved
—so let’s deploy this in orchestrator and schedule the bot to run for every five mins
—if it is scheduled bot will get executed and first look for any input mail or any mail with approval and if any found the then it will pick and operate accordingly