Flow - Delete emails older than 7 days

Like (0) Share

Report

Posted on 11 Apr 2019 08:13:35 by Krasimir

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:

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:

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

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

All responses (7)

Answers (1)

Tobias_S 93 on 13 Mar 2023 at 11:11:40

Like (0)

Report

Re: Flow - Delete emails older than 7 days

Thanks for your support and the provided link 🙂
VictorIvanidze 12,214 on 11 Mar 2023 at 14:40:16

Like (1)

Report

Re: Flow - Delete emails older than 7 days

See https://ivasoft.com/archiveemailsflow.shtml
Tobias_S 93 on 18 Feb 2022 at 09:18:34

Like (0)

Report

Re: Flow - Delete emails older than 7 days

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.
HodgsonIM 30 on 17 Dec 2019 at 16:36:44

Like (3)

Report

Re: Flow - Delete emails older than 7 days

@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.
nick4924 18 on 11 Nov 2019 at 10:48:36

Like (1)

Report

Re: Flow - Delete emails older than 7 days

Hello,

I made the same flow as is solution here and it doesn’t work.
Can you please check it and tell me why?..
Spoiler (Highlight to read)
formatDateTime(item()['DateTimeReceived'],'yyyy-MM-dd')
formatDateTime(item()['DateTimeReceived'],'yyyy-MM-dd')
Spoiler (Highlight to read)
addDays(utcNow(),-90,'yyyy-MM-dd')
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:

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

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

I will be very grateful for every comment.
Thank you,
D.
Krasimir 5 on 12 Apr 2019 at 09:55:54

Like (0)

Report

Re: Flow - Delete emails older than 7 days

Thanks. The solution works perfectly!
Verified answer

v-bacao-msft on 11 Apr 2019 at 10:36:38

Like (2)

Report
Re: Flow - Delete emails older than 7 days

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:

Please take a try.

Best Regards,