Unanswered

Exporting Calendar Categories to Excel

(1) Share

Report

Posted on by 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)

截圖 2024-05-11 18.16.01.png 截圖 2024-05-11 21.54.06.png

Categories:

Building flows

I have the same question (0)

All responses (14)

Answers (0)

SudeepGhatakNZ 14,394 Most Valuable Professional on at

Like (1)

Report

@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.

Was this reply helpful? Yes No
snowflake_ 20 on at

Like (1)

Report

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.

Was this reply helpful? Yes No
SudeepGhatakNZ 14,394 Most Valuable Professional on at

Like (1)

Report

@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?

Was this reply helpful? Yes No
snowflake_ 20 on at

Like (1)

Report

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.

Was this reply helpful? Yes No
SudeepGhatakNZ 14,394 Most Valuable Professional on at

Like (1)

Report

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

Was this reply helpful? Yes No
snowflake_ 20 on at

Like (1)

Report

An event should only have one category :).

Was this reply helpful? Yes No
SudeepGhatakNZ 14,394 Most Valuable Professional on at

Like (1)

Report

Apologies for the delay. I will find time this weekend

Was this reply helpful? Yes No
SudeepGhatakNZ 14,394 Most Valuable Professional on at

Like (1)

Report

@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

Was this reply helpful? Yes No
snowflake_ 20 on at

Like (1)

Report

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?

Was this reply helpful? Yes No
snowflake_ 20 on at

Like (1)

Report

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.

Was this reply helpful? Yes No