Power Apps Random Number Generator with No Duplicates

แชร์
ฝัง
  • เผยแพร่เมื่อ 24 ธ.ค. 2024

ความคิดเห็น • 42

  • @Excel-power-users
    @Excel-power-users 2 ปีที่แล้ว +2

    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
      @ShanesCows  2 ปีที่แล้ว +1

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

    • @Excel-power-users
      @Excel-power-users 2 ปีที่แล้ว

      @@ShanesCows yes

  • @MrEk5150
    @MrEk5150 2 ปีที่แล้ว +1

    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
      @ShanesCows  2 ปีที่แล้ว +1

      Glad you enjoyed it Eric! Happy New Year!

    • @MrEk5150
      @MrEk5150 2 ปีที่แล้ว

      @@ShanesCows Happy New Year!

  • @ricardobunge5957
    @ricardobunge5957 2 ปีที่แล้ว +1

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

    • @ShanesCows
      @ShanesCows  2 ปีที่แล้ว

      Glad you enjoyed it Ricardo. 😁

  • @TheCellAtom
    @TheCellAtom 2 ปีที่แล้ว +1

    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
      @ShanesCows  2 ปีที่แล้ว

      Happy to help. Have a great day. 🐶

  • @ronbakker1300
    @ronbakker1300 2 ปีที่แล้ว +1

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

    • @ShanesCows
      @ShanesCows  2 ปีที่แล้ว

      Happy to help Ron. Have a great day. 🐶

  • @eugenedidonato4591
    @eugenedidonato4591 ปีที่แล้ว +1

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

    • @ShanesCows
      @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
      @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.

  • @lucaslegz
    @lucaslegz 2 ปีที่แล้ว

    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

  • @chintaginjalasrinadh
    @chintaginjalasrinadh ปีที่แล้ว +1

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

    • @ShanesCows
      @ShanesCows  ปีที่แล้ว +1

      I would put the images in a collection and then use this video to shuffle the collection and show a different one. th-cam.com/video/OxLYL4ZzsT8/w-d-xo.html

  • @YorkshireCampers
    @YorkshireCampers 2 ปีที่แล้ว +1

    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
      @ShanesCows  2 ปีที่แล้ว +1

      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
      @YorkshireCampers 2 ปีที่แล้ว

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

  • @oluwatobipaul6171
    @oluwatobipaul6171 2 ปีที่แล้ว +1

    Thank you Shane. New knowledge and concept learnt

  • @keithsmith619
    @keithsmith619 7 หลายเดือนก่อน +1

    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
      @ShanesCows  7 หลายเดือนก่อน +1

      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
      @keithsmith619 7 หลายเดือนก่อน

      @@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
      @keithsmith619 7 หลายเดือนก่อน +1

      @@ShanesCows did you get my text ?

    • @ShanesCows
      @ShanesCows  7 หลายเดือนก่อน

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

  • @frodesellevoll
    @frodesellevoll 2 ปีที่แล้ว

    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?

  • @myrwong
    @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.

  • @mce8183
    @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.

  • @DataisKing
    @DataisKing 2 ปีที่แล้ว +1

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

  • @andylauer4244
    @andylauer4244 2 ปีที่แล้ว +1

    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
      @ShanesCows  2 ปีที่แล้ว

      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
      @andylauer4244 2 ปีที่แล้ว

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

  • @mavoldnl2376
    @mavoldnl2376 2 ปีที่แล้ว +1

    👌

  • @nguyenvincent9483
    @nguyenvincent9483 10 หลายเดือนก่อน

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

  • @lucaslegz
    @lucaslegz 2 ปีที่แล้ว

    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
    @lucaslegz 2 ปีที่แล้ว +1

    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