Need help building a Power Automate flow for Oncall Rotation Schedules

(0) Share

Report

Posted on by dharinsukar

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

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (0)

ScottShearer 25,268 Most Valuable Professional on at

Like (0)

Report

Re: Need help building a Power Automate flow for Oncall Rotation Schedules

@dharinsukar

You'll want to start with a recurrence trigger set to fire weekly.

Then you will probably want to use an Excel Get Rows present in a table and include a Filter query to limit what you retrieve to only that row you want.

You'll send the email using the Send an Email (V2) action.

I am not aware of any "out of the box" method of updating an email forwarding rule via Flow.

My suggestion is to give it a try with the information that I have provided. If you experience issues, post a question in this forum along with a screen shot of your Flow.

Was this reply helpful? Yes No
v-alzhan-msft on at

Like (0)

Report

Re: Need help building a Power Automate flow for Oncall Rotation Schedules

Hi @dharinsukar ,

I suggest that you could share a screenshot of the Oncall Rotation Schedules in the excel table and share an example of the requirement so we could better understand you and provide the workaround.

Best regards,

Alice

Community Support Team _ Alice Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Was this reply helpful? Yes No
v-alzhan-msft on at

Like (0)

Report

Re: Need help building a Power Automate flow for Oncall Rotation Schedules

Hi @dharinsukar ,

Does your issue still exists?

If the problem is solved, please go ahead and mark the post as solved by clicking “Accept as Solution” so that this thread will be marked for other users to easily identify!

Best regards,

Alice

Community Support Team _ Alice Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Was this reply helpful? Yes No