Need Some help in Appsheet

Hello,

Im new to Appsheet and need some basic help in expression.

I have 3 sheets in my file name like Loads, Dispatcher and Driver.

I want to do something like if I select dispatcher name then the next field shows only his assigned drivers list. I did it by lookup expression but only one item shows and not the list. I have also attached screenshot of my app below for the reference.

Your quick and positive response will highly be appreciated.

https://help.appsheet.com/en/articles/961554-dependent-dropdown

Thanks @Marc_Dillon you provide a very helpful solution.