Live Power Automate Cloud Flow Build & Competition Draw for 10,000 Subs

In this live session I built a cloud flow automation to randomly select winners from 141 entrants, of which there were 3 duplicates. In this demonstration I built a flow that for each prize selection, I jumbled up the entrants (to simulate a hat full of names) and picked someone at random to select them as a prize winner. Upon selection, their name was removed from the array of data to ensure each entrant could only win a maximum of 1 prize.
I considered the logic prior to the live session but I wanted to demonstrate how I think, build and test a flow. Things didn’t go smoothly as I had difficulty with the logic but also with the new designer. I was able to work through this though and complete the objective, I’ve 34 winners! 🥳🏆 This is a new format for me as usually you see a polished flow.
Did you attend? Did you enjoy the format? What could I improve? Would you watch me live again?
Did you win? I’ll let you know officially but I announce all the winners in the video 👍 take a look 👀
See examples of select and compose actions, arrays as variables or built from a compose, and expressions union(), setproperty() and guid().
Cheers folks 🥃 thank you to subscribers and supporters.
To celebrate almost 3 years to the day since I started my CZcams channel on 6th February 2021 as a distraction to my cardiac arrest (www.DamoBird365.com/MyHeart) and reaching 10,000 subscribers mid February, I have a number of prizes to give away sponsored by myself, and kindly by Keith Atherton and PackT as follows:
🎥1 of 2 one hour remote sessions to work on your Power Automate skills (DamoBird365)
🧑‍💻1 x Microsoft 365 Business Standard 12 Month License (DamoBird365)
📗1 x Print copy for Learn Microsoft Power Apps (PackT)
📘1 of 2 eBooks for Learn Microsoft Power Apps (PackT)
📙1 of 3 eBooks for Microsoft Office 365 and SharePoint Online Cookbook (not yet out!) (PackT)
🏢1 of 25 LinkedIn Premium Trial 3 Months (Keith Atherton)
If you would like to buy me a coffee www.buymeacoffee.com/DamoBird365 ☕

[@RalfHeid]

Thanks for all the great videos... I learned a lot from you.

[@DamoBird365]

Cheers Ralf. Thank you for your support through your blog site too. I’m hoping the live format was useful.

[@garypotter4273]

Congratulations on 10k subs

[@DamoBird365]

Thank you Gary 👍

[@makdaddy8888]

Lost me at 35 mins :) I definitely appreciate the brain power required here!

[@DamoBird365]

Aww sorry about that and thanks for persevering 👍 technically I could have selected at random using rand() only and no need for guids and sort. But I wanted to be fair to everyone by jumbling up that virtual hat and demonstrate something challenging that manipulated data. I hope you took something away from this live build. Thanks for watching.

[@McIlravyInc]

Congratulations and thanks for showing us the wizard behind the curtain. It's really helpful to see the imperfections because it helps offset the sting of our own, and teaches 'how to fish' so to speak by sharing the thought process out loud.
Can you explain how the final compose works in the background please? Is it looping through the results of the apply to each?

[@DamoBird365]

It uses outputs() learn.microsoft.com/en-us/azure/logic-apps/workflow-definition-language-functions-reference#outputs which returns the objects created in the form of an array.

[@adeebyakubbape4580]

Thanks so much for the prize

[@DamoBird365]

Thank you for entering and supporting me. Enjoy!

[@DeepakMishra-df2ni]

When are you going live again?

[@DamoBird365]

Thank you Deepak. I’ve not worked that one out yet, but think I should 😍