Send Automated YouCanBookMe (and other) Appointment Reminders Using Microsoft Flow / Power Automate
2 years ago 3 min read
I have 2 offices, which means that when someone makes an appointment with me, they need to be aware which office I’ll be meeting them at. My appointment provider (YouCanBook.Me) sends an appointment request to both myself and the person making the appointment, and I then update my copy with the location.
This then sends the location out to the person making the appointment. However what happens if that person isn’t used to appointment requests? Perhaps because they’re a college student, and haven’t experienced them yet? Typically they ignore them, or don’t notice the location line or change at all.
This semester I decided to try a new approach. When a person makes an appointment with me, it enters on my calendar with the prefix “Appointment: ” and then the person’s name. This means I can easily find my “self-set” appointments using Microsoft Power Automate (Flow). My goal was to have a script run every night at 8 PM that scans the next 24 hours of my calendar. If it finds an appointment set by someone, it emails them an automated reminder telling them where to meet me. It took me a couple of hours to get up and running, but is now working beautifully. Below is each step of my flow, and how to create it yourself.
And that’s it. The script has been running for a few weeks now without issue, and hopefully it will cut down on my frustration this semester with individuals unaware of where on campus I’m meeting them!