On Call Rotation that automatically updates

(1) Share

Report

Posted on by JS-25071423-0

I have a team of 3 developers (devA, devB, devC). We are each on call for a week at a time.
Today we have a recurring message that posts every day at the same time that:
@<OnCall dev> should check on the production checklist.

Oncall rotation ends at <Date>

I'd like to automate it to pick the dev from a list or map of options, to automatically change which person it selects each week, and to update the day the rotation ends at.
I'm a complete newbie to Teams Workflows so I'm not sure how to properly declare a map, dynamically select from a map in a message body, or dynamically change the date.

I'd be super grateful for some help.

Categories:

Building flows

I have the same question (0)

All responses (1)

Answers (0)

Expiscornovus 33,195 Most Valuable Professional on at

Like (0)

Report
You want it to be sequential right? And not for example round robin?

Below is an example for 3 devs.

This example calculates a week number based on today's date with the utcNow function. After that it div(ides) the week by 3. This should return either a 0, 3 or 6 as the first decimal. Using a formatNumber (with the 0.0 format) and a last function to retrieve that part. With a Filter Array action the example matches it against a Rota array.

Rota Array

[ {"Name": "DevA", "ID": "0"}, {"Name": "DevB","ID": "3"}, {"Name": "DevC", "ID": "6"} ]

Where in the Filter Array action

@equals(item()['ID'], last(formatNumber(div(add(div(dayOfYear(utcNow()), 7), 1), 3.0), '0.0')))

Was this reply helpful? Yes No