web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Sharepoint List Phone ...
Power Automate
Unanswered

Sharepoint List Phone App - Search Function?

(0) ShareShare
ReportReport
Posted on by Microsoft Employee

Hello - I have an employee roster list on sharepoint that I turned into a basic app that lists the employee names and then when I select their name from the list it shows me the rest of the info on the employee roster.  When I try the search field that is defaulted at the top of the app nothing can be found.  The "title" in the list as it appears in the app comes from the "Name1" field and that is what I want searched.  I tried it to the exact text even as capitalized but I want to be able to search for any letters, groups of letters to select the employee name, not verbatim or case sensitive.  What do I need to do to make the search function work?

Categories:
I have the same question (0)
  • v-monli-msft Profile Picture
    Microsoft Employee on at

    Hi @Anonymous,

     

    The Search function finds records in a table that contain a string in one of their columns. The string may occur anywhere within the column; for example, searching for "rob" or "bert" would find a match in a column that contains "Robert". Searching is case-insensitive. Unlike Filter and LookUp, the Search function uses a single string to match instead of a formula.

     

    Are u saying that with "Search" function, when you type "lized" for example, the result of capitalized won't return? If so, would you please create a new app with another connection to test?

     

    For your reference:

    https://powerapps.microsoft.com/en-us/tutorials/function-filter-lookup/

     

    Regards,

    Mona

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Power Automate

#1
Haque Profile Picture

Haque 308

#2
David_MA Profile Picture

David_MA 256 Super User 2026 Season 1

#3
Expiscornovus Profile Picture

Expiscornovus 226 Most Valuable Professional

Last 30 days Overall leaderboard