Power Apps Random Number Generator with No Duplicates

Подписаться 162 тыс.

Просмотров 8 тыс.

50% 1

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
Power Apps Consulting and training at www.PowerApps911.com

Наука

Опубликовано:

8 июл 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 42

@excel-k-sir Год назад

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.

@ShanesCows Год назад

Thanks for the update. Hopefully you enjoyed seeing your comment on the video. 😎 I don’t think it is possible in forms.

@excel-k-sir Год назад

@@ShanesCows yes

@MrEk5150 Год назад

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 ;)

@ShanesCows Год назад

Glad you enjoyed it Eric! Happy New Year!

@MrEk5150 Год назад

@@ShanesCows Happy New Year!

@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

@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 !

@ShanesCows Год назад

Happy to help. Have a great day. 🐶

@ricardobunge5957 Год назад

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

@ShanesCows Год назад

Glad you enjoyed it Ricardo. 😁

@oluwatobipaul6171 Год назад

Thank you Shane. New knowledge and concept learnt

@ShanesCows Год назад

Awesome 😎

@ronbakker1300 Год назад

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

@ShanesCows Год назад

Happy to help Ron. Have a great day. 🐶

@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?

@DataisKing Год назад

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

@ShanesCows Год назад

Very cool!

@myrwong 8 месяцев назад

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.

@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

@ShanesCows Год назад

Click on the database looking symbol on the far left. That will show all of the data sources in the app, then you can click on the list and choose Remove

@YorkshireCampers Год назад

@@ShanesCows cheers Shane managed to find it. Looks like powerapps have created a new view and couldn't find it so I reverted to classic view mode and I can see the database icon now

@chintaginjalasrinadh 11 месяцев назад

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

@ShanesCows 11 месяцев назад

I would put the images in a collection and then use this video to shuffle the collection and show a different one. ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-OxLYL4ZzsT8.html

@eugenedidonato4591 Год назад

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

@ShanesCows Год назад

If you highlight colVideo2, and there is data in the collection, Power Apps should say underneath that is a table. Then you can click the dropdown next to table and it should preview the data.

@eugenedidonato4591 Год назад

@@ShanesCows My power Apps doesn't have that drop down. I'm thinking that is a beta feature that hasn't rolled out to general population.

@mce8183 Год назад

Hello Shane...I wonder if you can assist me in creating a tracking number that looks like this.....2023-001 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.

@keithsmith619 Месяц назад

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!!! ✌🏾

@ShanesCows Месяц назад

First(Shuffle([12,393,54,12])).Value That would return the first number out of those. Or you could replace the [ ] with a collection. Have your users enter numbers in a collection and then shuffle it up. :)

@keithsmith619 Месяц назад

@@ShanesCows I’m sorry I didn’t mean that…In simple way of explaining…Say if I had favorite lottery numbers like anniversary, birthdays, etc. it is 1,2,3,4,40. 1,2,3,4,52, 1,2,3,4,54 those three set of numbers put them in, and have the “generator” “shuffle” them and I choose one of them? Plus I would call the my “birthday” numbers and create another set of multiple 5 numbers I would call my “anniversary” numbers I would choose…Thanks for the response ✌🏾

@keithsmith619 Месяц назад

@@ShanesCows did you get my text ?

@ShanesCows Месяц назад

@@keithsmith619 Nope. You can email shane at powerapps911.com

@mavoldnl2376 Год назад

👌

@ShanesCows Год назад

Thanks 🙏

@andylauer4244 Год назад

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

@ShanesCows Год назад

Hi Andy - I haven't ran into that problem so I got nothing :( Maybe try a timer that SetFocus a different control every 5 minutes?

@andylauer4244 Год назад

@@ShanesCows Hi ok good Idea I will try this :)