cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Krasimir
New Member

Flow - Delete emails older than 7 days

Hi There,

I'm trying to create a Flow to delete messages older than 7 days in Folder, but I have a problem.

 

This is my Flow:

flow01.JPG

 

When in the field Search Querry I add "received:yesterday", the flow is working, and the messages are successfully processed, but when I add  "received:last week" not working.

 

This is the output:

 

flow04.JPG

 

This is the output with "received:last week" in the query:

 

flow03.JPG

 

I tried to add the search query in double quotes, but in this case, the flow fails.

 

in the email folder, there is a lot of messages from the last 10 days (02 to 11 of April)

 

One more question - into the TOP field in "Get emails" step, I'm trying to put more than 25 items, but in this case, the Flow fails again. Is there a limitation for this?

 

Thanks in advance for any idea,

Krasimir

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
v-bacao-msft
Community Support
Community Support

Hi @Krasimir ,

 

Please consider directly comparing the current time and the time the message was received, and then delete the eligible email.

Expression reference:

formatDateTime(item()['DateTimeReceived'],'yyyy-MM-dd')
addDays(utcNow(),-7,'yyyy-MM-dd')

Image reference:50.PNG

Please take a try.

 

Best Regards,

Community Support Team _ Barry
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

5 REPLIES 5
v-bacao-msft
Community Support
Community Support

Hi @Krasimir ,

 

Please consider directly comparing the current time and the time the message was received, and then delete the eligible email.

Expression reference:

formatDateTime(item()['DateTimeReceived'],'yyyy-MM-dd')
addDays(utcNow(),-7,'yyyy-MM-dd')

Image reference:50.PNG

Please take a try.

 

Best Regards,

Community Support Team _ Barry
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Thanks. The solution works perfectly!

 

nick4924
Frequent Visitor

Hello, 

 

I made the same flow as is solution here and it doesn’t work.

Can you please check it and tell me why?..
Snímek obrazovky 2019-11-11 v 11.20.58.png

Spoiler
formatDateTime(item()['DateTimeReceived'],'yyyy-MM-dd')
Spoiler
addDays(utcNow(),-90,'yyyy-MM-dd')

I need delete mails older than 3 months, that’s why 90 in second formula.

Unfortunately flow posts this:

Snímek obrazovky 2019-11-11 v 11.25.49.png 

 

Test of flow is always the same - expression result = false, so anything won’t be deleted.

Snímek obrazovky 2019-11-11 v 11.27.38.png

 

And proof that in the inbox are mails older than 3 months..

Snímek obrazovky 2019-11-11 v 11.42.23.png

 

I will be very grateful for every comment.

Thank you,

D.

 

@nick4924 ,

 

The problem is the 25 item limit. It can't get to the stuff old enough to delete because it is only looking at the first 25 emails. This limit is keeping me from using this flow option to complete the same task.

I am trying to build the same automation but cannot see the "body" as it is shown in your flow. There is only "v2" available as well.

 

Mailarchiving.PNG

Helpful resources

Announcements
Power Automate News & Announcements

Power Automate News & Announcements

Keep up to date with current events and community announcements in the Power Automate community.

Community Calls Conversations

Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Users online (6,546)