I am trying to filter data in Power Apps, but struggling to handle null values in my formula. I attempted to use logical operators like and, as well as functions like and, but none of these approaches worked for my data source (Excel Online, One Drive)

Dropdown items:=

Distinct(
    Filter(Vendor_table, status <> "Waiting for HOD Approval"),
    vendor_name
)

Can anyone suggest the best way to filter data while avoiding the eq null not supported error and delegation warnings?