cancel
Showing results for
Search instead for
Did you mean:
New Member

## Random number fct

Hi guys!

I am currently building an app to learn some German Vocabulary. Basically, my app is linked to an excel with all my vocabulary, where each word has an ID, as with a database. To create a quiz, I need five random ID for five random words. I do it using five label boxes and the following code:

First(Shuffle (Verbes.ID)).ID
However, when my first set of 5 questions is over, I do not know how to "refresh" those five label boxes without closing and opening again the app. Can someone please help me?

Thank you in advance!

1 ACCEPTED SOLUTION

Accepted Solutions
Dual Super User III

for the button that gets the next set of questions add formulas that set 5 different variables to random numbers.  Something like this:

`Set(var1,Rand()*100);Set(var2,Rand()*100);Set(var3,Rand()*100);Set(var4,Rand()*100);Set(var5,Rand()*100)`

Use the values in the variables for the IDs for each question.  Each time you press the button you will get 5 new random numbers.

-------------------------------------------------------------------------
If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.
1 REPLY 1
Dual Super User III

for the button that gets the next set of questions add formulas that set 5 different variables to random numbers.  Something like this:

`Set(var1,Rand()*100);Set(var2,Rand()*100);Set(var3,Rand()*100);Set(var4,Rand()*100);Set(var5,Rand()*100)`

Use the values in the variables for the IDs for each question.  Each time you press the button you will get 5 new random numbers.

-------------------------------------------------------------------------
If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

## Helpful resources

Announcements

#### Community Blog

Stay up tp date on the latest blogs and activities in the community News & Announcements.

#### Power Apps Community Call- January

Mark your calendars and join us for the next Power Apps Community Call on January 20th, 8a PST

#### Global Power Platform Bootcamp

Dive into the Power Platform stack with hands-on sessions and labs, virtually delivered to you by experts and community leaders.

#### Power Platform Community Conference On Demand

Watch Nick Doelman's session from the 2020 Power Platform Community Conference on demand!

Top Solution Authors
Top Kudoed Authors
Users online (7,526)