Build a Power Automate Flow for Random Prize Draws with No Duplicates | Step-by-Step Tutorial
Pick random winners from a SharePoint list—no duplicates, fully automated! In this Power Automate live build, you’ll see how to create a cloud flow that shuffles entrants, selects winners for each prize, and updates your SharePoint list—all in real time. Watch an unfiltered, expert walkthrough with real-world troubleshooting, perfect for anyone interested in workflow automation, digital transformation, or citizen development.
We’ll tackle a common challenge: running fair, one-entry-per-person prize draws from a SharePoint list, even when there are duplicate entries. You’ll see my thinking, testing, and how to handle pitfalls in Power Platform’s new designer—no edits, just authentic problem-solving. Whether you’re a Power Apps or Power Automate beginner or a seasoned pro, you’ll pick up practical tips for business process automation and low-code cloud flows.
What You’ll Learn:
✔️ Build a Power Automate cloud flow to randomly select unique winners from a SharePoint list
✔️ Remove duplicate entries and ensure one prize per entrant—fair and transparent
✔️ Use advanced expressions (union(), setProperty(), guid()) and array manipulation in real-world scenarios
✔️ Update SharePoint lists dynamically with winner information for easy tracking
Timestamps:
00:00 – Live intro: Building a Power Automate flow for random prize draws
03:30 – Setting up SharePoint lists for entrants and prizes
08:00 – Removing duplicate entries with union() for fair draws
14:15 – Adding GUIDs and shuffling entrants for random selection
22:10 – Looping through prizes: Picking and removing winners with arrays
32:00 – Troubleshooting, testing, and handling Power Automate designer quirks
41:00 – Connecting real SharePoint data and finalizing the flow
50:00 – Running the official draw and announcing winners
56:30 – Q&A: Power Platform tips, career, and learning advice
#PowerAutomate #workflowautomation #PowerPlatform #LowCode #DigitalTransformation
Ready to automate your next business process or contest? Drop your questions or share your own Power Platform stories in the comments! Don’t forget to subscribe for more authentic, hands-on Power Automate and Power Apps tutorials.
SEO Keywords: Power Platform, Power Automate, SharePoint, workflow automation, cloud flows, low-code, digital transformation, citizen development, business process automation, arrays, BPA, new designer, AI, canvas apps, Copilot Studio
Additional Links:
🔗 https://www.DamoBird365.com/MyHeart Story about the creator's cardiac arrest and YouTube channel start.
🫠 About me:
👋 Hi, I'm Damien Bird — Power Platform Cloud Solution Architect at Microsoft ☁️
🧠 Former Forum Super User (2021/22) & Business Applications MVP (2022)
🎤 Speaker at conferences across Europe, the US, and local UK user groups
💡 Passionate about sharing knowledge, solving problems, and empowering the community with the Power Platform!
📚 Explore more:
🔗 Blog: https://DamoBird365.com
🎥 Video & Quiz CPD: https://DamoBird365.com/YouTube
🎓 Join the Community: https://DamoBird365.Teachable.com/p/D...
💖 Support the Channel: / @damobird365
☕ Buy Me a Coffee: https://BuyMeACoffee.com/DamoBird365
💼 LinkedIn: / damobird365
🐦 Twitter: https://x.com/DamoBird365
🌐 Bluesky: https://bsky.app/profile/DamoBird365....
📜 Feedback or Request: https://forms.office.com/e/WAV1iF2Wis