Daily Email of Events from Calendar

(1) Share

Report

Posted on by RW-26091625-0

I am trying to create a flow that will get my calendar events for the day from my calendar and email them to me in one email each morning. I have built the flow and continuously get errors. Attached below are the steps and the error. I was able to get it to work one time with no information being sent from the calendar and that time the issue I had was that I got an email for each event and not just one summary.

Here are the steps I used:

Using Microsoft Power Automate

This method allows you to build a personalized automated workflow to send your daily agenda via email.

Create a flow in Power Automate
:

Go to your Power Automate account and select My flows.

Choose New > Scheduled - from blank to start a new flow.

Give your flow a name, such as "My Daily Agenda Flow," and set a starting date and time to run it.
Add a step to get calendar events
:

In the Power Automate editor, select + New step.

Search for and select the action Get calendar view of events (V3).

Specify the desired calendar and set the Start Time to utcNow().

Use an expression like addHours(utcNow(), 10) to set the End Time for the next 10 hours of events, or adjust as needed.
Format your events into an HTML table
:

Add another step and search for the Create HTML table action.

In the From field, select the Value output from the "Get calendar view of events" step.
Send the email
:

Add a new step for Send an email (V2).

Configure the recipient, subject line (e.g., "Your Daily Agenda"), and in the body, select the output of the "Create HTML table" action to include your events.

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (0)

Suggested answer

chiaraalina 1,860 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi @RW-26091625-0

If your flow is accidentally sending separate emails per event, this is because "Send email" is inside a loop (Apply to each).

You don't need the Apply to each Loops. You can remove both.

You map fields from the “Get calendar view of events” output (its value array) into the table columns.

Try this:

Was this reply helpful? Yes No
RW-26091625-0 4 on at

Like (0)

Report
Copy link

Link copied!

You were correct that I had the email in a loop. I have corrected that and also the table issue that you suggested. Now my "final" issue is that I cannot find what you had to put in the body of the email to import the Output of the table that was created. Any suggestion or direction on how i find that? It does not pop up in Add dynamic content.

Was this reply helpful? Yes No
chiaraalina 1,860 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

It seems your "Creat HTML table" action is still in a Loop. You don't need that.

In the Body of the Email you have to add :

body('Create_HTML_table')

Please make sure "Create HTML table" action is not in the loop and looks like in my screenshot.

Was this reply helpful? Yes No