Unanswered

Contains() expression between two arrays

(0) Share

Report

Posted on by dwalker97

I have two arrays, ManipulatedStrings and AllAccounts. I am searching to get any ManipulatedStrings items that are contained in an array called AllAccounts. This individual process in my flow takes roughly 1 hour to find each true output. AllAccounts has 5000 rows, and my ManipulatedStrings array stores 5 for this example. It took me 5.5 hours to run this as a test ‌‌

This is what it looks like currently:

Can anybody help me with this? Is there any quicker way of doing this? Im not sure why this takes so long.

Thanks!

Categories:

Building flows

I have the same question (0)

All responses (4)

Answers (1)

Expiscornovus 33,189 Most Valuable Professional on at

Like (0)

Report

Hi @dwalker97,

If the structure of both of your arrays are the same you could try and use the intersection function to find the items both collections have in common:

https://docs.microsoft.com/en-us/azure/logic-apps/workflow-definition-language-functions-reference#intersection

Let me know if that works for you.

Was this reply helpful? Yes No
dwalker97 82 on at

Like (0)

Report

Hey @Expiscornovus , in my flow I am making two searches. One is for Exact Matches, where I am using the intersection function and works perfect. The above problem is where I am trying to find Possible Matches, so it is different because I need to find array rows that may contain my ManipulatedStrings item.

For example, 'Company A' is an item in ManipulatedStrings. If there is a 'Company A Ltd' in AllAccounts, it will be a possible match and written to my excel sheet, hence the contains expression 🙂 Thanks!

Was this reply helpful? Yes No
Expiscornovus 33,189 Most Valuable Professional on at

Like (1)

Report

Hi @dwalker97,

Sorry, I missed the 'possible match' part of your requirement. You are right, my suggestion only works with exact matches.

Let me go back to the drawing board to see if I can find another approach 😁

Was this reply helpful? Yes No
Verified answer

dwalker97 82 on at

Like (1)

Report

@Expiscornovus , I have found the solution to my own problem! 😁

Iterate through each array item (SearchAccounts = ManipulatedStrings in below screenshot), I changed the naming.

The output of each iteration provides me with results of contain! Much quicker than my original post also.

Was this reply helpful? Yes No