Hi there,
You're right about the array - that parts easy though, it's a manual one time thingy. You can do "Initialize Variable", type of "Array", and just type in [ "Company1", "Company2", "Company3", "Company4" ] -- and that part is done.
Next, you'll use an Apply to Each action, and point it at your array.
You can use the "Get Items" action, and in that action on Filter Query, you can enter CompanyName eq 'Current Item' (Type ' ' and then between those apostrophes, click and select Dynamic Content, scroll all the way to the bottom, and select Current Item)
That will bring back only those items where that company is in that column.
Next, you can use a Compose and use the expression length() - point it at the Body output from Get Items.
Then, you can use a condition to see if that number is more than 10 - and send an email if it is.
