DefaultSelectedItems’ property of ComboBox control - Incompatible type for comparison

(0) Share

Report

Posted on by JayneButton

116

In my gallery I have a ComboBox control that is using a SharePoint list as the data source.

The Items property of the ComboBox is:

Choices('OTS Part Details'.CADRequirements)

I am trying to figure out the correct formula for the DefaultSelectedItem property for the ComboBox and receive the following error:

Incompatible type for comparison. These types can't be compared: table, text

Here is the formula that gives this error.

Filter('OTS Part Details', CADRequirements = "OrCad" Or "Mentor" Or "Altium")

I have tried many variations and cannot determine the correct formula to clear this error.

Hoping someone can help!

Regards,

Jayne

Categories:

Building Power Apps

All responses (5)

Answers (1)

Sort by

Ami K 15,689 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
@JayneButton - assuming the "CADRequirements" field is a single-select Choice datatype, could you try:

Filter('OTS Part Details', CADRequirements.Value = "OrCad" || CADRequirements.Value = "Mentor" || CADRequirements.Value = "Altium")
JayneButton 116 on at

Like
a
(0)

Report
Copy link

Link copied!

Hello @Amik

CADRequirements is a Choice column so I assume the formula will be different.
I tried the formula you suggested and still receiving the error.
JayneButton 116 on at

Like
a
(0)

Report
Copy link

Link copied!

Hello @Amik
CADRequirements is a Choice column that uses checkboxes to allow multiple selections so I assume the formula will be different.
I tried the formula you suggested and still receiving the same error.
Verified answer

Ami K 15,689 Super User 2024 Season 1 on at

Like
a
(2)

Report
Copy link

Link copied!
@JayneButton -

As stated, the method provided above assumes the Choice field is single select.

For multichoice, use either:

Filter( 'OTS Part Details', "OrCad" in CADRequirements.Value || "Mentor" in CADRequirements.Value || "Altium" in CADRequirements.Value )

Or:

Filter( 'OTS Part Details', true in ForAll( [ "OrCad", "Mentor", "Altium" ], ThisRecord.Value in CADRequirements.Value ) )

Note that for both methods, the ".Value" syntax will need to be entered manually. In other words, enter "CADRequirements.Value" as shown. This is because for whatever reason, the Value attribute is not automatically detected in intellisense.
JayneButton 116 on at

Like
a
(0)

Report
Copy link

Link copied!

@Amik Thanks very much for the help.

Jayne