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 booki...
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.
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!