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
Solved! Go to Solution.
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.
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.
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]
'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 🙄
Keep up to date with current events and community announcements in the Power Automate community.
A great place where you can stay up to date with community calls and interact with the speakers.
Check out the latest Community Blog from the community!