[SOLVED] Power Apps - Use LookUp fields in Search function

Power Apps - Use LookUp fields in Search function

I wanted to use the Lookup field in a Search function for my Gallery > Items in Canvas App.

Currently I am using below query:

Search(
   'SRG Scan Quantitiess',
   TextBox_SearchInventory.Text,
   "productcategory",
   "productname",
   "sku",
   "manufacturer",
   "location_textfield"
)

But now, we have replaced the location_textfield with location_lookupfield.

Is there any approach I can use this?

P.S. - I have referred this documentation for syntax of "Search" function but does not seem much helpful for this scenario.

Thanks.

Solution

Try this: using AddColumns() create a virtual column where the lookup is reduced to text. Then use the virtual column to perform the search.

Search(AddColumns('SRG Scan Quantitiess',"LocationText",location_textfield.Value),TextBox_SearchInventory.Text,"productcategory","productname","sku","manufacturer","LocationText")