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
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)
View solution in original post
Keep up to date with current events and community announcements in the Power Apps community.
A great place where you can stay up to date with community calls and interact with the speakers.
Check out the latest Community Blog from the community!