Non-repeating random numbers

Like (0) Share

Report

Posted on 9 Dec 2020 13:12:46 by mayarnaldo

Hi,

Is it possible to generate a non-repeating random numbers?

I have this syntax:

ClearCollect( RandomNumbers, ForAll( [ 1, 2, 3, 4, 5,6,7,8,9,10 ], RoundDown(
txtRandStart.Text + Rand() * (txtRandEnd.Text + 1 - txtRandStart.Text), 0 )))

And when I generate the numbers, there's a repeating numbers.

Any help is appreciated! 🙂

Regards,

May

Categories:

General Questions

All responses (2)

Answers (2)

Verified answer

mayarnaldo 92 on 09 Dec 2020 at 15:13:19

Like (0)

Report
Re: Non-repeating random numbers

Hi @mdevaney ,

Thank you for your reply and the link that you provided.

I added Shuffle to get random number 🙂

FirstN( Shuffle(Sequence( Value(txtRandEnd.Text)-Value(txtRandStart.Text)+1, Value(txtRandStart.Text) )), 10 )
Verified answer

mdevaney 29,987 Moderator on 09 Dec 2020 at 14:51:20

Like (1)

Report
Re: Non-repeating random numbers

@mayarnaldo
You can do this by using the SEQUENCE function to generate the list of numbers you want to pick randomly from.

Use this code to get the 1st number in the random set.

First( Shuffle( Sequence( Value(txtRandEnd.Text)-Value(txtRandStart.Text)+1, Value(txtRandStart.Text) ) ) ).Value

Use this code to get the first 10 numbers in the random set

FirstN( Shuffle( Sequence( Value(txtRandEnd.Text)-Value(txtRandStart.Text)+1, Value(txtRandStart.Text) ), 10 ) )

If you want to learn more cool ways of using the SEQUENCE function check out this article
https://matthewdevaney.com/sequence-function-in-power-apps/

---
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."