Got it. (This is where tiny little dataset examples help illustrate very well.)
Okay, so given this dataset:
John Smith, John, Smith, Microwaves 101
John Smith, John, Smith, Microwaves 102
John Smith, John, Smith, Toaster Safety
Bob Jones, Bob, Jones, Microwaves 101
Bob Jones, Bob, Jones, Safe Lightswitch Operation
Carly Simon, Carly, Simon, Mixer Board 201
You want them to type in "bob" and have the list (perhaps a gallery, perhaps another control) show only:
"Bob Jones"
So, based on the code snippet you sent earlier, try this:
SortByColumns(Filter(Distinct("Training Matrix", "Title"), StartsWith ("Title", TextsearchBox1.text)), "Title", If(SortDescending1, Descending , Ascending))
Distinct returns a single-column table, and that column should keep its name, "Title", so that should pass through to your StartsWith and your SortByColumns. Let me know...
The next question will be, "How do they search by last name?" And that's a different conversation... 🙂