Random Letter Generator (Advanced)

(0) Share

Report

Posted on by Courtney

261

Hi Everyone.

I have 3 text labels that are set to randomly generate 1 letter each between A to F.

The user has the option to select a different letter which is also generated at random (on select) between A to F.

What I need is to figure out how to make sure that the letter generated will not be a duplicate of one of the other letters already on screen.

Here is the code i have so far.

ClearCollect(Letters,Split("ABCDEF",""));ClearCollect(Letters1,Split("ABCDEF",""));ClearCollect(Letters2,Split("ABCDEF",""));ClearCollect(Letters3,Split("ABCDEF",""));UpdateContext({UpperCaseValue:""});Set(box1, false );Set(box2, false );Set(input3, false );Set(input2, false );Set(input1, false );Set(cover1, false );Set(cover2, false );Set(cover3, false );Set(reason1, false );Set(reason2, false );Set(reason3, false );Set(amendblock, false );Set(submitblock, false );Set(randletter,First(Shuffle(Letters)).Result);Set(randletter1,First(Shuffle(Filter(Letters,Result<>randletter))).Result);Set(randletter2,First(Shuffle(Filter(Letters,Result<>randletter,Result<>randletter1))).Result);Set(randletter3,First(Shuffle(Letters)).Result)

Any ideas on this would be great.

Thanks.

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (0)

Community Power Pla... Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!

There is a function called shuffle which should do the job you're after wonderfully.

https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/functions/function-shuffle

Basically to get three numbers create a table of letters and store in a collection, here called colAlphabet and then you can clearcollect like this ClearCollect(colThreeLetters,FirstN(Shuffle(colAlphabet),3))

The first N will return the first three letters from the shuffle which will ensure that none are duplicated.

Was this reply helpful? Yes No
Courtney 261 on at

Like (0)

Report
Copy link

Link copied!

Is it possible to use the (If) formula to exclude repeating letters which are already visible on other labels?

Was this reply helpful? Yes No