Trying to filter messages from a specific sender with a subject containing specific text. I tried the below option but no results fetched. While each condition gives results, but the combo does not.
“[SenderName] = ‘xxxxxx’ AND @SQL=urn:schemas:httpmail:subject like ‘%YYYYYY%’”
Any clue will be helpful.
Please try this
"@SQL=urn:schemas:httpmail:fromemail LIKE '%firstname.lastname@example.org%' AND urn:schemas:httpmail:subject like '%YYYYYY%'"
"@SQL=""urn:schemas:httpmail:fromemail"" LIKE '%email@example.com%' AND ""urn:schemas:httpmail:subject"" like '%YYYYYY%'"
Use the below filter expression.
"[From] = 'firstname.lastname@example.org' AND [Subject] LIKE '%specific_text%'"
Or you can check the below thread.
I am using get outlook mail messages activity to get the mails from the outlook. In this I have filtered the mails with Sender mail address by giving the filter expression in the activity. I tried with the below expression but it’s not working.
Please provide me the other filter expression.
I am thanking you all in advance…
Hope it helps!!
Both of them did not work. They did not give any error also.
I am using the above documentation page to work on the filter mechanism. In this one, From contains only a name and not email address. When your filter condition is specified, I get the error as - Get Outlook Mail Messages: Condition is not valid.