cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
ElizabethK
Helper I
Helper I

SPO Group Calendar Clean Up

We have several PTO calendars that are SharePoint Online Calendars. These are NOT Outlook calendars. Behind the scenes, the settings are for a list but it does display as a calendar. Lists have a certain amount of items that go into it before it reaches the threshold limit and then people can't add more PTO entries. We are getting close to the limit and going through and manually deleting entries from a few prior years is very time consuming. Is there a way to create a flow that annually deletes entries from the prior year? Thank you in advance.

ElizabethK_1-1612970543441.png

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
v-litu-msft
Community Support
Community Support

Hi @ElizabethK,

 

You could following these steps to approach that:

1. Create a Recurrence trigger that runs every 12 months.

2. Get items and use Filter query to find items that created less than 1 years ago:

Created lt '@{addDays(utcNow(),-365,'yyyy-MM-dd')}'

Screenshot 2021-02-11 114149.jpg

 

Screenshot 2021-02-11 113752.jpg

 

Best Regards,
Community Support Team _ Lin Tu
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

1 REPLY 1
v-litu-msft
Community Support
Community Support

Hi @ElizabethK,

 

You could following these steps to approach that:

1. Create a Recurrence trigger that runs every 12 months.

2. Get items and use Filter query to find items that created less than 1 years ago:

Created lt '@{addDays(utcNow(),-365,'yyyy-MM-dd')}'

Screenshot 2021-02-11 114149.jpg

 

Screenshot 2021-02-11 113752.jpg

 

Best Regards,
Community Support Team _ Lin Tu
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

Helpful resources

Announcements
MPA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

MSFTBizAppsLaunchEvent

Experience what’s next for Power Virtual Agents

See the latest Power Automate innovations, updates, and demos from the Microsoft Business Applications Launch Event.

New Super Users

Meet the Power Automate Super Users!

Many congratulations to the Season 1 2021 Flownaut Crew!

Power Platform ISV STudio

Power Platform ISV Studio

ISV Studio is the go-to Power Platform destination for ISV’s to monitor & manage applications post-AppSource publish.

Users online (34,475)