Search browse gallery based on lookup

(0) Share

Report

Posted on by craigmon

Hi Guys,

I have the following lookup function in my Browse Gallery which shows the cutomer name rather than the Customer ID.

LookUp(Customer, CustomerID= ThisItem.CustomerIDComments, Name)

How do i now search or filter the gallery based on the customer name? At the moment its obviously searching by customer ID.

SortByColumns(Filter(Comments,StartsWith(CustomerIDComments, TextSearchBox1_1.Text)), "Created", Ascending)

Thanks

Categories:

Building Power Apps

All responses (4)

Answers (1)

Sort by

BCLS776 8,994 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!
Try using AddColumns to add a CustomerName column that you can then search:
Search( SortByColumns( Filter( AddColumns(Comments, "CustomerName", LookUp(Customer, CustomerID = CustomerIDComments, Name) ), StartsWith(CustomerIDComments, TextSearchBox1_1.Text) ), "Created", Ascending ), SearchString.Text, "CustomerName" )
Hope that helps,
Bryan

(free-typed, so excuse any typos)
craigmon on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks for this, howvere I'm getting lots of errors when pasting this in. I'm actualy trying to pull the name form the customer table not the comment table. I've tried the below but still getting the same issue

Search( SortByColumns( Filter( AddColumns(Customer, "Name", LookUp(Customer, CustomerID = CustomerIDComments, Name) ), StartsWith(CustomerIDComments, TextSearchBox1_1.Text) ), "Created", Ascending ), SearchString.Text, "Name" )
Verified answer

BCLS776 8,994 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!
You'll get errors wherever I assumed the name of a column or other control. Carefully examine the LookUp statement to make sure it references the common ID column between the Customer and Comments tables. The LookUp should be looking in the Customer table with the ID from Comments to match the customer record.

Are you trying to search only by customer name, and not ID as well? If so, we could simplify the code to:
Search( SortByColumns( AddColumns(Comments, "CustomerName", LookUp(Customer, CustomerID = CustomerIDComments, Name) ), "Created", Ascending ), TextSearchBox1_1.Text, "CustomerName" )
'If it is still giving you trouble, please reply with screenshots of column names from each table and any errors being thrown by Power Apps.

Bryan
craigmon on at

Like
a
(1)

Report
Copy link

Link copied!
Thank you Bryan, the below is perfect. Appreciate your help

Search( SortByColumns( AddColumns(Comments, "CustomerName", LookUp(Customer, CustomerID = CustomerIDComments, Name) ), "Created", Ascending ), TextSearchBox1_1.Text, "CustomerName" )