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.
Solved! Go to Solution.
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')}'
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.
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')}'
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.
Check out new user group experience and if you are a leader please create your group
See the latest Power Automate innovations, updates, and demos from the Microsoft Business Applications Launch Event.
User | Count |
---|---|
49 | |
41 | |
39 | |
36 | |
34 |
User | Count |
---|---|
68 | |
65 | |
65 | |
54 | |
49 |