Answered

Question Randomizer Flow Completion

(1) Share

Report

Posted on by Phineas

5,195 Super User 2025 Season 2

I tried several times and can't get the finish of this flow correct.

Intent:
Create a question randomizer; meaning every push of a Power Apps button
will trigger a flow that compares the content of the 'Active Questions' list to
the 'General Questions' list.

A predetermined number of the new questions (which CANNOT already be on
the 'Active Questions' list will be added to the 'Active Questions' list.

I've gotten the flow to work, however it is only replicating the quesitons already
in the 'Active Questions' list, rather than adding the questions from the 'General
Questions' list to the 'Active Questions' list.

What am I missing?

SharePoint List -

Categories:

Business Process Flows

I have the same question (0)

All responses (5)

Answers (1)

stampcoin 4,428 Super User 2025 Season 2 on at

Like (0)

Report

Question Randomizer Flow Completion

@Phineas Hi，

It's not easy to understand your flow.

what is the error in the innermost layer ?

Was this reply helpful? Yes No
Phineas 5,195 Super User 2025 Season 2 on at

Like (0)

Report

Question Randomizer Flow Completion

@stampcoin

There are no errors.
The flow is working.

The issue is the output (create items), which is just replicating the four items already on the 'Active Question' list,
rather than four new questions (from the 'General Questions' list) that do not match the four already on the
'Active Question' list.

Whatelse can I illuminate for you?

Was this reply helpful? Yes No
Verified answer

stampcoin 4,428 Super User 2025 Season 2 on at

Like (0)

Report
Question Randomizer Flow Completion

@Phineas Hi,

I think the problem might be on Filter Array 3.

try this (interpret by your own code)

Select (or Compose) all of your Active question IDs into a simple array
Add a Select action right after your “Get items 2 – Active Test Questions”:
From: body('Get_items_2')?['value']
Map:
Key:
Value: item()?['QuestionID']
Call this action Select Active Question IDs for example.

Filter array (before your Apply to each)
From: outputs('Compose_2')
Condition (Advanced mode):
@not(contains(outputs('Select_Active_Question_IDs'),item()?['QuestionID']))

What this does is peel out only those randomly-picked questions whose QuestionID is not already in the Active list.

Apply to each over the output of that Filter array, and in it do your Create item.

Then you’ll only land in “Create item” for brand-new questions.

Was this reply helpful? Yes No
Phineas 5,195 Super User 2025 Season 2 on at

Like (0)

Report

Question Randomizer Flow Completion

@stampcoin

Getting close.

Only issue now is one of the 'existing' questions on the 'Active Question'
list is showing up in the output for 'Create items'.

The 'Active Questions' list only has four (4) items on it.

The 'General Questions' list has ten (10) items on it.

Select - 'Active Question Numbers' (Body) content.

[

  {

    "QuestionNumber": "Q7"

  },

  {

    "QuestionNumber": "Q6"

  },

  {

    "QuestionNumber": "Q2"

  },

  {

    "QuestionNumber": "Q8"

  }

]

Select and Compose -

Compose 2 -

Filter Array -

Was this reply helpful? Yes No
stampcoin 4,428 Super User 2025 Season 2 on at

Like (0)

Report
Question Randomizer Flow Completion

@Phineas Hi,

Modify Select - 'Active Question Numbers',

Map: Key: (leave it blank); Value = item()?['QuestionNumber'],

so you can get :

[ "Q7", "Q6", "Q2", "Q8" ]

So the filter array, that will do is loop over each of your 5 random objects, look at its QuestionNumber, and keep it only if it’s not found in the Active array.

@not( contains( outputs('Select_Active_QNums'), item()?['QuestionNumber'] ) )

Was this reply helpful? Yes No