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

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 :

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

Hey @kavya.s16,

Use the filter expression as

	"[Subject] = 'Product Roadmap'" and "[From] = 'Anthony Young'"

For more info read the doc 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 “ and **All mail messages containing “business analyst” string in the subject **

"[SenderEmailAddress] = ''" and "@SQL=""urn:schemas:httpmail:subject"" like '%business analyst%'"

Have a look on the documentation


@Sanjit_Pal its giving error implicit convertions from string to long