Filter oultook message using subject and from address using schema filter type

Help Forum
, ,
1

Hi Everyone,

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

2

Hey @kavya.s16,

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

Thanks,
Sanjit

3

and condition is not valid

4

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.

5

@kavya.s16, use the expression as All mail messages from “no-reply@microsoft.com” and **All mail messages containing “business analyst” string in the subject **

"[SenderEmailAddress] = 'no-reply@microsoft.com'" 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

Thanks,
Sanjit

6

@Sanjit_Pal its giving error implicit convertions from string to long