Lookup a collection against a record value

(0) Share

Report

Posted on by User_Naami

Hi,

I've been trying to solve the following problem. I have an app that displays 1 question at a time from my database of questions. All questions are mapped to a QuestionID and DifficultyLevel.

I've noticed that sometimes the same question appears. So I have started a collection "ShownQuestions" that records the QuestionID of the questions being displayed.

How can I modify my current code that displays the next question by first seeing if it is being asked previously and if so, display another question.
"

//Set the next question
Set(
    CurrentQuestion, //CurrentQuestion is whats being displayed
    First(
        Shuffle(
            Filter(
                QBANK, //QBANK is my question bank.
                Difficulty = NextDifficulty  //NextDifficulty is how i determine the next difficulty based on a logic.
            )
        )
    )
);

"
 
 

Categories:

General Questions

I have the same question (0)

All responses (3)

Answers (0)

Suggested answer

SpongYe 5,603 Super User 2025 Season 2 on at

Like (0)

Report
Lookup a collection against a record value

Hi,

Store the questions that are shown in the ShownQuestions collection.

Then, you can check if a question is already in the collection

// Set the next question Set( CurrentQuestion, // CurrentQuestion is what's being displayed First( Shuffle( Filter( QBANK, // QBANK is your question bank Difficulty = NextDifficulty && // NextDifficulty is how you determine the next difficulty based on a logic !IsBlank(LookUp(ShownQuestions, QuestionID = QuestionID)) // Check if the question has already been shown ) ) ) );

Was this reply helpful? Yes No
Suggested answer

timl 35,805 Super User 2025 Season 2 on at

Like (0)

Report
Lookup a collection against a record value

Hi User_Naami

Here's some alternative syntax that should also work.

Set( CurrentQuestion, First( Shuffle( Filter( QBANK, // QBANK is your question bank Difficulty = NextDifficulty, Not(QuestionID in ShownQuestions.QuestionID) ) ) ) );

Was this reply helpful? Yes No
User_Naami 82 on at

Like (0)

Report

Lookup a collection against a record value

Hi @timl and @Spong Ye both the solutions does not work.

It displays the first question but then the second question just returns blank.

Was this reply helpful? Yes No