Incompatible types for comparison - OptionSetValue & Boolean

(0) Share

Report

Posted on by Medoomi

523

I am attempting to filter a Canvas app gallery with the following code:

Filter(
 Projects_1,
 'Opportunity Status'.'Projects Home Default Display' = true
)

But it fails to run. It shows the error as an incompatible type for comparison (OptionSetValue, Boolean).

When I created the 'Opportunity Status' Table, I created the 'Projects Home Default Display' column as a yes/no data type (thinking this would be Boolean).

1) do I need to re-create the table with boolean values (if so, which data type serves as this?)

2) is there a formula which would account for the different data types?

thanks!

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (1)

Sort by

Verified answer

v-qiaqi@microsoft.com Microsoft Employee on at

Like
a
(2)

Report
Copy link

Link copied!
Hi @Medoomi,

Modify your formula as below:

Filter( Projects_1, 'Opportunity Status' = 'Projects Home Default Display' .Yes )

Here is my testing scenario, OnDuty is a OptionSet column with yes/no data type, you could find that 'OptionSetName(TableName)'.Yes is the correct format.

On your side, you could also try:

Filter( Projects_1, 'Opportunity Status' = 'OptionSetName(TableName)'.Yes )

Was this reply helpful? Yes No
Medoomi 523 on at

Like
a
(0)

Report
Copy link

Link copied!
Thank you so much @v-qiaqi-msft

Sadly I may not have described the situation adequately. 'Opportunity Status' is a lookup column within Projects_1. It looks up the Table 'Opportunity Status', and the column (within the 'Opportunity Status' table) that I need to perform the comparison on is 'Projects Home Default Display'.
'Projects Home Default Display' is set to a data type of yes/no within Dataverse.
Filter( Projects_1, 'Opportunity Status'.'Projects Home Default Display' = true )
seems to be the right format, but the data types don't match. Is there a way to change the syntax to accommodate the Boolean value on the right side of the = sign?

Was this reply helpful? Yes No
v-qiaqi@microsoft.com Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!

Hi @Medoomi,

You mean that the you want to filter the child table Projects_1 based on the yes option set from 'Projects Home Default Display' column in parent table 'Opportunity Status', right?

We could compare the option set value with the OptionSetColumn in the same table, but we could not achieve this by comparing no-LookUp column acrossing the tables.

Was this reply helpful? Yes No
Medoomi 523 on at

Like
a
(0)

Report
Copy link

Link copied!
Thanks again @v-qiaqi-msft

Could you help me understand what is going on a bit better? When I had the 'Projects Home Default Display' column set to data type text, the following formula would work:
Filter( Projects_1, 'Opportunity Status'.'Projects Home Default Display' = "true" )
(both being text comparisons).
Now that I changed the data type to yes/no, does an option set column simply introduce an extra level of relationship expansion... Or why won't a comparison work in a filter like this?
Thanks!

Was this reply helpful? Yes No
bugescape 41 on at

Like
a
(0)

Report
Copy link

Link copied!

I have this issue as well, I dont understand why Microsoft just want to **bleep** you over with such a small minor issue

Was this reply helpful? Yes No