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

Notifications

Announcements

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

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
    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

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Automate

#1
David_MA Profile Picture

David_MA 245 Super User 2025 Season 2

#2
Expiscornovus Profile Picture

Expiscornovus 207 Most Valuable Professional

#3
trice602 Profile Picture

trice602 185 Super User 2025 Season 2

Last 30 days Overall leaderboard