Answered

Comparing two lists to find what is missing

(1) Share

Report

Posted on by NicolleAbraham

Hi,

I want to compare two arrays; one, I extract a list of emails from a Team and the other, I have an array of emails of who must be in that Team. I use a Compose and split for the second list and an HTTP action to retrieve the emails of the Team members. I then compare the lists in two filter actions so that I can either add or remove members. The filter actions are not comparing and are simply returning the From arras back. Here are my Filter array actions can someone please help me understand where I am going wrong?

TIA

Categories:

Building flows

I have the same question (0)

All responses (5)

Answers (1)

tom_riha 10,185 Most Valuable Professional on at

Like (0)

Report

Hello,

take a look on this article I wrote some time ago, I think it might be what you're looking for: https://tomriha.com/compare-two-arrays-e-g-sharepoint-lists-using-power-automate/.

----------------------------------------------------------------------------------
Did the answer solve your problem? Please click "Does this answer your question" and give it a like to help others in the community find the solution too!

You can find more of my solution on the blog: https://tomriha.com!

Was this reply helpful? Yes No
NicolleAbraham 93 on at

Like (0)

Report

Hi @tom_riha,

I used you article to construct the flows but I still do not understand why it is not working. In your article you did mention the bigger array needs to be in the From attribute can this be a factor as to why mine is not working?

Was this reply helpful? Yes No
tom_riha 10,185 Most Valuable Professional on at

Like (0)

Report

Hello,

From the quick look it seems strange to use the variable once as the input of the first filter and then in the condition of the second filter - what's the point of filtering it if you're using it then again in the original form? I'd try to start again, build it step by step following the article.

Was this reply helpful? Yes No
Suggested answer

w.p 8,339 Super User 2025 Season 2 on at

Like (0)

Report

Maybe there are empty email addresses that need to be filtered out first, or add a condition to not include empty email addresses.

Was this reply helpful? Yes No
Verified answer

NicolleAbraham 93 on at

Like (1)

Report

Hi everyone,

The issue was inconsistent data from the user and the system. I made sure all data was in lower case now it works. @tom_riha there are two filter actions because the one filter detects if there needs to be users added the other checks who needs to be deleted. In the flow those two actions work in parallel but I put them in series for a screenshot. Your article was great by the way super helpful it was just a data issue as I shuld've known.

Was this reply helpful? Yes No