Answered

Multiple search on a database

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hi community,

I have a Power App. I added a textsearchbox and a gallery. I connected the gallery to a datasource. In a column from the datasource I have a large string and when I type in the textsearchbox (e.g. python,java) I want to have in the gallery those records that have python and java. How can I achieve this?

Thank you!

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (2)

Sort by

CNT 10,921 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@Anonymous Try this,

Filter(yourDataSource, yourColumnName in textsearchbox.Text)

Was this reply helpful? Yes No
Verified answer

v-qiaqi@microsoft.com Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Anonymous,

Have you solved your problem?

Do you want to filter the Gallery based on search box with multi strings?

Could you please tell me that if you want both the strings you input or either of them you input?

If you want to filter the records that including python and java in a column at the same time, you should try to set the Gallery Items property as below:

Filter([@Actions], TextSearchBox1.Text in MultiLine)

If you want to filter the records that including python or java, you should refer to the formula from @CNT.

Was this reply helpful? Yes No
Verified answer

Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @v-qiaqi-msft ,

I've managed to solve this issue. I create four textboxes and added a formula
Filter([@Actions], TextSearchBox1.Text in MultiLine)
with the and operator and it's working.

Best regards,
Andrei

Was this reply helpful? Yes No