Answered

Get Emails (V3) - Search Query for Emails more than 7 days old dynamic expression help needed

(0) Share

Report

Posted on by Fsomers68

Hi,

I have configured a flow to automatically move sent emails from a shared mailbox using a compose function to the archive folder, which works. But I'd like to have a dynamic query so that it lets emails younger than 7 days stay in the "regular" sent for quick reference before moving.

Right now I have it moving ones sent yesterday, so I know I change the -1 to -7 - I can't figure out how to configure the "greater than" conditional in the Search Query field. Right now this would only move ones dated yesterday, and I want all older than 7 days:

Any assistance is appreciated!

Categories:

Building flows

I have the same question (0)

All responses (4)

Answers (1)

Sort by

v-bofeng-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi @Fsomers68 ,

Please try:

received>@{addDays(utcNow(),-7,'yyyy-MM-dd')} AND received<@{addDays(utcNow(),-1,'yyyy-MM-dd')}

Best Regards,

Bof

Was this reply helpful? Yes No
Fsomers68 94 on at

Like (0)

Report
Copy link

Link copied!

Thank you. I tried that and it only moved items that were younger than seven days but kept today. The three in red were the ones that moved. I would have wanted the 9/15 one to move and everything else to stay. Tomorrow, the 9/19 email would move:

Was this reply helpful? Yes No
Verified answer

Fsomers68 94 on at

Like (0)

Report
Copy link

Link copied!

Ok, I was able to figure it out after laying it out in a spreadsheet. Didn't need two expressions:

Thank you for your help!

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

Like (0)

Report
Copy link

Link copied!

Here is a free flow with same functionality that can work with any amount of emails:
https://ivasoft.com/archiveemailsflow.shtml

Was this reply helpful? Yes No