Random question based on column count

(0) Share

Report

Posted on by DeanRichter22

Hi all!

I am attempting to create a questionnaire for an audit process.

My vision is for a user to open this PowerApp, have 5 questions generated from the list at random (Im thinking of using shuffle for this aspect). The end goal is to have a column that notates the max amount of times the questions are asked. For instance, Question 1 may be asked 3 times while question 2 may only be asked once, based on the severity of the question. So out of the 30 questions, there may be 50 questions actually being asked over time, After all 50 questions have been answered it will reset and start from the beginning again.

Does this sound plausible? I'm not quite sure how I would filter the shuffle to only show the top 5 questions if the column for the max amount of times asked has been met.

Any information or existing articles on a similar topic would be helpful.

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Sort by

Verified answer

v-bofeng-msft Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @DeanRichter22 ,

I assume there is a SharePoint Online list:

You could use this formula to get the 5 questions randomly.

ClearCollect(TheTable,QuestionList); If(CountRows(Filter(TheTable,TheMaxCount >TheCount))<5,UpdateIf(QuestionList,true,{TheCount:0});ClearCollect(TheTable,QuestionList)); ClearCollect(FiveRandQuestions,FirstN(Sort(AddColumns(Filter(TheTable,TheMaxCount >TheCount),"Rank",Rand()),Rank),5)); ForAll(FiveRandQuestions,Patch(QuestionList,LookUp(QuestionList,ID=FiveRandQuestions[@ID]),{TheCount:TheCount+1}))

Add a data table and set it's Items property to

FiveRandQuestions

Best Regards,

Bof

Was this reply helpful? Yes No
DeanRichter22 3 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks for the information! I'm still fairly new to developing PowerApps, in python I think I could figure it out with just some time while coding, but for this I was not quite sure where to begin..

I will attempt this and see if it works for my use case and update the thread. Thanks Bof!

Was this reply helpful? Yes No