cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Helper IV
Helper IV

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'

     
     

    MicrosoftTeams-image.png

2 REPLIES 2
Super User II
Super User II

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

Hello, Here is the relationship screenshot .

P_SA_0-1606112675084.png


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

Announcements
secondImage

Experience what’s next for Power Apps

Join us for an in-depth look at the new Power Apps features and capabilities at the free Microsoft Business Applications Launch Event.

Power Apps Community Call

Power Apps Community Call: February

Did you miss the call? Check out the Power Apps Community Call here.

New Power Super Users

Congratulations!

We are excited to announce the Power Apps Super Users!

New Badges

New Solution Badges!

Check out our new profile badges recognizing authored solutions!

Top Solution Authors
Top Kudoed Authors
Users online (95,707)