Array filter struggles

(1) Share

Report

Posted on by Mattpst

203

Hi Forum,

I'm hoping someone can help me here. I have a flow which monitors the results from a Microsoft Form Quiz. Every week it checks the form results (From Microsoft SharePoint List) reads passed entries into an array and reads failed attempts into a different array.

The aim is to send a reminder notification that a failed test needs to be retaken. I am trying to compare the two arrays so that if a failed test is re-taken and passed it is not included in the follow up notification. This is what I currently have:

1. Get failed tests from SharePoint list, and use the Select action to put the names into an array (failed tests).

2. Get passed tests from SharePoint list, and use the Select action to put the names into an array (passed tests)

3. Use Filter Array action from the failed test array, using filter query "failed tests does not contain passed test items":

But nothing is returned in the output?

Categories:

Building flows

I have the same question (0)

All responses (4)

Answers (1)

Sort by

Verified answer

Valantis 6,735 on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @Mattpst,

The issue is most likely in the Filter array step.

You already have the failed tests array in the From field, so the filter should check each failed test item against the passed tests array. Right now it looks like the condition is comparing the wrong things, which is why the output is empty.

try this:

keep failed tests as the input to Filter array

compare the current failed test item to the passed tests array

you do not need an extra Apply to each for this comparison

Also make sure both Select actions return the same type of value. If one Select returns plain text names and the other returns objects, the comparison will not work. One more thing: Microsoft notes that this kind of text comparison is case-sensitive, so the names must match exactly.

Best regards,

Valantis

✅ If this helped solve your issue, please Accept as Solution so others can find it quickly.

❤️ If it didn’t fully solve it but was still useful, please click “Yes” on “Was this reply helpful?” or leave a Like :).

🏷️ For follow-ups @Valantis.

📝 https://valantisond365.com/

Was this reply helpful? Yes No
Suggested answer

11manish 3,333 on at

Like
a
(0)

Report
Copy link

Link copied!
You need to filter the Failed array where the value does NOT exist in the Passed array.

Conceptually:

RemainingFailed = FailedTests - PassedTests

Correct Filter Array Configuration

From

Use the failed tests array:

body('Select_Displaynames_-_FAILED_tests')

Advanced Mode Expression

Click Edit in advanced mode and use:

@not(contains(body('Select_Displaynames_-_PASSED_tests'), item()))

Was this reply helpful? Yes No
Mattpst 203 on at

Like
a
(1)

Report
Copy link

Link copied!

Hi @Valantis

As soon as I read this "so the filter should check each failed test item against the passed tests array." it clicked and I realised my error! Thank you for giving me that nudge!

Kind regards,
Matt

Was this reply helpful? Yes No
Valantis 6,735 on at

Like
a
(1)

Report
Copy link

Link copied!

Hi @Mattpst,

i am happy that i was able to help. have a nice day :)

Was this reply helpful? Yes No