Hi, I have a few formulas here,
SortByColumns(Filter('Issue tracker',StartsWith('Type of Request'.Value,'search text input'.Text) && Dropdown1.Selected.Value = Blank() || Status.Value = Dropdown1.Selected.Value),"DateReported",SortOrder.Descending)
problems : StartsWith has delegation problem
Sort(Filter('Issue tracker',(Dropdown1.Selected.Value = Blank() || Status.Value = Dropdown1.Selected.Value) && 'Type of Request'.Value='search text input'.Text ),'Date reported',SortOrder.Descending)
problems : && shows nothing in gallery, but when i change to Or, it shows the list of tickets
Note : my type of request from sharepoint list is in choice form
The text input doesn't work( means that when i type, it doesn't do anything) on both formulas, can anyone help me?

Report
All responses (
Answers (