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 Apps / Autosearch based on a ...
Power Apps
Answered

Autosearch based on a string or substring on a gallery to filter items.

(0) ShareShare
ReportReport
Posted on by Microsoft Employee

1) I have a text input control and a gallery (outer) displaying items (label) and also a gallery(inner) embedded within the outer gallery which also holds labels.

1) when user enters string or substring in text input , my criteria is to search for the matching text in the list of items in outer gallery     and display the items matching the text

2) It should also serach for the same string in inner gallery and also display the list.

 

Can anyone help me here for the formula or expression.

Categories:
  • Verified answer
    v-micsh-msft Profile Picture
    Microsoft Employee on at

    You should be able to make it with the Search function.

    Assuming the TextInput is named as TextInput1, outer gallery is named as Gallery1, Inner is Gallery2.

    To have the same string searched within each Gallery, under the items property of each, input the formula below:

    Items property for Gallery1 (Assuming Table1 is for Gallery1, with Column1, Column2,.....):

    Search(Table1, TextInput1.Text, Column1, Column2 ...)

    Items property for Gallery2 (Assuming Table2 is for Gallery2, which has Column3, column4 ....):

    Search(Table2, TextInput1.Text, Column3, Column4...)

    For the Search function, see:

    Filter, Search, And Lookup functions in PowerApps

     

    Regards,

    Michael

  • v-micsh-msft Profile Picture
    Microsoft Employee on at

    Do you need any further help on this topic?

     

    Regards,

    Michael

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

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Leaderboard > Power Apps

#1
11manish Profile Picture

11manish 383 Super User 2026 Season 2

#2
Mohsin Ali Profile Picture

Mohsin Ali 356

#3
WarrenBelz Profile Picture

WarrenBelz 232 Most Valuable Professional

Last 30 days Overall leaderboard