cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
eka
Level: Powered On

Add a Search to filter

Please I am strugggling with adding a search to the following;

 

SortByColumns(Filter(
      Filter(CachedAttendReg,Not(Names exactin CachedAttendDa.Names)),
   Usa=AvCurrentUser.FullName),"Class","Names")

 

The formula works fine except that i want to be able to filter based on the textbox below;
 Names=SearchBox2_3.Text

 

I need help

1 REPLY 1
AndySid
Level 8

Re: Add a Search to filter

Hi,

Try adding && Names=SeachBox2_3.Text

 

SortByColumns(Filter(
      Filter(CachedAttendReg,Not(Names exactin CachedAttendDa.Names)),
   Usa=AvCurrentUser.FullName && Names=SeachBox2_3.Text),"Class","Names")

 

Working example on a dropdown:  SortByColumns(Filter(appDailyJobSheets_1, Employee = Dropdown2_1.Selected.Value && Status = "New"),"Start_x0020_Time")

 

 

>>If you found this reply helpful, please mark this as the answer to close the topic and make it easier to find for other people with similar questions.<<