Filter Array with another array

(0) Share

Report

Posted on by dbeckemeyer

I have a SharePoint List with 2 columns, AssignedID and CompletedID. ID values are stored in each of these in the following format "1,2,3,4". What I am trying to do is anytime a new ID is added to the CompletedID column, it must be removed from the AssignedID column. I have two array variables storing these columns values, varAssignedIDArray and varCompletedIDArray.

varAssignedIDArray = "1,2,3,5"

varCompletedIDArray = "2,3"

Filter Result should be: "1,5"

Any variation I try either provides a result of null or "1,2,3,5". Can't seem to actually get it to filter.

The attached screenshot is the best formula I can come up with.

Help!! Thank you!

Capture.PNG

All responses (1)

Answers (0)

ManishSolanki 15,085 Super User 2025 Season 1 on at

Like (0)

Report
Re: Filter Array with another array

Hi @dbeckemeyer

Here is the sample flow:

[
1,
2,
3,
5
]

[2,3]

Next, add "Filter array" action to get the required array:

@not(contains(variables('varCompletedIDArray'), int(item())))

The output of filter action:

If this helps & solves your problem, please remember to give a 👍 and accept my solution as it will help others in the future.

Thanks