Need help building a Power Automate flow for Oncall Rotation Schedules.
Oncall schedules for each person is listed in an excel file with names and date of starting oncall, weekly.
Please help building the flow
Read excel weekly
Get the person for that week and send an email indicated said person is starting oncall
Update a mailbox forwarding rule to forward emails to person who would now be monitoring the oncall mailbox for tickets
**Potentially also get the person phone number listed on the excel sheet and call a number to switch or forward calls to person starting oncall