I have a table T with choice column TStatus. Choice are "Complete" & Balance".
I have added gallery with datasource T and want to filter only those records with TStatus as "Complete". I am using below formula:
Filter(T,'Created By'.'Primary Email' = User().Email && TStatus= "Complete")
I am getting error "Incompatible types for comparison: These types can't be compared: OptionSetValue, Text"
Appreciate help on this from anyone
Solved! Go to Solution.
I am able to solve it with trial and error.
Right formula for filtering choice columns in dataverse will be :
Filter(T,'Created By'.'Primary Email' = User().Email && TStatus= 'TStatus(T)'.Complete)
I am able to solve it with trial and error.
Right formula for filtering choice columns in dataverse will be :
Filter(T,'Created By'.'Primary Email' = User().Email && TStatus= 'TStatus(T)'.Complete)
User | Count |
---|---|
256 | |
110 | |
90 | |
51 | |
44 |