Return 10 Questions to SP List that Don't Match Questions Already on SP List

(2) Share

Report

Posted on by Phineas

5,073 Super User 2025 Season 1

I am working on building a quiz creator that randomizes the new questions to an existing quiz.

The user clicks a Power Apps button that triggers a flow that retrieves data from the 'Active Test Questions' list
and the 'General Questions and Answers' list where the Quiz Name 'Course Names' match.

The 'Active Test Questions' list has 10 questions on it. The 'General Questions and Answers' list has 30 questions
on it, including the 10 questions on the 'Active Test Questions' list.

The flow seems to be working, adding 10 questions to the 'Active Test Questions' list, except it is returning a few
questions (in the example 13, 17, and 21) that are already on the 'Active Test Questions' list.

As the 'General Questions and Answers' list has 30 questions, seems to me every time the flow runs it should be able
to return 10 NEW questions, with none of the new questions matching the questions already on the 'Active Test Questions'
list.

What am I missing?

Active Test Questions list (Post Flow Run) -

Flow -

Categories:

Business Process Flows

All responses (2)

Answers (0)

Phineas 5,073 Super User 2025 Season 1 on at

Like (0)

Report

Return 10 Questions to SP List that Don't Match Questions Already on SP List

@Michael E. Gernaey

If I may; then why does it not repeat ALL questions already on the 'Active Test Questions'
list?

It is only repeating two, three or four existing questions.

1. There are 30 total questions on the 'General' list. This is the repository for all questions.
2. The 'Active' list only has 10 questions at any given time.
3. The flow is already comparing the question numbers from the 'Active' list to those on the
'General' list.
4. The flow is (supposedly) filtering out question numbers from the 'General' list that are
match question numbers on the 'Active' list, to avoid duplication.

I'm not understanding why some questions already on the 'Active' list are making it
through the process and being added back to the 'Active' list in the Create Action
and the rest of the existing question numbers are not.

The rest of the flow is working fine. Seems I should be able to fine-tune a filter or condition
somewhere to solve this problem, rather than adding a column to a list to resolve it, yes?
Suggested answer

Michael E. Gernaey 44,770 Super User 2025 Season 1 on at

Like (0)

Report

Return 10 Questions to SP List that Don't Match Questions Already on SP List

Hi @Phineas

You would need to a column, that marks a question already used, then use a Filter where that field is set to No/False.

But it just won't magically do it.

If these suggestions help resolve your issue, Please consider Marking the answer as such and also maybe a like.

Thank you!
Sincerely, Michael Gernaey

Community site session details

Return 10 Questions to SP List that Don't Match Questions Already on SP List

Helpful resources

News and Announcements

Quick Links

Paul Stork – Community Spotlight

Congratulations to the June Top 10 Community Leaders!

Announcing the Engage with the Community forum!

Leaderboard > Power Automate

Featured topics

Product updates

Community site session details

Return 10 Questions to SP List that Don't Match Questions Already on SP List

Helpful resources

News and Announcements

Quick Links

Paul Stork – Community Spotlight

Congratulations to the June Top 10 Community Leaders!

Announcing the Engage with the Community forum!

Subscribe to this forum!

Select categories

Leaderboard > Power Automate

Featured topics

Product updates