My Requirement is i need filter outlook message using get outlook messages activity and use the filter with schema type
filter based on some subject eg : Notification Email for 12023 and that mail should be from certain from address eg : xyz@.com
Instead of for each for filter i need to use default filter method bcoz i want to unread messages
any suggestions @Palaniyappan @ppr @Yoichi @Rahul_Unnikrishnan
Thanks in advance
Use the filter expression as
"[Subject] = 'Product Roadmap'" and "[From] = 'Anthony Young'"
For more info read the doc https://docs.uipath.com/activities/docs/get-outlook-mail-messages:- Filtering Examples
and condition is not valid
Hi @Sanjit_Pal thanks , but i need to use Like instead of [Subject] bcoz subject might contains extra value RE: Notification email and [From] should be a mail address instead of display name.
@kavya.s16, use the expression as All mail messages from “email@example.com” and **All mail messages containing “business analyst” string in the subject **
"[SenderEmailAddress] = 'firstname.lastname@example.org'" and "@SQL=""urn:schemas:httpmail:subject"" like '%business analyst%'"
Have a look on the documentation https://docs.uipath.com/activities/docs/get-outlook-mail-messages
@Sanjit_Pal its giving error implicit convertions from string to long