Hello!
The apply to each in my flow produces the following results if the item in the apply to each meets certain data processing criteria.
Below are two samples. The first array has two records the second result has one record. Both valid.
I want to append each of the results to a single array.
All of my solution tries have failed. Arrays are nested not a single array of records. I'm also getting nulls if the iteration in the loop does not produce results which is valid. The last attempt is pictured below.
Any suggestions to combine the 'apply to each' output array of records into a single array?
TIA!
First sample:
[
{
"ShopperID": "8123456ff",
"ItemNumber": "773409",
"ItemDescription": "Korean BBQ Beef",
"IsAlcohol": "false",
"AuditTimeStamp": "2025-08-01T17:07:28.189Z",
"BatchID": "688d2c111124d34914233333",
"StoreNumber": "156",
"RetailPrice": "17.990000000000000000",
"ScannedQuantity": "1",
"VoidedQuantity": "0",
"Type": "Normal",
"CategoryNotFoundinOrderedItems": "Marinated Meats"
},
{
"ShopperID": "8123456ff",
"ItemNumber": "43531",
"ItemDescription": "Org Mayo",
"IsAlcohol": "false",
"AuditTimeStamp": "2025-07-28T18:12:10.336Z",
"BatchID": "6887f59b8cb6773788622222",
"StoreNumber": "156",
"RetailPrice": "5.990000000000000000",
"ScannedQuantity": "1",
"VoidedQuantity": "0",
"Type": "Normal",
"CategoryNotFoundinOrderedItems": "MAYO & VISCOUS DRESSING"
}
]
Second sample:
[
{
"ShopperID": "tp123es2z",
"ItemNumber": "276604",
"ItemDescription": "Hd Mango Sorbet",
"IsAlcohol": "false",
"AuditTimeStamp": "2025-07-31T19:39:22.722Z",
"BatchID": "688bfd381124d34914111111",
"StoreNumber": "111",
"RetailPrice": "5.990000000000000000",
"ScannedQuantity": "1",
"VoidedQuantity": "1",
"Type": "Void",
"CategoryNotFoundinOrderedItems": "ICE CREAM PINTS"
}
]
I want to combine these into a single array of objects.
Failed solution try ...