Issue with Free Text Filter Argument in Get Email List for Outlook

[Garret]

My organization has integration service set up through an Azure connection and are using it to interact with an Outlook with shared mailboxes. We are upgrading processes to use this but running into issues with the activity UiPath.MicrosoftOffice365.Activities.Mail.GetEmailListConnections from the package Microsoft 365 v2.7.23.

We previously used OData Queries like this “(contains(body/content, ‘File Type: CSV’) and (contains(subject, ‘Vendor Invoice For XYZ’) and (hasAttachments eq true)) or (contains(body/content, ‘Please respond only to vrsupport@abc.com’) and (hasAttachments eq true))” but these do not work in the Free Text Filter option.

I’ve had semi success doing this using a free text query like “File Type: CSV;Vendor Invoice for XYZ” but it seems like I can’t add an or statement. I am not able to use the condition builder as we are passing these mail filters into the process from a configuration sheet that has 70+ rows and all of the filters are different.

Does anybody have any suggestions for how to use Free Text Filters or are complex conditional statements not possible?

[ashokkarale]

@Garret,

For O365 activity to get emails filtered, you should be using OData filter.

Refer more this here.

Use the $filter query parameter to filter a collection of objects - Microsoft...

[Garret]

We successfully used the OData filter in the classic 365. We would pass it into the Query argument:

The modern 365 has only provides the argument “Free text filter” and our OData filters no longer work:

Are you saying the OData queries should work in the free text filter on this modern 365 activity?