How to use .contain in filter property in get outlook mail message?

[aapostol]

Hi UiPath,

I need help let say I want to use the .contain method in get outlook mail message how can I do that?

I understand that I can use for loop and get it using the subject.contain however I want to filter it first before looping on the mail messages.

Please advise and let me know

thanks!

[Gokul001 (Gokul Balaji)]

Hi @aapostol

Try use this expression

Contains should not have an asterisk.
Either use item.Subject.Contains("Request") or item.Subject Like "Request*"

You need more information refer the Link:

Get Outlook Mail Messages Filter Filter By Subject

I want to use the filter option on the Get Outlook Mail Messages activity. I am trying to get all emails that contain the subject “Billing”. What I currently have is “[Subject]=‘Billing’” but this does not return anything. What am I doing wrong? I do not want to use a for loop to iterate over emails unless I can mark the ones without Billing as unread. Thank you SOLUTION: "@SQL=urn:schemas:httpmail:subject LIKE '%Your Item%'" OR "@SQL=""http://schemas.microsoft.com/mapi/proptag/0x1000001E""…

Regards
Gokul

[THIRU_NANI (NaNi)]

Yes you need to use the loop to fetch the mails.

inside the loop you can use if for the purpose of contains. let’s say if you wants to fetch the mails contains PFA.

you can try like this Item.subject.contains(“PFA”)

this will loop through the every mail

Regards,
NaNI

[pravin_calvin (pravin kumar)]

Hi @aapostol

Use Filter Condition like Below!

“@SQL=((urn:schemas:httpmail:subject LIKE ‘%YourValue%’)"

Regards

[aapostol]

Thank you so much it worked!