Filter list base on dropdown id where the dropdown show name

Actions & Logic

I have two table in supabase, Organization list and Project list which link back to Organziation with the Organizatino id column and no organziation name here. I want to filter this list base on a dropdown of organization name. my dropdown fetch from list vaiable which I use map list items to choose org_name collumn. below is the snapshot of my dropdown setup.

What have you tried so far?

I try to set the variable value base on dropdown On selected but I don't know how I can get the organzation id because the dropdown value is the organzation name.

Did you check FlutterFlow's Documentation for this topic?