PowerApps Filtering or Searching on LookUp field on Gallery

Question

I am working on a Sold Items table which has ProductIds, which gets the names from "Products" using the ProductIds.

On my powerapp gallery; I use this statement to properly display data;

LookUp('[Products]',Item_Id = ThisItem.Item_Id,Retail_Name) 

which is displayed on Title1.Text

on my gallery form, I use the filter

Filter('[Sold_Items]',Week_Id=Value(TextInputWeekId.Text))

I want to also add the search option, so that I can search;

inputSearchBox.Text = Title1.Text or use the LookUp function over ( Retail_Name ) 

No Matter what I have tried, I couldn't make this work.

Answer 1

From what I understand, you have 2 tables, "Products" and "Sold_Items". Your gallery receives the items from "Sold_Items", and you show the item name using:
LookUp('[Products]',Item_Id = ThisItem.Item_Id,Retail_Name) in the text property of a label that shows the product name.

You filter the gallery to show only the "Sold_Items" of the current week with the following code:
Filter('[Sold_Items]',Week_Id=Value(TextInputWeekId.Text)) in the items property of the gallery.

Now you want to filter the items further more using a text input. Correct me if I'm wrong.

To accomplish this you will need to modify the Items property of your gallery. Your text-input label from where you want to filter the gallery has the name "inputSearchBox".

So, the Items property of your gallery should be:
Filter('[Sold_Items]',Week_Id=Value(TextInputWeekId.Text) && Title1.Text = inputSearchBox.Text)

Let me know if this is what you wanted and if it solved your problem.

Best Regards