I am experiencing difficulties with Microsoft Power Pages platform Search Button in Power Platform Only Returns Results with First Part of Username When using the search functionality for usernames, the search only returns results if the first part of the username is entered. Ideally, I would like the search to work as a "like" search so that any part of the username can be typed in, and the corresponding user will appear in the results.
For instance, if the product name is "Big Chicken" and we type "Chicken" in the search, no results will be shown. The search only returns results when the first part of the name, "Big," is entered.
I would greatly appreciate it if anyone could guide me on how to update the search behavior to work as a "like" search, where any part of the username can be entered to return matching results.
Lucas001
60
Super User 2025 Season 2
Fubar
55
Super User 2025 Season 2
surya narayanan
35