"Except" Operation in Flow

(0) Share

Report

Posted on by Sevket

Hi guys,

I'm just stuck and would appreciate your help.

I have two Sharepoint lists where I loop through and for each one I create an array (variable) with user IDs.

Let's say array A stores (all possible) 10 IDs and array B contains 7 IDs.

What I would like to get is a third array C where all IDs from array A are stored which are NOT in array B (in this case C would have 3 entries).

Is this possible without creating a for-each loop with another for-each loop inside.

I also tried one loop with the filter array action without any luck.

Thanks!

I have the same question (0)

All responses (4)

Answers (1)

Gristy 2,429 on at

Like (0)

Report

Re: "Except" Operation in Flow

loop array b
use the filter array action
in the outputs if there is any add to array c

Was this reply helpful? Yes No
Verified answer

v-alzhan-msft on at

Like (1)

Report

Re: "Except" Operation in Flow

Hi @Sevket ,

Please refer to screenshot below to create the flow:

The flow would run successfully as below:

Best regards,

Alice

Community Support Team _ Alice Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Was this reply helpful? Yes No
Community Power Pla... on at

Like (1)

Report
Re: "Except" Operation in Flow

Hi @v-alzhan-msft ,

Is there any other way to do an Except action? Doing a double Apply-to-each is non-intuitive. Also, I believe you'd have to perform another Apply-to-Each loop to determine which unique values are in the OTHER table.

Just like we have Intersection and Union, we need Except.

Example:

Given two arrays, show which items exist in one and not the other

This post has a nice example of Except: https://powerusers.microsoft.com/t5/Power-Automate-Ideas/Except-operation-in-WDL/idi-p/423351#M17791

Was this reply helpful? Yes No
v-alzhan-msft on at

Like (0)

Report

Re: "Except" Operation in Flow

Hi @ericonline ,

Have you made a test on it?

Best regards,

Alice

Community Support Team _ Alice Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Was this reply helpful? Yes No