Multiple Conditions for Array to update Item

[HUmarelO]

Hi, 

I have a normalised list of 50,000 items with columns for customer, order details and status. I'm trying to get my flow to update when the following occurs: column A equals column A (customer = customer) for a specific customer, get all the records that equal that customer. I'm doing this through OData filter which is working fine. Then for each of those records check if the status equals "Order Ready". This would then trigger an alert to show that a whole customer order is now ready. 

The problem I'm getting is when I have customer = customer & then order status = "Order Ready" for some of the items its triggering the email. I require the email to only be triggered when all the items in the returned (filtered) list equal the status. 

Please could someone assist? 

Thanks in advance! 

[Pieter_Veenstra · Accepted solution]

HI @HUmarelO,

It sounds to me that a flow shoudl be triggered every time an item is updated. Then the Flow shoudl take the data in the item and collect all items with the same customer ( a condition that does the checks).

You could optimize this by querying for the status not equals ready. If you get no items back then you know that all is complete. You can use the length function to count the number of items returned.

[HUmarelO · Accepted solution]

Thanks for the response, 

I used a culmination of your reply & some trial & error. I've compose & filtered an array (which is what you have suggested) and then used a condition based on the count to then complete a final action.