Comparing elements of two string arrays

(0) Share

Report

Posted on by Community Power Pla...

Hello Flow Community!

I would like to "compare" elements in two arrays, like eg.:

Array1 ["apple", "orange", "banana"];

Array2 ["strawberry", "apple", "watermelon"];

the thing is that if at least one element (string) is the same in both arrays i would like to eg. send a message.

Did anyone tried something like this, or could give me some hints how to achieve that?

Thanks in advance!

Categories:

General topics

I have the same question (0)

All responses (4)

Answers (1)

Verified answer

v-bacao-msft on at

Like (1)

Report
Copy link

Link copied!
Hi @Anonymous ,

If this comparison does not consider index, but if it has the same element value, it need to send email. You could refer to the following method.

Initialize three variables, two array variables to store the array to be compared, and the integer variable to record how many equal element values.

Iterate through the array 1 and determine if array 2 contains the elements in array 1 that are currently traversed. If they are equal, the value of the integer variable is incremented by 1.

Finally, determine whether the value of integer is equal to 0. If it is not equal to 0, it means that the two elements have the same elements.

Image reference:

Hope it helps.

Best Regards,

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report
Copy link

Link copied!

Hi @v-bacao-msft

It works and that is exactly what i was looking for 🙂

Thank you vary much!

Was this reply helpful? Yes No
sscarcella 239 on at

Like (0)

Report
Copy link

Link copied!

I have tried this method to compare two arrays and if the item doesnt exist in the second list to create it but when I run it again it creates all the items in the array again not just the new item.

Is there a way to loop through all the items and just create the new items? I will also want to update if there is something changed...

I am trying to do a one way sync with Azure SQL table to sharepoint online list.

Was this reply helpful? Yes No
pvlvsk 3 on at

Like (0)

Report
Copy link

Link copied!

HI!
In the list Share Point I have two columns start date and end date, how do I create an array with dates between these two dates?
*I want to count whether it coincides with the list of public holidays to calculate the number of vacation days without holidays.

Was this reply helpful? Yes No