Announcements
Filter(colCompras, nn_aprovacaofinal = true)
This would be so good...
But it obviously doesn't work.
nn_aprovacaofinal is a YES/NO field.
What's the trick!?
Hi @WebPortal,
That code should do the trick. Due to the Explicit Column Selection (the app only loads in the columns you actually need) you may have to ClearCollect your collection again after writing that code in your app - saving, closing and reopening the app after writing that code could also do the trick.
If this solves your question, would you be so kind as to accept it as a solution & give it a thumbs up.
Thanks!
Hi @WebPortal
The syntax would be very similar to the syntax from your other post - eg, you would use the yes/no enumeration.
The formula would look like this:
Filter(colCompras, nn_aprovacaofinal = 'nn_aprovacaofinal (YourDataverseTable)'.Yes )
Just like before, you would use the Intellisense in the editor to work out the correct identifier for 'nn_aprovacaofinal (YourDataverseTable)'.
Unfortunately, no intellisense.
@WebPortal - if you type the name of your underlying table, does the Intellisense highlight the name of the enumeration?
To give an example, here's an example of how the syntax looks like against a table called PropertyDocuments and a yes/no column called ContainsPersonalInfo.
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 271
Mohsin Ali 223
