Formula for [Search Value]: [Search String for Multiple Users].Filter(User=User()).SearchFor.First()
Formula for [Search String for Multiple Users] Filter: User=User()
Formula for [Table to Search for Multiple Users] Filter: [Full Text].RegexMatch(CurrentUserSearch.Lower())
Filter formula with an If() statement to show all values if search is empty:
If(CurrentUserSearch.IsBlank(),thisRow.IsNotBlank(),thisRow.[Full Text].RegexMatch(CurrentUserSearch.Lower()))
Formula for [Table to Search for Multiple Users].[Full Text]: Lower(Name+","+Category+","+Notes)