Announcements
Hi everyone,
please check the below image.
How should I write the code? I even tried putting "quotation marks" but still not working. Thanks for helping 🙂
thanks a lot for helping!!! 🙂
@Corleone
You are missed all the quotation marks...
ClearCollect(colActiveIssue, Filter('Craftmanship test', Status.Value = "New" or Status.Value = "Action set-follow up"))
---Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."
Hi,
your formula went through. but I think is not collecting anything.
because afterwards I applied CountRows (colActiveIssue) - and the output is 0. When should be 3.
Can I see a sample of your dataset to determine why that might be the case?
Hi @mdevaney
please find it below.
you would see the column... Status. and 3 reponses: 2 New and 1 action set - follow up.
What data type is your Status column in SharePoint? Is it plain-text or is it Choices?
@mdevaney
Choices!
what do you think? do you have any clue?
thanks!!
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 220 Super User 2026 Season 2
WarrenBelz 194 Most Valuable Professional
Mohsin Ali 150