Get Mail - create a custom query for mails subject

[dbukk]

Hello team,

I am trying to get certain emails from a shared mailbox. The following query works for the activity Get Outlook Mail Message but for some reason it does not work for Get Mail which is inside the Microsoft Office 365 Scope

“@SQL=urn:schemas:httpmail:subject LIKE '%” + in_str_MailSubject + “%'”

I must use this activity in order to get an output in a variable Office365Message

Any ideas what am I doing wrong?

[pravallikapaluri]

Hi @dbukk

"Subject eq '" + in_str_MailSubject + "'"

Hope it helps!!

[dbukk]

Hi @pravalikapuri, thanks for your reply I have just figured this out myself

Your query returns an exact value whereas mine returns contains:

“contains(subject, '” + in_str_MailSubject + “')”