Canvas Apps Dataverse Delegation Expressions

Y – Yes/No column filter – How to make it delegable!

"Yes we can" using Scrabble blocks
"Yes we can" using Scrabble blocks

Introduction

If you use Dataverse, I am certain you would have used the Yes/No column type. A lot of times you would need to filter on these columns.

Filtering using Yes/No column - Non-delegable

The temptation might be to filter with the following code:

Filter(
    Students,
    Text('International?') = "Yes"
)

Filtering using Yes/No column - Delegable

The following is delegable:

Filter(
    Students,
    'International?' = 'International? (Students)'.Yes
)

Or just this (since the Yes is just a true and No is just a false value):

Filter(
    Students,
    'International?'
)

To learn more about delegation, click here.

Stay tuned for the remaining 1 tip!

Recent articles

Leave a Reply