Showing results for 
Search instead for 
Did you mean: 
Helper V
Helper V

Search functionality to display multiple fields in a gallery

I am trying to fetch a search result into a collection.
The collection will have three fields.
  1. Customer ID
  2. Customer Name
  3. Project ID

    Example : When I type "Test" in the search box and hit tab ( which will trigger on change function in PowerApps) ,It should fetch me all results which has the string "Test" in the CDS tables.

    there are two CDS tables in following hierarchy
    - Customer
    - Project

    so when I search for "test" it should fetch me the customer details and related project from the tables.

    they are all linked with a lookup field legal entity.
    In below image, DAT-00001.00043 is the Customer ID, 
                               Billing rule test is Customer Name
                               ST3C-00001 is the project ID

    the blue block written " search for client/matter by name or ID" is the search box and below that is the search results of "test'



Super User
Super User

Hi @P_SA 


Can you please let me know what is the relationship between Project and Customer? Is it a simple lookup or one to many? Also, what is the Items property of the gallery? Let me know and I can suggest you a couple of different options. 


If you like this reply, please give kudos (Thumbs Up). And if this solves your problem, please mark this reply as a solution by selecting Accept as Solution. This makes it easier for others to find answers to similar questions. 



Hardit Bhatia

Microsoft Business Applications MVP

Microsoft Certified Trainer MCT

Blog | Twitter | LinkedIn | Facebook | YouTube  |  Email

Hello, Here is the relationship screenshot .


Basically I am trying to collect the seach results and then display it in the gallery. the items property of the gallery would be the collection of search result.
Example.  if i type Mercedes in the search box, it should fetch me all the results of Mercedes into the collection. 

Helpful resources

Power Apps News & Annoucements carousel

Power Apps News & Announcements

Keep up to date with current events and community announcements in the Power Apps community.

Community Call Conversations

Introducing the Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Apps Community Blog Carousel

Power Apps Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Users online (4,628)