Correction of Filter code

(0) Share

Report

Posted on by MIA27

I was using the below code to filter the gallery and it was working fine:

Filter(TblMachHist,TextInput3.Text in SerialNo)

As the Sharepoint List is having more than 2500 records, so wanted to improve code for sure filter, so trying to apply the below for more powerful filter but it is producing error, could not understand the reason,

"With(
Filter(
TblMachHist,
Len(TextInput3.Text) = 0 ||
TextInput3.Text in SerialNo
)
)"

Please guide correction

Categories:

Building Power Apps

I have the same question (0)

All responses (17)

Answers (2)

Drrickryp Super User 2024 Season 1 on at

Like (0)

Report

@MIA27

Filter(TblMachHist, StartsWith(SerialNo, TextInput3.Text))

Was this reply helpful? Yes No
MIA27 2 on at

Like (0)

Report

Checked earlier with Startwith, it does not work as *text*, also no correct result on data above 2000 of sharepoint list
therefore was trying IN method it is working but worried for later, so was trying With().

please guide

Was this reply helpful? Yes No
Drrickryp Super User 2024 Season 1 on at

Like (0)

Report

@MIA27

You are wrong.

Was this reply helpful? Yes No
MIA27 2 on at

Like (0)

Report

you mean I should try again as below

Current code
Filter(TblMachHist,TextInput3.Text in SerialNo)

Should replace by:
Filter(TblMachHist, StartsWith(SerialNo, TextInput3.Text))

to obtain the filter which will work like *text* for the records around 2300 row

pls. advise,

Was this reply helpful? Yes No
MIA27 2 on at

Like (0)

Report

After posting the reply.
your advised code worked but not working like *text*
It has to be exact.

Pls. suggest

Was this reply helpful? Yes No
Drrickryp Super User 2024 Season 1 on at

Like (0)

Report

@MIA27

Your formula won't work accurately above 2000 records. Mine will work on thousands of records.

Was this reply helpful? Yes No
Drrickryp Super User 2024 Season 1 on at

Like (0)

Report

@MIA27

See @WarrenBelz 's blog Practical PowerApps about delegation in SharePoint.

Was this reply helpful? Yes No
MIA27 2 on at

Like (0)

Report

May be my test is not correct and you people are highly professionals.
Taking as a granted that if applied the below code, it will can handle the large number of records.
Filter(TblMachHist, StartsWith(SerialNo, TextInput3.Text))

But my situation is demanding a code for user for *text*, so if he types a portion also, it will fetch the records according to it. Therefore IN was preferred.

Was this reply helpful? Yes No
MIA27 2 on at

Like (0)

Report

Few days before Mr. Warren helped me for a solution for another screen and I was just trying to apply some portion of it my the current case. Below is the image of the reply.
Kindly review and advise me by referring my first post how to solve it

Was this reply helpful? Yes No
Drrickryp Super User 2024 Season 1 on at

Like (0)

Report

@MIA27

OK but only up to 2000 records max, sorry.

Was this reply helpful? Yes No