Showing results for 
Search instead for 
Did you mean: 
Helper III
Helper III

Looking up array values in Power Automate

I have two array variables that look like this 


Array 1 : 

Array 2
What is the best way to do a lookup, so if any values match, then it needs to be flagged. 
I tried to do a condition inside a apply to each look where i wrote
For Each Array 1,
  If Array 1 is equal to Array 2 then do this.... 
But it doesnt work - it appears to look at every value in the array, i need it to look at each individual value. 
Super User III
Super User III

Hey Mate,


Can you have a look at the


If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!



I have kind of got it to work, but now i have the issue below

I have two arrays. 


Array 1 is the first output. and Array 2 is the bottom output (With the formatting)




I have a If condition written where if the numbers match, then do this etc. 


If you look at the top output and the bottom output, they look the same, but the bottom output is formatted as XML, therefore i beleive the condition is not picking them up as the same. 


Any ideas on how to resolve that? (p.s i can assure you the employeeNumber is exactly the same in both outputs - i just crossed it out)


Helpful resources

Process Advisor

Introducing Process Advisor

Check out the new Process Advisor community forum board!

MPA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

V3_PVA CAmpaign Carousel.png

Community Challenge - Giveaways!

Participate in the Power Virtual Agents Community Challenge

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Users online (3,386)