Enhance List Lookup Field

Please enhance that ability to use more conditions other than "equals" for filtering drop down lists. We have several issues with the 5k limit when filtering from another SPO list. The only option when filtering through all items is "equals value".

We need the following options:

1. Allow multiple conditions to be met.

2. Ability to use "or" along with "and" operator.

3. Ability to sort as desired.

Copy logic used in NAC for data lookups. The "OR" operator needs to be added to NAC as well, but in NAC we are allowed items 1 & 3.