SharePoint Online Calendar Extract all Recurring Events

%3CLINGO-SUB%20id%3D%22lingo-sub-1618502%22%20slang%3D%22en-US%22%3ESharePoint%20Online%20Calendar%20Extract%20all%20Recurring%20Events%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1618502%22%20slang%3D%22en-US%22%3E%3CP%3EHas%20anyone%20figured%20out%20a%20method%20to%20extract%20all%20the%20instances%20of%20recurring%20events%20from%20a%20SharePoint%20calendar%20to%20Excel%2C%20or%20to%20another%20SharePoint%20list%3F%20Recurring%20events%20are%20stored%20as%20a%20single%20ID%2Fitem.%20The%20individual%20instances%20can%20be%20displayed%20in%20a%20read-only%20list%20by%20with%20out-of-the-box%20options%2C%20but%20these%20are%20not%20actual%20items%20that%20can%20be%20exported%2C%20nor%20can%20the%20fields%20such%20as%20%22RecurrenceID%22%20or%20%22RecurrenceData%22%20be%20accessed%20externally%2C%20such%20as%20with%20Microsoft%20Power%20Automate.%3C%2FP%3E%3CP%3ECould%20this%20be%20done%20with%20SharePoint%20Designer%2C%20Power%20Automate%2C%20PowerApps%2C%20or%20some%20code%20snippets%20inserted%20into%20a%20web%20part%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1618502%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ESharePoint%20Online%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
New Contributor

Has anyone figured out a method to extract all the instances of recurring events from a SharePoint calendar to Excel, or to another SharePoint list? Recurring events are stored as a single ID/item. The individual instances can be displayed in a read-only list by with out-of-the-box options, but these are not actual items that can be exported, nor can the fields such as "RecurrenceID" or "RecurrenceData" be accessed externally, such as with Microsoft Power Automate.

Could this be done with SharePoint Designer, Power Automate, PowerApps, or some code snippets inserted into a web part?

0 Replies