How to check the stored value in collection in string value

(0) Share

Report

Posted on by daywalker_567

Hi,

I am creating a quiz application in Powerapps.

In my submit code.

ForAll(
    GCGIntranetQuizGal.AllItems,
    Collect(
        colRadio,
        {
            Radio: ThisRecord.Radio4.Selected.Value,
            Question: ThisRecord.QuestionNumber
        }
    )
)
 
I will get the selected value of Radio then I will check if the stored value of is equal to the answers. 
 
Sample: 
 
This is my stored value in collection called colRadio
Then I will compared the Radio column to text "DMS", "DMS", "APPLICATIONS". 
 
Is it possible ? 
 
Thank you

Categories:

Power Apps Pro Dev & ISV

I have the same question (0)

All responses (3)

Answers (1)

Sort by

Suggested answer

scalca 254 Moderator on at

Like
a
(1)

Report
Copy link

Link copied!

you need to have somewhere the correct results and then compare it to what has been selected

for example

ClearCollect(colResult, ForAll(colQuestionResults, {question: ThisRecord.Question, result: If(answer= LookUp(colRadio, Question=ThisRecord.Question).Radio, "correct", "wrong")}))

Was this reply helpful? Yes No
Verified answer

CU17091722-0 21 on at

Like
a
(1)

Report
Copy link

Link copied!

Hello,
To compare the user's selected answers to the correct ones, you would need to have another collection or data source that contains the correct answers for each question. For example, you could have a collection colCorrectAnswers that

ClearCollect( colCorrectAnswers, { Question: 1, CorrectAnswer: "Option1" }, { Question: 2, CorrectAnswer: "Option3" }, { Question: 3, CorrectAnswer: "Option2" } ) And after you can then use a ForAll loop LookUp function

ClearCollect(colResults, ForAll( colRadio, { Question: Question, UserAnswer: Radio, CorrectAnswer: LookUp(colCorrectAnswers, Question = ThisRecord.Question).CorrectAnswer, IsCorrect: If(Radio = LookUp(colCorrectAnswers, Question = ThisRecord.Question).CorrectAnswer, true, false) } ) )

Was this reply helpful? Yes No
daywalker_567 74 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi,

May I request also on how to make the scoring in this quiz application ?

Thank you

Was this reply helpful? Yes No