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 / Using Search bar to se...
Power Apps
Unanswered

Using Search bar to search two data table in order to filter object by keyword

(0) ShareShare
ReportReport
Posted on by 2

Hi,

I have a gallery that the Data source is A while my powerapps data contains Data source A and Data source B.

In this gallery, I have first label Text setup as " ThisItem.'a' ", which a is one column in Data source A, and second label Text setup as " ThisItem.B.'b' ", which b is one column in Data source B.

I am using searchbar and setup this gallery Items as " Search('Data source A', searchbar.Text, "aa") " so I can use keyword to filter first label, while aa is column a's system name. 

If I want to use the same searchbar, by keyword, to filter second label, which is column b from Data source B, how should I modify " Search('Data source A', searchbar.Text, "aa") "? I found it challenging since it is 2 data source search and filter.

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

    Hi @kentst900271 ,

     

    Could you please share more details about your scenario? How the label B in the gallery could connect to another date source? Since you have "ThisItem.B.'b' " in the Gallery, I would treat B column is in the data source A as well but not a Text column. One point for the Search function is only Text column would be supported to search with:

    https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/functions/function-filter-lookup#syntax

     

    Please provide more details about the two data sources like column types and the way you combined them into one table as the data source of the Gallery. Screenshot would be more helpful.

     

    Best regards,

    Community Support Team _ Jeffer Ni
    If this post helps, then please consider Accept it as the solution to help the other members find it.

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

Congratulations to the July Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 429 Most Valuable Professional

#2
11manish Profile Picture

11manish 191 Super User 2026 Season 2

#3
MS.Ragavendar Profile Picture

MS.Ragavendar 122 Super User 2026 Season 2

Last 30 days Overall leaderboard