Look up in array, based off CurrentItem, and get data

[MortenBak]

Hello everyone,

I'm trying to build a flow, and I've reached a point where I know what I want, I just don't know how to produce it, and I cant seem to find anything on it.

I currently have 2 arrays, where in Array X, I have some data, and one of these is a Code, like "PR10203040", and in Array Y I have the same "PR10203040", and some other data, most importantly, a more nice-to-read name, that I want. 

I'm trying to add data from both arrays to an email, and send it, but I'm stuck on this; 

How do I make a lookup on Array Y, based on the current items PR code? Like, if it has PR102030, how do I make it look up in array Y for PR102030, and use that data 

If you need any more information, please ask 🙂 

[Chriddle]

If you have few elements in your Array X, you can filter Array Y for each code from Array X.

However, this takes a while for large arrays, and in that case you should convert Array Y to XML and use XPATH to find the names. This can be done within a select action for the entire Array X.

[MortenBak]

Hello Chriddle,

I'm not sure what you mean. 

If I try explaning what I want the end result to be;
I have the email, being sent out to a user, and instead of it saying PR123321, I want the PR code that would have been written, to be looked up in Array 2, and then that Description is what I want to say

So it'd be "Project blabla" instead of PR123321. 

[VictorIvanidze]

Use "Filter array" action.

[MortenBak]

Hello Victor,

I tried using Filter Array, and I'm positive I messed something up. 

I had it in the beginning of a for Each, and used my array, and Array X PR code = Array Y PR code. 
I ended up sending myself over 2500 emails, and there's about 80 PR Codes

[VictorIvanidze]

Show your flow.

[MortenBak]

Hello Victor,

I have removed the second array, because I can't find the time to work on flow for a few months, and it needs to work. The PR codes can be looked up, and its still a big improvement over what we had before. 

The flow is now as follows; 

Here at the start, I'm using a custom connector to access data from Business Central, initialise a variable with a number for comparison later, and initialising my data into an object. 

I then transform my object into an array, using 

variables('Sagsopgavelinjerne').Value

Splitting up the array, so it knows whats what, and at the end Parsing the JSON. 
 

At the end here is my ForEach, which is a few filters in a condition, and then I send if off in a email to one of the consultants. 

In the Email, the Job_No, is the PR code, where I want it to look into the other array, which I can quickly build up again, and say "I have PR code this, so I should only care about the data where PR code matches" 

I hope this makes good enough sense