Comparing elements of two string arrays

[Anonymous]

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! 

[v-bacao-msft · Accepted solution]

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,

[Anonymous]

Hi @v-bacao-msft 

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

Thank you vary much!

[sscarcella]

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.

[pvlvsk]

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.