Forum Discussion
Deleted
Oct 30, 2023Choice column in a list - data validation
Hello, I have a list in Sahrepoint with 3 columns, let's say Brand, Date and Status which is choice type column with 3 possibilities (Open, Pending, Finalized). I have a list of brands and a flow in...
Kelly_Edinger
Oct 30, 2023Bronze Contributor
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.
- DeletedOct 31, 2023
Thak You Kelly_Edinger but that is not what i wanted unfortunately