powerapps Gallery filter for partial search to multi column from textbox is not work

[HTDC]

Below is my code, this code give me 0 row result

even though correctly inserted words for txt_search.

Anyone help me to solve this problem.

Filter(MyTable, Or(txt_search.Text in mycolumn1, txt_search.Text in mycolumn2,

txt_search.Text in mycolumn3,txt_search.Text in mycolumn4,

txt_search.Text in mycolumn5,txt_search.Text in mycolumn6,

txt_search.Text in mycolumn7,txt_search.Text in mycolumn8,

txt_search.Text in mycolumn9,txt_search.Text in mycolumn10,

txt_search.Text in mycolumn11,txt_search.Text in mycolumn12,

txt_search.Text in mycolumn13,txt_search.Text in mycolumn14,

txt_search.Text in mycolumn15,txt_search.Text in mycolumn16,

txt_search.Text in mycolumn17),mycolumn18 = dropdown1.Selected.Value)

[ManishSolanki]

Hi @HTDC 

The filter will give result when search textbox value matches with any column value in mycolumn1- mycolumn17 and it should also match the value of mycolumn18 with the selected value of dropdown. Please verify if both conditions are matching or not.

If this helps & solves your problem, please remember to give a 👍 and accept my solution as it will help others in the future.

Thanks

[HTDC]

Hi

Thanks for your reply. 

I'm currently using data verse for data source .

Is Filter case sensitive and how to resolve for delegation?

[HTDC]

Hi

Thanks for your reply.

I'm using dataverse table

about source code didn't work for me. 

even though I put correctly text for search but there's no result that I want.

[v-qiaqi-msft]

HI @HTDC,

Filter() function has case sensitive and the operator "in" does cause delegation issue.

Could you please tell me that if there is error reporting over your formula?

A screenshot is better to describe your scenario.

Anyway, try to modify formula as below:

Filter(MyTable, txt_search.Text in mycolumn1|| txt_search.Text in mycolumn2||

txt_search.Text in mycolumn3||txt_search.Text in mycolumn4||

txt_search.Text in mycolumn5||txt_search.Text in mycolumn6||

txt_search.Text in mycolumn7||txt_search.Text in mycolumn8||

txt_search.Text in mycolumn9||txt_search.Text in mycolumn10||

txt_search.Text in mycolumn11||txt_search.Text in mycolumn12||

txt_search.Text in mycolumn13||txt_search.Text in mycolumn14||

txt_search.Text in mycolumn15||txt_search.Text in mycolumn16||

txt_search.Text in mycolumn17,mycolumn18 = dropdown1.Selected.Value)

Try to filter your table one by one to check if your each part works.

[HTDC]

Hi Qi

Thanks for your reply,

Which function should I use for partial search without using "in" for solving delegation.

I got correctly search result if I set only one condition.

eg; _Search in ThisRecord.mycolumn1 but after I add more condition then only 0 record will return. I already test with || operator also but result is the same.

estimate data row is 2000.

Gallery Filter

[v-qiaqi-msft]

HI @HTDC,

If you use "in" operator, currently, Power Apps does not support to solve this delegation issue, which is a limit.

[HTDC]

Hi Qi

I changed my condition to

Filter(PJ管理,StartsWith(ThisRecord.mycolumn1 , _Search)),

then result come out as I want.

But after I change like below then 0 row will return, no error msg can be shown

Filter(PJ管理,StartsWith(ThisRecord.mycolumn1 , _Search) || StartsWith(ThisRecord.mycolumn2 , _Search))

[v-qiaqi-msft]

HI @HTDC,

Try Seach() function instead.

Search(data,Textinput1.Text,"Field1","Field2","Field3","Field4")

[HTDC]

Hi Qi

Thanks for your support.

I try with Search() function.

the result is the same.

I can only use one field.

Search(Table,Textinput1.Text,"Field1"), then correctly result will be returned.

but

Search(Table,Textinput1.Text,"Field1", "Field2") there's no result .

has my environment any problem?