Answered

Create events in calendar

(0) Share

Report

Posted on by JA-12091039-0

I've been requested to set up a form of automation to create events in a calendar (Maybe bookings) but the idea is that as an email is sent to a mailbox an event is created

to give further details the email will always be sent from "autoresponder@rightmove.com" with the subject line "Lettings enquiry:"

I require that the event is created for a least a week away from the current date and at maybe 10am, is this possible with "Event create v4" or any other connection?

Hope this image helps for context.

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (1)

Sort by

Verified answer

Manish Solanki 15,167 Moderator on at

Like (0)

Report
Copy link

Link copied!
Hi @JohnnyA

To create an event for future date (+ 7 days) on arrival of an email, you need to write an expression for both "Start time" & "End time" parameters. Expression needs to be entered in the expression box as shown below:

Expression used for Start time:

concat(addDays(utcNow(),7,'yyyy-MM-dd'),'T10:00:00')

Expression used for End time:

concat(addDays(utcNow(),7,'yyyy-MM-dd'),'T10:30:00')

pls note that it will create a 30 mins event from 10:00 am to 10:30 am, you may modify the time as per your need in the above expressions.

If this helps & solves your problem, please remember to give a 👍 and accept my solution as it will help others in the future.

Thanks

Was this reply helpful? Yes No
JA-12091039-0 58 on at

Like (0)

Report
Copy link

Link copied!

Can you confirm how this will work if multiple bookings are made on the same day? I.E if two emails come in on the same day will they both get created for 10am?

Was this reply helpful? Yes No
Srini007 3,467 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

Hi @JohnnyA

Yes, with that approach when 2 emails arrived means, then it will try to create events on 10 am itself, because you are fixing the start and end dates to the fixed time, If that is your requirement then it will works fine

But you need to look at free slot and then book for next time maybe you can take a look with the similar issue

https://powerusers.microsoft.com/t5/General-Power-Automate/Create-an-Event-Meeting-based-on-Availabilty-of-attendees-amp/td-p/437151

If you find this reply helpful, please consider giving it a LIKE AND

If this reply answers your question or solves your issue, please ACCEPT AS SOLUTION

Thanks,

Srini

Was this reply helpful? Yes No