You’re offline. This is a read only version of the page.
661
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.:
Share
ReportSort(
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
Thanks again, you rock!
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
Thank you so much
No luck on the local version either sadly 😞
@RandomDept - see the earlier message
Thank you!
@RandomDept - I just noticed the name of your Global Choice is "Approval".
Change the expression to:
All responses (
Answers (
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
@RandomDept could you share an image of the error message in the expression
Thank you, sadly I'm getting:
Name isn't valid 'Approval status' isn't recognized.
Invalid use of '.'
Incompatible types for comparison
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
#1
stampcoin
17
#2
mmbr1606
15
Super User 2025 Season 1
#3
ankit_singhal
11
Super User 2025 Season 1
