Forum Discussion
Using Bookings, is there a way to power automate emails post the appointment day?
I hope this isn’t too confusing, but looking for a way to send notifications out to patients after their appointments.
Our pharmacy wants to be able to schedule vaccine appointments through bookings. Once scheduled, is there a way to generate all information into an excel workbook. In that workbook, we would have some manual entry needed from the pharmacist such as vaccine type and on the day it was given. If a vaccine requires a second dose, we will have our excel sheet automatically generate that date in a simple excel formula.
Is there a way to bring this back to power automate to send out an email maybe 14 days before that next dose is due or 7 days, or both?
Relatively new to power automate so any help would be appreciated on making this work properly. Thank you!
2 Replies
- Hi,
In order to do this, create a workflow which triggers on a schedule. Set it to run once per day, preferably at a time that patients will not mind receiving mail. Use the "List rows present in a table" action to get the excel data into dynamic content. Use an apply to each on the "value" variable returned by this. Then use a condition on the Date column you have created and question if it is equal to todays date + 7 or 14 days using a UTCNOW expression. If the condition is true, send an email to the address located in the column of your table that contains the email address of the customer. You can include any information in the row such as the type of vaccine in the body of that email sent using a dynamic content variable.
Let me know if you need further help but that should give you enough information to build the workflow to your needs.mpeggielycetts hello! Thank you for replying. I am still working through your message, as I believe I am much more new to power automate than I initially thought. I will follow up once I make sure I inputted your steps correctly!
