Search functionality to display multiple fields in a gallery

[P_SA]

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'
   
    

   

[PowerAddict]

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. 

Thanks!

Hardit Bhatia

Microsoft Business Applications MVP

Microsoft Certified Trainer MCT

Blog | Twitter | LinkedIn | Facebook | YouTube  |  Email

[P_SA]

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.