Choice column in a list - data validation

Hi Deleted - you'll want to add conditions to your flow. First, add the SharePoint action to Get Items and point to your List. (if this is a big list, you'll likely want to break it up into List Views and then have the workflow only cycle through a particular view rather than the entire list).

Add a Condition that looks for brand = Nike and status doesn't equal Open. If there isn't an Open item for Nike in that View then it can create the List Item. Repeat for the other brands.

Hope that helps.