Incompatible types for comparison. Numbers, Text can't be compared

Question

In PowerApps, creating an app that individuals use to submit when they want additional vehicle allocation request, so it is tracked in one place. In one of the questions, I've created 3 dropdowns with two being dependent on a previous (2nd dropdown dependent on first, and 3rd dropdown dependent on 1st -> to determine which options to show). The third dropdown field is numbers whereas the first two are text. Receiving an incompatible type for comparison error on the third when I created the depends on value. Any way to fix or go around this?

Table structure

Answer 1

You are facing this issue because you are using different types of columns for comparison (Number and Text).

Also, from table structure image provided in your question, if you want to filter the items based on Series column, you will have to write the formula like:

Filter(Table1_2, Series = 'Series Dropdown'.Selected.Series)

Then you can show Model # column in Value property of your drop down control.

Remember you will need the exact matching fields (both data type and values) for comparison in Filter function.