web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps incompatible types for...

Power Apps

Unanswered

incompatible types for comparison, These types cant be compared: optionsetvalue, text

(1) Share

Report

Report

Posted on by Dorinda

1,512

I am just getting into using the Dataverse and i have a table that has a choice column called expense type.

I want to have a field only show when the choice field is Travel-Day Trips,

I am using this code below which I thought would work,

If(DataCardValue4.Selected.Value = "Travel-Day Trips",true, false)

but I am getting the error.

Any suggestions on how to fix this?

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (6)

Answers Img

Answers (1)

Verified answer

Nogueira1306 7,390 Super User 2024 Season 1 on at

Like (6)

Report
Try this:

If(Text(DataCardValue4.Selected.Value) = "Travel-Day Trips",true, false)

Nit sure if it will work, though..

If you need additional help please tag me in your reply and please like my reply.
If my reply provided you with a solution, pleased mark it as a solution ✔️!

Best regards,
Gonçalo Nogueira

Check my LinkedIn!

Check my User Group (pt-PT)!

Last Post on Community

My website!

Was this reply helpful? Yes No
Pstork1 68,707 Most Valuable Professional on at

Like (1)

Report

The problem is that the value of a choice column in Dataverse isn't actually the text that is displayed. Option columns store their choices in a central location. So you need to use a loopkup to get the value. This article explains.

Power Apps Guide - Dataverse - How to filter Dataverse choice columns - Power Apps Guide - Blog

Was this reply helpful? Yes No
Dorinda 1,512 on at

Like (1)

Report

@Nogueira1306 Thank you that worked perfect

Was this reply helpful? Yes No
Dorinda 1,512 on at

Like (0)

Report

@Pstork1 thank you that helps a lot!!

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

How to solve this error?

Was this reply helpful? Yes No
tsang 9 on at

Like (0)

Report

You need to define your choice list in Dataverse. Example: Filter(Reports, High Level = ListChoiceName.ChoiceName)

Was this reply helpful? Yes No

Join the conversation