Weekly calendar digest

[dfox]

I'm trying to build a Flow that will gather a list of the events on my calendar for the upcoming week, then send me a single email that lists those events in the body. I've found the connectors for everything, but when I start the action for composing the email, Flow sets it as "Compose email for each item." When I run a preview of the flow, it sent me 9 different emails, so I know it is pulling the events out.

I need help getting the body composed so that it sends a table, not individual emails for each event.

[dfox]

I was able to get the mechanics done with the following steps.

1. Use "Get calendar view of events" to pull the events out my calendar
2. Use the "Compose" connector to create the table inputs of the events using HTML code.
3. Use the Notifications connector to "Send me an email notification" because it will take the HTML code.

A few of the things I still need to get done are:

- Setting the displayed date properly

- Sort the dates by the start date field

- My event pull is starting a weird time, but that might just be because it is running a preview.

[v-xida-msft · Accepted solution]

HI @dfox,

Could you please share a screenshot of your flow's configuration?

I have made a test on my side and please take a try with the following workaround:

• Add a proper trigger, here I use Flow Button trigger.
• Add a "Get calendar view of events (V2)" action, specify Calendar id, Start Time field set to following formula:

utcNow()

End Time set to following formula:

addDays(utcNow(),7)

Order By field set to following formula:

Start asc

Note: Within Order By field, type the OData query as above, we could sort calendar events by Start time property in ascending order.

• Add a Variables-> "Initialize variable" action, Name set to EventLists and Value set to empty.
• Add a "Apply to each", input parameter set to output of "Get calendar view of events (V2)" action.
• Within "Apply to each" action, add a "Html to text" action, Content field set to Body dynamic content of "Get calendar view of events (V2)" action. 

        Add a "Compose" action, Inputs field set to following json data:      Add a "Append to array variable" action, Name set to EventLists variable, Value set to output of "Compose" action.

• Under "Apply to each" action, add a "Create HTML table" action, From field set to EventLists variable.
• Add a "Send an email" action, Body field set to output of "Create HTML table" action, Is HTML set to Yes.

Image reference:

The flow works successfully as below:

Best regards,

Kris

[dfox]

Kris,

You hit almost all my checkmarks except for formatting the date/time. Not knowing where you are at, I'm not sure if the start & end times in your picture are UTC or your personal time zone. But your flow produces a result that is much more elegant than mine! I'll definitely be reproducing yours. Below are the screenshots of my flow, which has not actually run other than my preview (the first instance is set for this Sunday).

It is set to run each Sunday at 2pm in my time zone.

I used the first version of the "Get calendar view of events" to do the data pull.

I used another weekly digest flow as a template to build HTML rows for a table.

I finish with the notification action to send me an email, and the body of the email creates a table from the "Apply to each" step, with the expression join(outputs('Compose'),'')

I end up with the following results. As you can see, the events aren't actually sorted, either alphabetically or starting team.

Thanks again for taking some time with this!

Donovan 

[dfox]

@v-xida-msft, I've tried recreating your flow, and I keep running into an error when it gets to creating the HTML table.

Any suggestions?

[Anonymous]

@v-xida-msft I've got the same error. When I try to specify the number of columns it puts the 'Create HTML Table' into another 'Apply to each' and then emails me a separate email for each calendar entry.

Thanks

Hannah

[khaycock]

@v-xida-msft @dfox 

This worked a dream for me except all returns have been removed through the HTML to text convert. Is there anyway to stop this from happening?

 Original event:

Table output in email:

My Flow is exactly as you've demonstrated.