Flow to delete emails still keeps running

[frixel]

Hello Power Automate users.

I have created a Flow to delete emails from a certain folder in Outlook after 24 hours.

It seems to work but the runs remain running when the mail is deleted.

I don't think this is desirable, right?
Do I have to adjust something in the flow so that the run stops when the mail is deleted that is in it for 24 hours?

[Sundeep_Malik]

Hey @frixel 

From the screenshot that you have provided it looks fine as they will stop after 24hours. But definitely in other runs they might not be stopping. Not sure why its happening like that.

But if you are getting the desired results, then you can go to settings and set a timeout so that it times out and stops. 

I hope this helps. 

[fchopo]

Hi @frixel 

There are number of possible causes to slow running flows:

• Check on Office 365 Outlook connector throttling limits: Office 365 Outlook - Connectors | Microsoft Docs as you can make up to 300 requests every 60 seconds per connection (and not per workflow).

• Your flow is exceeding the data consumption allowance per day.  This is the amount of data your flow consumes as a result of the input/output operations.

• Your flow is executing an excessive number of actions per day, far in excess of the daily action limits for your plan.

Hope it helps!

Ferran

[Srini84]

@frixel 

Is it that you have to trigger the flow when the email and wait for 24 hours and delete that mail?

OR you want to delete the mails from the folder which are older than 24 hours? 

Let me know

Thanks,

Srini

[frixel]

@Srini84 

I want to delete the mails from the folder which are older than 24 hours.

But also for new mails if they there more than 24 hours they must be delete.

[frixel]

@Sundeep_Malik 
I can`t find a timeout in the settings from the flow. Where can i find that?

[Sundeep_Malik · Accepted solution]

Hey @frixel 

Just click on 3 dots on the right side of action. 

Then click on settings. 

Then there is the timeout option.

You can set it to P1M, for 1 minute or according to your choice. 

[fchopo]

Hi @frixel 

If you want to delete emails older than 24h you should do something like this:

1) Every day, at 1am (for instance)

2) Get the emails older than 24h -> ReceveidDateTime lt addDays(utcNow(),-1)

3) For each email -> Delete it

The only problem is that Get Emails only get 25 last emails... So you could ´count number of emails an run that inside an iterator.

Hope that helps!

Ferran

[frixel]

@fchopo 
I made your suggested flow but it don`t delete the mail from yesterday 14:10 hour (Now it is Wednesday 14:20 hour)

[Sundeep_Malik]

@frixel 

Not sure, but it could be because of the UTC time. The mail you received was at 14:26 your time and currently the utc time is like 12:25.

[frixel]

@Sundeep_Malik @fchopo 

Still now 2 hours later and the mail from yesterday are not deleting.

The UTC time can i change that to the dutch timen?

[Sundeep_Malik]

Hey @frixel 

Yes you can change it to dutch time.

Use the Convert time zone action. Its a pretty important action when creating flows that will work internaltionally.

[frixel]

Hey @Sundeep_Malik 

I don`t understand what and where to do something 😞 (noob)
I have already set the "Amsterdam" time in step 1 (Recurrence)

I hope you will help me further.

[Sundeep_Malik]

@frixel 

You can also call me a noob for this. haha.

I have never used it because, there was no such requirement till now. 

Just happen to know about it.

Found this link that might help you:

Convert Time Zone in Power Automate(MS Flow) – Vblogs

[frixel]

@fchopo @Sundeep_Malik @Srini84 

I can`t get the flow working.

I have now this and that is running without error but i don`t understand it.

There is no difference in output when i changed the expression with -1hours or -12hours.

And is my Condition okay?

I think that mus be >The received date/time from the mail is before the convert time zone than delete.

Am i thinking right?

[hongdet]

I'm not sure if the Condition action allows the checking of datetime format. 

I would set the scheduled flow to run at 11.55PM every day. Thereafter, convert today's date and email receive's date to string before trying to match it using the condition action. 

Hope this helps! 

[frixel]

Thanks @hongdet 

I go to try to copy what you discripe. only this step is empty.

[hongdet]

Hi @frixel ,

Opps! I missed that out, it should be an "null" expression.

Hope it works! 

[frixel]

@hongdet 
where can I set after how much time (for example older than 24 hours) the flow will delete?

[hongdet]

Hi @frixel , 

I'll try my best to understand what you mean, I think you are asking where to set the amount of time for the email to be deleted right?

If that the case I'm afraid I can't help much, as I state initially I think the Condition action cannot compare datetime (or at least I'm not sure how that could be done). What we are doing here is basically comparing 2 string value (not date) and execute action upon matching.