How to use ReceivedDateTime filter in Graph client C#

SAC_535 36

var message = await graphClient.Users["{user id}"].MailFolders.Inbox.Messages.Request.Filter($"ReceivedDateTime eq").GetAsync();

this call is not working

how to use ReceivedDateTime in filter query in GraphClient C# call

1 answer

CarlZhao-MSFT 40,311 Reputation points

2022-03-11T07:35:08.987+00:00
Hi @SAC_535

Suppose you want to get all emails received by a user between February 1, 2022 and February 2, 2022, then you can filter by the following sample:

var filterString = $"ReceivedDateTime ge 2022-02-01 and receivedDateTime lt 2022-02-02"; await graphClient.Users["{user id}"].MailFolders.Inbox.Messages .Request() .Filter(filterString) .GetAsync();

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.
Please sign in to rate this answer.

2 people found this answer helpful.
SAC_535 36 Reputation points

2022-03-11T10:20:53.083+00:00

Thank you for reply!!

Need filter equal to specific ReceivedDateTime

var filterString = $"ReceivedDateTime eq ge 3/10/2022 9:27:50 AM +00.00";

await graphClient.Users["{user id}"].MailFolders.Inbox.Messages
.Request()
.Filter(filterString)
.GetAsync();

but above filter not working

CarlZhao-MSFT 40,311 Reputation points

2022-03-11T10:39:04.507+00:00

Filtering by a specific time is not supported, you can only filter on a time range. But you can set it for a very short time, even 1 minute.

CarlZhao-MSFT 40,311 Reputation points

2022-03-11T10:51:36.563+00:00

Hi @SAC_535 E.g:

In 1 second:

var filterString = $"ReceivedDateTime ge 2022-02-01T05:37:28Z and receivedDateTime lt 2022-02-01T05:37:29Z";

SAC_535 36 Reputation points

2022-03-11T11:43:48.043+00:00

What is the date time format of 2022-02-01T05:37:28Z? And how to convert Mesasge ReceivedDatetime to this format?

CarlZhao-MSFT 40,311 Reputation points

2022-03-14T02:02:42.273+00:00

@SAC_535 According to my research on the api documentation, the receivedDateTime parameter only supports UTC time. So you need to convert your local time to UTC time. https://support.microsoft.com/en-us/topic/converting-time-zone-in-microsoft-power-automate-8bce2441-1859-4d76-2f51-985d9c96534d

CarlZhao-MSFT 40,311 Reputation points

2022-03-16T06:15:49.53+00:00

Hi @SAC_535

Would you please provide us with an update on the status of your issue?

----------

Please do not forget to "Accept Answer" and “up-vote” wherever the information provided helps you, this can be beneficial to other community members.
Sign in to comment

Share via

How to use ReceivedDateTime filter in Graph client C#

1 answer