Outlook Events to csv/Excel

[Tadeas_Bartos]

Hello makers,

I’m working on an app that connects to all calendars (around 30) in our organization, exports each calendar’s events to CSV (probably separate or better together for each calendar?), and saves them to SharePoint/OneDrive — after which the data continues through a Power BI pipeline.

I’ve built a first version, but I’m getting inconsistent data outputs, which is a problem for Power BI. I also haven’t yet solved how to handle updates when an existing event changes.

Could anyone help me move this forward or share some guidance on how to make the export more reliable?

Thanks in advance!

[damato]

Hi @Tadeas_Bartos. Welcome to the community.

What do you call inconsistent data outputs? Could you share more details about these outputs and how they differ from what you are expecting?

@damato

[Tadeas_Bartos]

Hello @damato ,

my bad, I have been using module Text aggregator and then saving into csv, which resulted into creating a wrapped json saved in csv. I have solved this by removing the Text aggregator module.