Answered

Copying multiple itens in searchbox

(0) Share

Report

Posted on by t1agow

Hello everyone

Is there possible to filter a gallery with various itens?
For example something divided by comma or whatever delimiter. It will be like (Car,Boat,Airplane,etc..)
I want to ctrl c + ctrl v all of these itens and it filter a section

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

BCBuizer 22,551 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!
One option is to use a TextInput (for pasting) and then use that to filter the gallery:

Items = Filter([DataSource],[Column] in Split(TextInput1.Text,", "))

In the above case, the delimiter is ", ", but that can be changed to anything you like.

Was this reply helpful? Yes No
Verified answer

v-qiaqi@microsoft.com Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!
Hi @t1agow,

Do you want to filter the Gallery using strings?

Could you please tell me that if these strings appear in a same column?

Actually, if the Car,Boat,Airplane,etc.. belongs to a same column, I think you could directly filter the Gallery using the strings you paste in the search box. You could use the following formula setting for the Items property:

Filter(Product,Description in Searchbox.Text)// Description column includs the strings I paste in the search box

Was this reply helpful? Yes No
t1agow 92 on at

Like (0)

Report
Copy link

Link copied!

@v-qiaqi-msft Thank you!

How can I resolve the issue of delegation against sharepoint items in this case?

Was this reply helpful? Yes No