Cascading Dropdown Incompatible Data Types

(0) Share

Report

Posted on by zematsirhc

I'm working on creating a cascading dropdown with two lists as sources (a main input and the second to filter down the choices).

Table one: Cars (contains a combo box for car make and needs to have a second lookup box filtered to model), table two: Cascade (contains make, model).

The formula I'm using is Filter(Cascade, Make = datavaluecardMake.Selected.Value) and I'm getting an error saying incompatible types for comparison.

The data value card referenced has its data source in the Cars table.

I've tried using the Depends On field to circumvent my deficiencies in coding, but I haven't been able to get that to work either.

In the original data source, the column types are "choice" but in Power Apps they're showing up as "Text."

What am I missing?

Categories:

Building Power Apps

I have the same question (0)

All responses (1)

Answers (1)

Verified answer

WarrenBelz 156,440 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @zematsirhc ,

I suspect Make is a Choice field, so you will need

Filter( Cascade, Make.Value = datavaluecardMake.Selected.Value )

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

MVP (Business Applications) Visit my blog Practical Power Apps

Was this reply helpful? Yes No