Hi community,
I want to create a flow that sends a person an auto approve or reject email for a vacation request based on this logic:
1. Associate sends vacation request via Microsoft Forms with a range of dates
2. Flow checks a shared Outlook Calendar. If there are already 4 associates on vacation during at least one of those days, then a rejection email is sent with the reasoning (ex: "There are already 4 associates on vacation on December 4th"). If there are less than 4 associates on vacation during the requested days, an approval email is sent.
3. If approval email is sent, the Outlook Calendar updates automatically with the new event
I found some premade templates that address part of what I want the flow to do, but not everything. Thanks for your help!