Answered

Calendar start and end dates and event location in auto-generated email

(0) Share

Report

Posted on by VelkySyr

Greetings!! I am a neophyte at building Power Automate routines - just started building basic routines today. I have a routine that runs successfully that generates an email when a Office365 calendar has an event added to it. I have the event name included in the email. However, I would like to add to the email the start date and end date of new events, as well as the location. I found the dynamic content "variable" "value Location Name" which does not return any data to the email.

The worse news is that I'm really not familiar with logical expressions. So, any help with whatever expression will create an email that states the following would be deeply appreciated:

The following event has been added to the such-and-such calendar:

Baseball Conference, March 3, 2020 through March 5, 2020, in Denver, CO

The values for which I need expressions are in bold italics.

Thank you all very much indeed!!

VelkySyr

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (1)

ChristianAbata 8,953 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

hi @VelkySyr if you want to see the start and end date of event you can try this

if you want to format this specific response.
Baseball Conference, March 3, 2020 through March 5, 2020, in Denver, CO
Please tell me to help you with functions.

Was this reply helpful? Yes No
Verified answer

v-litu-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi @VelkySyr,

There are expressions that take values apart from the email by using the split() function and formatDateTime() function:

formatDateTime(split(split(outputs('Compose'),'Conference, ')[1],' through')[0],'yyyy-MM-dd')

formatDateTime(split(split(outputs('Compose'),'through ')[1],', in')[0],'yyyy-MM-dd')

split(outputs('Compose'),'in ')[1]

Best Regards,
Community Support Team _ Lin Tu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Was this reply helpful? Yes No