Hello! I need your help. I have a problem when entering a formula (no errors found), the data in the table is no longer displayed. I don't know how to fix it.
My formula:
And the result:
But if I use only Filter ( StartsWith ( ... all is good

Hello! I need your help. I have a problem when entering a formula (no errors found), the data in the table is no longer displayed. I don't know how to fix it.
My formula:
And the result:
But if I use only Filter ( StartsWith ( ... all is good
Use this method for your dropdown code
Sort(
Filter(
yourList,
// Note: I have enclosed this condition inside brackets
( Len(Dropdown1.Selected.Value) = 0 || columnName = Dropdown1.Selected.Value )
// StartsWith code starts here
),
yourSortingColumn
)