We’re using Microsoft Office 365, Get Mail activity to retrieve the mails from an account created specifically for the robots.
Each robot handles specific mails based on the mails’s titles.
There’s Query property of Get Mail activity that allows us to filter the retrieved mails.
The issue that this property only accepts “eq” (equal) operator. For example, using the following value of the property works fine:
“subject eq ‘Progress AP Invoice of APR-2019’”
Trying to use operators like “contains”/“startswith” instead of eq, all fails.
We need to be able to do something like “subject contains ‘Progress AP Invoice’” or “subject startswith ‘Progress AP Invoice’”.
I know I can retrieve all the mails and later one check the subject if contains the value we need or not. But this solution we require that all robots to process all mails and all the actual steps of the robot to do will be basically inside if condition.
So, is there a way to use any operator to check substring of the mail subject using the Query property.