Multiple search on a database

[Andrei_Cimpoes]

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!

[CNT]

@Andrei_Cimpoes Try this,

Filter(yourDataSource, yourColumnName in textsearchbox.Text)

[v-qiaqi-msft · Accepted solution]

Hi @Andrei_Cimpoes,

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.

[Andrei_Cimpoes · Accepted solution]

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