web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps Search Gallery whit lo...

Power Apps

Answered

Search Gallery whit look field sharepoint

(0) Share

Report

Report

Posted on by Rob_G

55

Hi,
I have a list in sharepoint that has the name prueba2, with 3 columns that obtain information from another list.
I am trying to make a gallery with the list prueba2, but I have no way to make it search in those fields.

Can someone tell me if there is any way?

Categories:

Building Power Apps

All responses Img

All responses (2)

Answers Img

Answers (1)

Sort by

Verified answer

Ramole Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @Rob_G

I understand you will like to search lookup field please use this formula and amend it and make sure you replace those to your field names and dont forget if its lookup you will need .Value
TrackingNumber
Company.Value
InvoiceNumber
Status.Value
ShippingMethod.Value
CodAmount
Month_x0020_and_x0020_Year

SortByColumns( Filter( prueba2, TextSearchBox1_1.Text in TrackingNumber || TextSearchBox1_1.Text in Company.Value|| TextSearchBox1_1.Text in InvoiceNumber|| TextSearchBox1_1.Text in Status.Value|| TextSearchBox1_1.Text in ShippingMethod.Value|| TextSearchBox1_1.Text in CodAmount|| TextSearchBox1_1.Text in Month_x0020_and_x0020_Year ), "Created", Descending )

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also close the item., please consider giving it Thumbs Up.
Rob_G 55 on at

Like
a
(0)

Report
Copy link

Link copied!

Excellent has worked...!!!
It is not possible to use the search formula, because this formula accepts only text fields.
Thank you very much for your support...!!!

Join the conversation