How to get email received in linq query

Help Studio
, ,
1

I need to get the email received date in linq query and save it as a variable

please help

Thanks&Regards,
aman

2

Hi @aman4

Welcome to Community!!

Try this

image
image847×439 18.1 KB

Regards,

3

Hi @lrtetala

Im looking in Linq query because of im filtering the mails in linq query only

4

mails.Select(Function(recieved) recieved.Headers(“Date”)).ToArray

You can try this to get all dates of recieved mails as an array of string

5

@aman4

Fetch all the mails using “Get Outlook mail”
And then Write a LINQ query to filter mails.

Note: U need “Get Outlook Mail Messages” activity to fetch mails from Outlook

6

im not able to store the value in variable

7

could you share what error you are recieving

8

im using outlookmail activity, you can see in below image
however the in my mail box having only 1 unread mail, but its showing all the mails dates

image
image1201×483 41.3 KB

9

Can you try checking MarkAsRead and trying it again

10

Hi @aman4 ,

Could you elaborate on what is actually required for your case ?

Do you want to filter the Emails based on the received and then store those emails as an Array of MailMessages ?

Or Do you just want to store the Date values of all the Emails received ?

Clarifying this requirement will help us to suggest accurate responses.

11

I have 2 unread messages in my outlook account and the below output is generated.

image
image1250×653 32.2 KB

array1 Linq is - mailMessages.Select(Function(recieved) recieved.DateAsDateTime.ToString(“dd/MM/yyyy”)).ToArray

array2 Linq is - mailMessages.Select(Function(recieved) recieved.Date.ToString).ToArray

If you want to only process a mail once, then in properties of get outlook mail message, check MarkAsRead as true