How can I set the Filter in GetOutlookMailMessages to include "@gmail.com"?

I’m currently experiencing a timeout error in GetOutlookMailMessages and would like to reduce the amount of mail read.

This is the first time I’ve used this feature, so I’m not sure how to handle it.

I’m not sure how to use it because I’ve never used this feature before. How can I add a condition to the Filter section like the one in the image below, “If @gmail.com is included in the target email address, retrieve it”?

Thanks in advance.

Hi @Kirigirisu_Coin

You can find a few filters in the following link

Try this one

“[SenderEmailAddress] = ‘*@gmail.com’”

Regards
Sudharsan

1 Like

Hi,

Try use the below expression in the Filter option in the get outlook mail message activity. thanks.

“@SQL=urn:schemas:httpmail:toemail like %@gmail%”

Thank you to tell me how to write.
However I try to use it, but it doesn’t work.

If you put the following syntax correctly, the data to be retrieved will be zero.
No error will occur.

“[SenderEmailAddress] = ‘*@gmail.com’”
“@SQL=urn:schemas:httpmail:toemail like %@gmail%”

Just only this one work.
“[SenderEmailAddress] = ‘aaaaaa@gmail.com’”

So when I use * or %, it doesn not work.
So, is there anything that I should set up or check in advance?

i missed the single quotes. try like below in the filter property.

“@SQL=urn:schemas:httpmail:toemail LIKE ‘%@gmail.com%’”

1 Like

Thank you.
Thanks to you, I was able to narrow down the data to what I needed.

1 Like

Your welcome @Kirigirisu_Coin

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.