Hi,
I have come across an O365 issue. The problem is, Office 365 limits the threshold for SharePoint calendars to 5000 items. If this limit is exceeded the '"Connect to Outlook" from SharePoint does not work. Users would like to leverage Outlook desktop to access the SharePoint calendars but it errors saying that the threshold view limit is exceeded, I spoke to Microsoft and they are saying that unfortuantely there is now workaround for this in 0365.
I have SharePoint calendars containing more than 30k (Contains data from year 2011 till date) items so for those, i am looking to build a flow that should run each time the threshold limit exceeds 5000 count and start deleting items from the past years like 2011 and onwards and move it to a different calendar (A new calendar will be created to keep the data) and maintain the 5000 item count on the present list. This way users can leverage Desktop outlook to open SharePoint calendars and keep the threshoold count to 5000 or below.
Is there a way to accomplish this via Flow? Can someone please help me out building one? Thanks in advance.
