Using PowerAutomate to quickly select a ceremony lead
Our team has a standup every morning on Microsoft Teams and there is always an awkward 30 seconds at the start as we work out who will be sharing the kanban board and acting as the ceremony lead. Therefore, I created a simple PowerAutomate flow to do that for us.
The trigger looks out for the phrase "roll the dice" in our daily stand up chat. When it sees that it lists all the members in the chat and pass that to the final box which posts a message to the same chat. The interesting part is the randomiser which selects a random index from the list of members:
outputs('List_members')?['body/value'][rand(0, length(outputs('List_members')?['body/value']))]?['displayName']
Here is the automation working:
So there we have it, for around 10 minutes work we have a simple, random selector for the ceremony lead.