I'm confused with 'Choice' columns and the filtering in Canvas apps

(0) Share

Report

Posted on by RandomDept

718

So, I think I'm a little confused.

I have a Dataverse Table with the following settings: for the Column - 'Approval Status'

When comparing them / trying to filter in Canvas I find I usually have to refer to them as = 10 for Pending approval etc.

Doesn't seem to work when trying to use the Text values.

Eg, In a gallery I am using the below which works.:

Sort( 
 Filter(GB_Recipients, 'Approval status' = 20),
'Created On',
SortOrder.Descending
)

But this doesn't:

Sort( 
 Filter(GB_Recipients, 'Approval status' = "Approved"),
'Created On',
SortOrder.Descending
)

I want to compare to the actual text instead of the number value.

What am I doing wrong 🙂

Thank you

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (10)

Answers (1)

Sort by

Ami K 15,689 Super User 2024 Season 1 on at

Like
a
(2)

Report
Copy link

Link copied!
@RandomDept ,

For a Local Choice, try:

Sort( Filter( GB_Recipients, 'Approval status' = 'Approval status (your table plural name)'.Approved ), 'Created On', SortOrder.Descending )

For a Global Choice, try:

Sort( Filter( GB_Recipients, 'Approval status' = [@'Approval status'].Approved ), 'Created On', SortOrder.Descending )

------------------------------------------------------------------------------------------------------------------------------

If I have answered your question, please mark your post as Solved. Remember, you can accept more than one post as a solution.

If you like my response, please give it a Thumbs Up.

Imran-Ami Khan

Was this reply helpful? Yes No
RandomDept 718 on at

Like
a
(0)

Report
Copy link

Link copied!

Thank you, sadly I'm getting:

Name isn't valid 'Approval status' isn't recognized.
Invalid use of '.'
Incompatible types for comparison

Was this reply helpful? Yes No
Ami K 15,689 Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!

@RandomDept could you share an image of the error message in the expression

Was this reply helpful? Yes No
Verified answer

Ami K 15,689 Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!
@RandomDept - I just noticed the name of your Global Choice is "Approval".

Change the expression to:

Sort( Filter( GB_Recipients, 'Approval status' = [@Approval].Approved ), 'Created On', SortOrder.Descending )

------------------------------------------------------------------------------------------------------------------------------

If I have answered your question, please mark your post as Solved. Remember, you can accept more than one post as a solution.

If you like my response, please give it a Thumbs Up.

Imran-Ami Khan

Was this reply helpful? Yes No
RandomDept 718 on at

Like
a
(0)

Report
Copy link

Link copied!

Thank you!

Was this reply helpful? Yes No
Ami K 15,689 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@RandomDept - see the earlier message

Was this reply helpful? Yes No
RandomDept 718 on at

Like
a
(0)

Report
Copy link

Link copied!

No luck on the local version either sadly 😞

Was this reply helpful? Yes No
RandomDept 718 on at

Like
a
(0)

Report
Copy link

Link copied!

Thank you so much

Was this reply helpful? Yes No
Ami K 15,689 Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!

@RandomDept -

Not sure if you saw my earlier message. You need to input the name of your Global Choice, not the Dataverse table name.

You can find the name of your Global Choice via the Choices menu:

------------------------------------------------------------------------------------------------------------------------------

If I have answered your question, please mark your post as Solved. Remember, you can accept more than one post as a solution.

If you like my response, please give it a Thumbs Up.

Imran-Ami Khan

Was this reply helpful? Yes No
RandomDept 718 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks again, you rock!

Was this reply helpful? Yes No