Can't search in lookup sharepoint list column

(1) Share

Report

Posted on by BrosJr.

Hello, I´m trying to make a multi columm search with this sentence:

Search([@base]; TextSearchBox1.Text; Descrição; 'Tombo A'; Anotações; 'Tombo B'; 'Tombo C'; 'Tombo D')
 
All these options are text or number columns and the sentence works fine.
 
However, when I add a lookup columm to the sentence, it´s name underlines red and the sentence stops to work.
 
How can I search all columns? texts, numbers and lookups at once?
 
Thank you in advance.

Categories:

Building Power Apps

I have the same question (0)

All responses (1)

Answers (0)

Suggested answer

ANB 7,223 Super User 2025 Season 2 on at

Like (0)

Report
Hi @BrosJr.

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

Search(AddColumns(DataSource;TEST;LookupColumn.Value);TextSearchBox1.Text;Descrição; 'Tombo A'; Anotações; 'Tombo B'; 'Tombo C'; 'Tombo D';TEST)

NOTE: TEST is the virtual column.

-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

I hope this helps.

Please click Accept as solution ✅ if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs up. 👍

Thanks,
ANB

Was this reply helpful? Yes No