Hello,
I need help designing a sequence. The workflow is the following:
Firstly, I will receive a couple of emails.
Secondly, I want it to go to excel sheet to look for the sender email address to get the case number.
Thirdly, after retrieving the sender email address and the case number, enter into another excel sheet.
Please help thanks!
Hie @mnurhaikal so you mean the attachment that you get from mail is in excel form? right if yes and if yo are working with outlook then use get outlook activity and in the property panel set your reuirments . eq-sender id ,read /unread top 10 mails etc etc. and save the output in a variable . after that use for each and inside that use save attachment activity.
and to get the excel file from the folder you can work with get file from the folder activity or you can go with directory.getfile method and use 1 for each to get the excel file and now use read range and after read range use for each row activity and inside that use one if condition and pass you logic that your currentrow(“columnname”) = “yourmailidyouarelookingfor” if this true get the case number.
Any specific problem while working on this where we can help you?