You’re offline. This is a read only version of the page.
Announcements
Hi there
I am trying to create a quiz that random updates everyday with new variables, for example:
In the last "Time variable" days, how many times was "Process type variable" completed?
I have looked at SharePoint options with a flow but can't differentiate between columns so it would have to have an item for every single combination, which with 5 variables would take a while to make.
Does anyone know of a more simplistic method, not necessarily using SharePoint just whatever is easiest
Thank you.
To help you better, it might be useful if you could explain the expected data source for your variables.
>> In the last "Time variable" days, how many times was "Process type variable" completed?
If you want a random number to set a "Time variable", you can call the Rand() function. For example, here's how to create a random number between 1 and 100.
Share
Report
All responses (
Answers (
36,393
With({randMin:1, randMax:100},
RoundDown(Rand()*(randMax-randMin + 1) + randMin,0)
)If you store the process type values in SharePoint list, you can call the Shuffle function to return a random row, and you can use that to set your "Process type variable".
First(Shuffle(YourProcessTypeList)).ProcessTypeDescription
