Answered

Flow to Delete calendar events from a specific period

(0) Share

Report

Posted on by Chris1968

1,154

Hi,

I would like to delete events, task in a calendar stored on a SharePoint site.

This is to assist in the calendar not exceeding the 5000 item limit.

I would like the flow to go back and delete everything that is 6mths or older and run once a month.

I created this flow, with test Recurrence information

but getting an error

Any ideas???

Categories:

General topics

I have the same question (0)

All responses (9)

Answers (1)

Verified answer

Sundeep_Malik 6,484 on at

Like (1)

Report
Copy link

Link copied!

Hey @ClarkyPA365

Put single quotes around that add days expression:

EventDate ge 'Expression'

If this helps you, you can mark this answer as the solution. You can give a thumbs up as well. 🙂

Was this reply helpful? Yes No
Chris1968 1,154 on at

Like (0)

Report
Copy link

Link copied!

Hi @Sundeep_Malik

So simple 😀

Was this reply helpful? Yes No
Sundeep_Malik 6,484 on at

Like (0)

Report
Copy link

Link copied!

@ClarkyPA365

Yea it was 🙂 , just one more thing. Whenever you are using these kind of expressions, also match the format of the column in your database. Though in your case it wont affect much, but just for future cases.
Like: addDays(utcNow(),180, 'MM-dd-yyyy')
Or similar format that is in your database.

Was this reply helpful? Yes No
Chris1968 1,154 on at

Like (1)

Report
Copy link

Link copied!

Hi @Sundeep_Malik

Thank you for the advice. Don't use expression too much currently but will be using them a lot more

Was this reply helpful? Yes No
Chris1968 1,154 on at

Like (0)

Report
Copy link

Link copied!

Hi @Sundeep_Malik

That resolved the error message but I'm finding that it's deleting everything that is in the Event calendar even if it's in the future. It doesn't for anything over six months old.

In my test I added events for 15/11/2022 onwards and days prior to the 15/11.

Was this reply helpful? Yes No
Sundeep_Malik 6,484 on at

Like (0)

Report
Copy link

Link copied!

@ClarkyPA365

Try adding le instead of ge there..

[I am really bad with ge and le when it comes to date, I get really confused, but try the above, it might help]

Was this reply helpful? Yes No
Chris1968 1,154 on at

Like (0)

Report
Copy link

Link copied!

Hi @Sundeep_Malik

'le' deletes records after 180 days.
'ge' deletes records up to 180 days

All my records I had after May have been deleted. Those in Dec and up to May are still displaying 🙄

Was this reply helpful? Yes No
Sundeep_Malik 6,484 on at

Like (0)

Report
Copy link

Link copied!

@ClarkyPA365

I will try it on my end and get back to you in some hours. Working currently.

Was this reply helpful? Yes No
Chris1968 1,154 on at

Like (1)

Report
Copy link

Link copied!

Hi,

Thank you. Appreciate your help!!!!

I'll carry on doing testing my end of it resolve it will let you know

Was this reply helpful? Yes No