Unanswered

How to read older emails first with Office 365 Outlook Get emails (V3) operation?

(0) Share

Report

Posted on by ARAG

Hi,

I'm using Office 365 Outlook Get emails (V3) to read emails from my inbox. I'm reading 3 emails by execution.

By default, the flow process the emails from the newest to the oldest. But I would like to process the older emails first.

I don't see any option to apply in the operation? How can I achieve this?

Thank you

Categories:

Building flows

I have the same question (0)

All responses (11)

Answers (0)

v-chenzhi on at

Like (0)

Report
Hi @ARAG ,

Get email(V3) does not have the function of sorting email dates.

I have an alternative, please try the following work around.

1:length(variables('TT')) 2:length(outputs('Get_emails_(V3)')?['body/value']) 3:take(outputs('Get_emails_(V3)')?['body/value'],sub(length(outputs('Get_emails_(V3)')?['body/value']),length(variables('TT')))) 4:last(outputs('Compose'))

The array variable TT contains emails from oldest to newest.

Best Regards,

Zhi Chen

Was this reply helpful? Yes No
VictorIvanidze 13,073 on at

Like (0)

Report
Use a GRAPH request
https://graph.microsoft.com/v1.0/me/messages?$orderby=receivedDateTime
instead of "Get emails (V3)" action.

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

it gives an error on append to array variable.
the error says : BadRequest. The value cannot be null. The action type 'AppendToArrayVariable' only supports values of types 'Float, Integer, String, Boolean, Object'
Please can you help me fix this. Thanks!

Was this reply helpful? Yes No
jessdom3 29 on at

Like (0)

Report

What type of operation step do you add to make a graph request? When I search Graph I only get Microsoft Graph Security.

Was this reply helpful? Yes No
VictorIvanidze 13,073 on at

Like (0)

Report

"Send a HTTP request" action of "Office 365 Groups" connector.

Was this reply helpful? Yes No
jessdom3 29 on at

Like (0)

Report

What if the mailbox being connected to is not tied to an Office 365 Group? Does that matter? We are trying to pull email for a shared mailbox.

Was this reply helpful? Yes No
VictorIvanidze 13,073 on at

Like (0)

Report
You have to change the request then:
https://graph.microsoft.com/v1.0/{sharedmbxid}/messages?$orderby=receivedDateTime
Play with GRAPH Explorer a bit before creating the flow.

Was this reply helpful? Yes No
jessdom3 29 on at

Like (0)

Report

OK I figured out the graph http request, but how do I parse through the results? Is there a how-to somewhere I can follow?

Was this reply helpful? Yes No
VictorIvanidze 13,073 on at

Like (0)

Report

Sorry I don't understand your problem. The request returns the array of message objects. Handle them as you like.

Was this reply helpful? Yes No
jessdom3 29 on at

Like (0)

Report

I'm not super familiar with ms graph so I am probably doing something wrong or missing something in my HTTP request. When I try to parse the results, the only info from the HTTP request available to me is "body", which means I can't filter the results on any particular attribute.

Was this reply helpful? Yes No