Unanswered

Flow to Send Weekly Email of Upcoming Events

(0) Share

Report

Posted on by clarapfm

I'm trying to create a flow to send an automatic email every week, of upcoming events for the following week.

For example, an email would be sent out this morning at 9am, detailing all events in the calendar for 9/2-9/6. Next Friday, an email would go out detailing events 9/9-9/13, etc.

I think a Scheduled Flow with the following steps will accomplish this:

Outlook: Get calendar view of events (V2)
Outlook: Send an email (V2)

However, I have a few questions about the process:

In Outlook: Get calendar view of events (V2), it asks for a specific Start Time and End Time. Is there a way I can set these to the following Monday and the following Friday, rather than specific dates? If not, is there a Filter Query I could use to select for the upcoming week?
What is the best way to input the "Get calendar view of events" into the body of the email? Is there a better first step to use in the flow, that would accomplish this more easily? The information needed from each calendar entry would be the Date, Time (although many would be all day events), Subject, and Body.

Any and all answers would be extremely helpful!

Thank you,

Clara

All responses (5)

Answers (0)

Amandys 23 on at

Like (0)

Report

Re: Flow to Send Weekly Email of Upcoming Events

You probably already solved it or moved on, but to all others arriving here wondering how to properly format the time here comes:
When selecting the values for the create html table, instead of using the dynamic values input formatDateTime('Name_of_the_value', 'MM.dd.yyyy hh:mm') or whatever formatting you need.
When in the expression field, after typing formatDateTime() you can switch over to the the dynamic content tab and select your property from there, thus avoiding having to type the reference manually.
Then, before the closing bracket, type in ", 'MM.dd.yyyy hh:mm' and you should be good to go.
Expression sample:
formatDateTime(item()?['start'], 'dd.MM.yyyy HH:mm')
Note that I used another format here, HH in capital letters returns times as 24h values.
When I tried to recreate my advise, the property 'start' was not selectable right away. Instead you may have to expand the result list or just type it manually when its short like here.
Seadog21 8 on at

Like (0)

Report

Re: Flow to Send Weekly Email of Upcoming Events

The result is creating an email with Unicode time, which is impossible to read. How do I format the time to the standard am/pm time? This link (https://learn.microsoft.com/en-us/troubleshoot/power-platform/power-automate/how-to-customize-or-format-date-and-time-values-in-flow) seems like it has the right information, but I’m having trouble implementing it.
Thank you!
clarapfm 27 on at

Like (0)

Report

Re: Flow to Send Weekly Email of Upcoming Events

I finally got the process to work (I didn't realize that time inputs default to GMT, and I am in EST). I still have formatting questions though (a screenshot of the email I received is provided below for reference).

1) Start Time and End Time - I asked about this in my last post. I would ideally like to format these as 09/04/2019 3:00 PM (for example). In general, I'd like these to be a little more user-friendly.

2) I added a section called "Details" to the table where I inputted the body of the event. This is essential to the Flow I am trying to set up, as we will be including details in the body of the event that are too long to include in the event's title. However, as you can see, the email I received showed the Body in HTML format. I'm hoping to only input the text from the Body.
clarapfm 27 on at

Like (0)

Report

Re: Flow to Send Weekly Email of Upcoming Events

@RezaDorrani I input everything as you specified, and set the email timing to 4:30 PM (16:30) on Tuesdays, but I haven't received the email yet. Any idea what could be incorrect?

One additional question: I noticed that in Flows, when you ask it to input Start Time, it comes out in this format: 2019-09-10T14:40:00.0000000

I am wondering if there is a way to put it into this format instead (more user-friendly): 9/10/19 at 2:40 PM
RezaDorrani 12,141 on at

Like (0)

Report

Re: Flow to Send Weekly Email of Upcoming Events

Hi @clarapfm

Trigger your flow to run every monday at 9 am

For get calendar events - Use expressions
StartTime - utcnow()
EndTime - adddays(utcnow(),7)

For sending email use following

Regards,
Reza Dorrani

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly