'Filter array where a property value doesn't exist in another array
Using Power Automate, I want to filter an array where the values in the OrderNumber property don't exist as an OrderNumber in another array.
It seems like it should be a simple task, but I'm not sure how to handle it. I have unsuccessfully experimented with putting it through an Apply to each action, but the original array has 20,000+ items, so that might not work very well/quickly anyway.
Original Array to be filtered:
[
{
"OrderNumber": "1234567",
"CustomerName"" "Customer A"
}
]
Array to check against:
[
{
"OrderNumber": "1234567",
"CustomerName"" "Customer A"
}
]
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|
