O365 Get Mail - Query Filter - Order By Received Date

Hi,

I’m trying to get an order by filter applied to the O365 Get Mail activity.

The Graph API has this functionality, you can test it here: Use query parameters to customize responses - Microsoft Graph | Microsoft Docs

For example:
GET https://graph.microsoft.com/v1.0/me/messages?$orderby=receivedDateTime

I’ve tried adding different variations like:
“$orderby=receivedDateTime”
“orderby=receivedDateTime”

image

However I always get this error:
Error Code: BadRequest
Message: Invalid filter clause

Anyone know the correct syntax, if something else needs to be done, or if this is just not possible with the UiPath activity?

Cheers,

Hi,

Can you try UiPath.MicrosoftOffice365 activities package v1.10.0-preview?
There is OrderByDate property as the following.

img20211013-4

Regards,

1 Like

That’ll do the trick, thanks Yoichi.

1 Like