Power Apps Random Number Generator with No Duplicates

A viewer had a great question: How do you get a table of 10 random numbers between 1 and 20 with NO DUPLICATES. So, I made a video to answer but then I got carried away. Learn how to build a Bingo Caller app that creates all of the bingo balls, and then shuffles them, randomly draws one, and helps you manage the whole bingo game. Playing bingo at the holidays is a family tradition and this app just makes it all that much cooler. So much to learn.

0:00 Power Apps Random Number Generator Video
2:16 Overview of the working Bingo Caller App
4:19 Generate 10 unique numbers from 1 to 20
10:01 Creating Bingo Balls with Power Apps functions
13:45 Using ForAll to more efficiently build our collection
17:34 Overview of the rest of the app
22:53 How to add Sound to your app

Functions Covered:
Sequence
AddColumns
RandBetweent
ClearCollect
Collect
Shuffle
FirstN
As
UpdateContext
OnVisible
Mod
IfError

[Excel-power-users]

Thanks for sharing much needed knowledge. I wanted to generate 10 unique questions for quiz from the available questions bank. Will do a lookup to retrieve the questions in a blank gallery. MS form doesn't provide the feature to generate random questions from the provided question bank. Please let me if we can achive this in a MS form.

[TheCellAtom]

Nice for better comprehension about Collection, var etc.. And good to know for the sound, idk if it's possible since your video. Thanks Shane !

[MrEk]

Shane, this is great! I'm glad you made the video of the 7 Great Things I Missed this Year because somehow, I missed this one ;)

[ronbakker]

17:28 never thought of using forall and a collection like that, Thanks Shane.

[lucaslegz]

Thank you for this. I actually play this with my team using excel macros. I am going to try this. You have a new subscriber

[ricardobunge]

Another, pardon the pun, WINNER! As a bonus, #TIL that shuffle() weeds out the duplicates... Thanks Shane! Keep 'em coming!

[myrwong]

Thanks for sharing. I'm going to see if I can do a PowerApp of Demings "Red Bead" experiment. 4000 beads (3200 white, 800 red) and you take random samples of 100. Have used the experiment in the past in training, messy using actual beads. Can't drop them with the Powerapp which in real life causes a HUGE mess. Have it working I think, just need to make it pretty.

[chintaginjalasrinadh]

Shane, this is great ! Could you please tell how to generate random images in the gallery when the pages is refreshed

[DataisKing]

Nice set up. I created a 4 part video on how to create a Roulette Table.

[eugenedidonato]

@7:33 how did you get the drop down for colVideo2? My power Apps doesn't have that feature. Is it experimental?

[oluwatobipaul]

Thank you Shane. New knowledge and concept learnt

[frodesellevoll]

Super video. Wondering what code I have to do if I want random numbers between, for example, 7-26 (including 7 and 26), and display 3 numbers?

[YorkshireCampers]

Hi Shane,

I have been using power apps for some years but ive just recently picked it up again and cant find how I remove a datasource (my SP List) from my app? have you got any ideas?

Many thanks
Jonny

[keithsmith]

Is there an app where you can put your own sequence of numbers, and have the App shuffle My numbers that I enter and have it give back to me? THANKS!!! ✌🏾

[mce]

Hello Shane...I wonder if you can assist me in creating a tracking number that looks like and number continues until year changes to 2024...I thought i can copy some of your formatting but it is coming up wrong. Thank you for your assistance.

[andylauer]

Hi Shane your videos are awesome, I search a solution with Powerapps on Android Samsung Tabletts. When my PowerApp is open with the "PDF Reader" (powerapps inside) my screen lock of the device is closing the screen after 10 minutes. 10 minutes is the max that can be set by Android . Is there no possibility to block this screen lock, so that my PowerApp stays always open and my screen will always me active? I think when somebody knows this then you :) Thanks a lot :) Best regards

[nguyenvincent]

hi shane! can you share file .zip for everyone?

[lucaslegz]

Thank you for this. I actually play this with my team using excel macros. I am going to try this. You have a new subscriber

[lucaslegz]

Thank you for this. I actually play this with my team using excel macros. I am going to try this. You have a new subscriber