cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
P_SA
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'

     
     

    MicrosoftTeams-image.png

2 REPLIES 2
PowerAddict
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. 

 

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
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

Top Solution Authors
Top Kudoed Authors
Users online (1,454)