Remove an element from an array in flow

(1) Share

Report

Posted on by surfer1978

Hello

I have an array that looks like this called array 1

[
 {
 "claims":"user1"
 },

 {
 "claims":"user2"
 },
 
 {
 "claims":"user3"
 }
]

I have a separate array variable called array 2 with the following

[
 {
 "claims":"user2"
 }
]

I would like to compare the array 2 with array 1 to see if 'user 2' is in that array 1, if they are, I would like to remove them from that array

Thanks for your help!

Categories:

Building flows

I have the same question (0)

All responses (8)

Answers (0)

RezaDorrani 12,145 on at

Like (10)

Report
Copy link

Link copied!

Hi @surfer1978

Intersection function between the 2 arrays will give you results if there is match
so do intersection of both arrays and then check length of output
if length is 1 - then item exists in array

Next for removing item
Use filter action on array 1 (whih is your main array)

and filter if
item()?['claims']
is not equals to
dynamiccontentarray2?[0]?['claims']

Regards,
Reza Dorrani

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
Ed Gonzales 4,531 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

@surfer1978

Hi there! Will Array 2 only ever have one value? If so, I wonder if you could set it to a string, then do a step to build a new Array (1A?) with each line that does not equal the string in #2?

I think leaving #2 as an array will get weird because of the many to many potential...that's why I asked.

Keep us posted.

-Ed-

If this reply has answered your question or resolved your challenge, please consider marking it as a Solution. This helps other users find it more easily via search.

Was this reply helpful? Yes No
SrivHari Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

In the same example provided I just want to remove "Claims" keyword or element in the output.. what should be done for that ?

Was this reply helpful? Yes No
dee2005 95 on at

Like (0)

Report
Copy link

Link copied!

@edgonzales , how would you build the new array to exclude the text?

Was this reply helpful? Yes No
Ed Gonzales 4,531 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Hi there. Same as @RezaDorrani . To exclude the "Claims" bit, in whatever step you're using the dynamic value, just grab the value rather than the whole element of the array. Parse JSON might make that easier.

Was this reply helpful? Yes No
Paulie78 8,422 Moderator on at

Like (3)

Report
Copy link

Link copied!

@dee2005 this is an approach you could use to remove the unwanted value and remove the claims property at the same time. To my mind, there is no point checking if the value exists and then remove it. That is two actions when one will do. Just remove it, if it does not exist it wont do anything.
https://ibb.co/1nTKdyY
Result is a plain array with just these results:
This example is only any good if your array2 only ever contains a single element.

Was this reply helpful? Yes No
dee2005 95 on at

Like (0)

Report
Copy link

Link copied!

Thanks @Paulie78 I guess I dont need a second array? I can just pass the text I want to remove in the filter array condition?

Was this reply helpful? Yes No
Paulie78 8,422 Moderator on at

Like (0)

Report
Copy link

Link copied!

@dee2005 correct

Was this reply helpful? Yes No