Power Platform Community Forum Thread Details

any help apreciated

I have 2 arrays

array1

{

"type": "1",

"capture_date": "cap1",

"sale_date": "sale1",

"order_id": "order1",

"short_order_id": "short1",

"capture_id": "capture1",

"merchant_reference1": "merch1",

"merchant_reference2": "merch1a",

"amount": "amount1",

"posting_currency": "current1"

{

"type": "2",

"capture_date": "cap2",

"sale_date": "sale2",

"order_id": "order2",

"short_order_id": "short2",

"capture_id": "capture2",

"merchant_reference1": "merch2",

"merchant_reference2": "merch2a",

"amount": "amount2",

"posting_currency": "current2"

Array2

{

"type": "2",

"capture_date": "cap2",

"sale_date": "sale2",

"order_id": "order2",

"short_order_id": "short2",

"capture_id": "capture2",

"merchant_reference1": "merch2",

"merchant_reference2": "merch2a",

"amount": "amount2",

"posting_currency": "current2"

{

"type": "4",

"capture_date": "cap4",

"sale_date": "sale4",

"order_id": "order4",

"short_order_id": "short4",

"capture_id": "capture4",

"merchant_reference1": "merch4",

"merchant_reference2": "merch4a",

"amount": "amount4",

"posting_currency": "current4"

}

I need to be able to loop through array1 to check if the values e.g. Type and Order_id are in Array2 if they are do nothing if they are not import them to excel

I can do the update rows n excel but cannot get the 2 arrays to check if the 2 values don't match

I have tried to loop through array1 and then nest a loop for array2 and add a condition which does not appear to work

I am new to powerautomate so if anyone could advise step by step help that would be great

Categories:

Building flows

Community site session details

comparing arrays

Helpful resources

News and Announcements

Quick Links

Season of Sharing Community Challenge Winners!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to the June Top 10 Community Leaders!

Leaderboard > Power Automate

Featured topics

Product updates