I'm making an Excel sheet that helps me fill in my oursheet. To accomplish this I create a Power Query that takes data from my Outlook Calendar. However, I have noticed that recurring events only appears once. Also, there is nothing in the query that helps me figure out which events are recurring?

Can anybody help me get the recurring events into Excel through the query?

CodePudding user response：

This is a bit of a conceptual shot in the dark from me, but if you're connecting to Exchange Online (from New Query -> Online Services -> Exchange Online) then you should see a column named Attributes, with records in it. If you look within those records, you should see each record has a field named AppointmentType--that might help you. There is also an IsRecurring field--which might be even more helpful. Further, there is a field called Recurrence, with a record in it that provides info about the recurrences, if any. Lastly, a FirstOccurence field and a LastOccurence field are also included, and might help you in some way as well.

I would think to first identify the recurring records (maybe based off the IsRecurring field, then get their attribute info related to each recurrence (most of which seems to be in the Recurrence field for each record) to construct the single entry items for the recurrences.