Need help with dynamic dropdowns from supabase

Actions & Logic

Im trying to have one dynamic dropdown (contractor) filtered from another dynamic dropdown (company) which then filters a list.

Problem is when i filter the Contractor list with no Company selected, i get no results. I assume expecting a null company against the contractor.

If i try to filter the contractor dropdown in the options definition, the 'Map List Items' isnt available for the 'Filter List Items'

This cant be an uncommon requirement but no amount of googling has found an answer, how is this parent/child dynamic dropdowns via Supabase done by others?

What have you tried so far?

Two examples provided above, i have also tried adding Company to app states but run into the same issue with missing 'map list item' with any filtering or conditions.

Did you check FlutterFlow's Documentation for this topic?
Yes