Answered

I want to know how to compare the values of array A and array B.

(0) Share

Report

Posted on by jeeelly

Hi. I want to know if the values in the String array 'keywordArr' contain the values of the String array 'disasterArr'. (If you include the value, you want to add the value of array A corresponding to the array called 'matchKeyword'. ) I think I need to turn the double iteration statement, but the flow is not working with the current settings. I'm not sure how to do it, how should I set it up?

keywordArr = [
"Correspondent Yoo Hyun-min",
"Korea Standard Time",
"Yonhap News",
"5.6 magnitude earthquake",
"eastern Virginia",
"German Center",
"Geoscience Research",
"Johannesburg",
"Reuters",
"GFZ"
]

disasterArr=[
"earthquake",
"war",
"hurricane",
"typhoon"
]

The condition is set to "item ('keywordArr')" + contains + "item ('varables ('disasterArr'))".

Please share your knowledge. Thank you.

Categories:

General topics

All responses (4)

Answers (1)

Sort by

Manish Solanki 15,169 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @jeeelly

There is no need to use nested 'Apply to each' action. You can compare the arrays using single 'Apply to each' action. Please refer the below flow snippet:
Expression used for left hand operand is:
contains(variables('disasterArr'),item())
Expression used for right hand operand:
true

In your input arrays there is no common item so for the above inputs it will return false for all iterations.

If this helps & solves your problem, please remember to give a 👍 and accept my solution as it will help others in the future.

Thanks
Verified answer

v-bofeng-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @jeeelly ,

The expression is wrong. Please try:

Result:

Best Regards,
Bof
Chriddle 8,729 Super User 2026 Season 2 on at

Like
a
(0)

Report
Copy link

Link copied!
A way to do this without any loop using xpath:

Select
From: outputs('DisasterArr')
Map:
disaster: item()
elements:

xpath( xml( json( concat( '{"root":{"item":', outputs('KeywordArr'), '}}' ) ) ), concat( '//item[contains(text(), ''', item(), ''')]/text()' ) )

Output body('Select'):

[ { "diaster": "earthquake", "elements": [ "5.6 magnitude earthquake", "5.7 magnitude earthquake" ] }, { "diaster": "war", "elements": [ "Reuters war" ] }, { "diaster": "hurricane", "elements": [] }, { "diaster": "typhoon", "elements": [] } ]
Chriddle 8,729 Super User 2026 Season 2 on at

Like
a
(0)

Report
Copy link

Link copied!
To extract the (unique) items, add a compose action with following input:

union( xpath( xml( json( concat( '{"root":{"item":', body('Select'), '}}' ) ) ), '//item/elements/text()' ), json('[]') )

This outputs

[ "5.6 magnitude earthquake", "5.7 magnitude earthquake", "Reuters war" ]