Exporting Calendar Categories to Excel

[snowflake_]

I want a flow that extracts calendar events and compiles them into an Excel file. With five color categories, I intend to export each category into its own worksheet within the same workbook. The exported data should include the category, event name, start time, end time, and duration.

Currently, my flow successfully exports event details, start time, end time, and duration to Excel. However, I still need to incorporate category information to distribute this data to the respective worksheets.

For your reference, here is my flow and Excel:

My flow (I followed the instructions in this video:https://www.youtube.com/watch?v=TehvPFUMXOg&t=26s)

[SudeepGhatakNZ]

@snowflake_ 

Power Automate actions operate based on Tables, not worksheets. To integrate with your flow, you'll need to incorporate tables into your worksheets.

Start by adding tables to your worksheets. Then, within your flow, implement a switch condition with a branch for each category. Each branch would reference its own table.

Feel free to reach out if you require further clarification or assistance.

[snowflake_]

Hello,

Thank you for the clarification. Just to confirm, do I need to consolidate all 5 color category tables into one worksheet? Alternatively, is it feasible to export them to separate Excel files within the flow?

Additionally, I would greatly appreciate it if you could provide an example or guide me through the steps to set up the switch condition with branches for each category within Power Automate.

[SudeepGhatakNZ]

@snowflake_ 

There are three options, each one is doable. Which one would you prefer?

1. 5 Tables in one worksheet

2. Separate worksheet for each category

3. Separate excel for each category

Are you okay creating the tables and the worksheets before the running the flow or would you want to the flow to generate them for you?

[snowflake_]

I would prefer option 2: Separate worksheet for each category.

I've already created tables for each worksheet and am prepared to set them up.

[SudeepGhatakNZ]

Can an event have more than one category? Will that be added to both worksheets?

[snowflake_]

An event should only have one category :).

[SudeepGhatakNZ]

Apologies for the delay.  I will find time this weekend 

[SudeepGhatakNZ]

@snowflake_ 

Create an Excel with multiple worksheets and add it into your Onedrive.

Give your Tables the same name as your Categories.

Then use this logic

[snowflake_]

Sorry, I’m still not clear on this. Should I create multiple "Get tables" plus "Add a row in a table" actions after "Apply to each 3"? When you said "Give your tables the same name as your categories," do I need to use a filter to sort these 5 categories?

[snowflake_]

Hello,

I tried to follow your steps, and my flow looks like this:

However, it failed at the 'apply to each' step, and I'm not sure what you mean for the 'excel table' part, so I used parallel actions for testing. Could you please correct my flow?

Thank you.

[SudeepGhatakNZ]

Will it be okay if I export my flow and share the excel too?

[snowflake_]

Definitely!! That would be very helpful.

[SudeepGhatakNZ]

@snowflake_ 

Please find the flow and excel attached.