Announcements
I am creating a collections from a SharePoint List using the formula ClearCollect(colStatus,Choices('Huddle Board'.Status)). There is one choice in that Status column that I do not want included in the collection.
How do I adjust this formula to leave out the one choice?
Hi @LR8
Try this
ClearCollect(colStatus, Filter(Choices('Huddle Board'.Status), Value <> "UndesiredChoice"))
Thanks!
If my response has been helpful in resolving your issue, I kindly request that you consider clicking "Accept as solution" and "giving it a thumbs up" as a token of appreciation.
Thanks you very much is works perfectly
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Congratulations to our community stars!
Expanding mentorship, skilling, and AI innovation
These are the community rock stars!
Stay up to date on forum activity by subscribing.
11manish 342 Super User 2026 Season 2
M Bilal Khan 283
Mohsin Ali 221
