web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps Searching large data s...

Power Apps

Answered

Searching large data set in gallery by Text Box and year

(0) Share

Report

Report

Posted on by MJS1987

47

Hi,

I have a sharepoint list that has huge amounts of Items going all the way back to 2015.

Each item has a unique number (Column "eTracker Number")

In my gallery I have successfully added a text box search for that number with this code:

Filter(eTrackers, TextInput1.Text in 'eTracker Number')

but this shows a delegation warning (May not work with large data sets). It only finds me the items from 2015 also.

How can I add to this code in order to search in the text box depending on the current year and last year or the last 200 or so entries?

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (1)

Sort by

Verified answer

Ami K 15,689 Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!
@MJS1987 - some comments.

By "huge amounts of items", I am assuming you have over 2000 records. You cannot Filter on a Date field using a Text Input Control (this control returns a string). In addition, the In function is not delegable.

I would suggest you use the "=" operator or the StartsWith function (which are delegable), together with a Date Picker.

E.g.:

Filter( eTrackers, Len(TextInput1.Text) = 0 || StartsWith( 'eTracker Number', TextInput1.Text ), 'Your Date Column' < DatePicker1.SelectedDate )

Alternatively, you could insert a Checkbox control into your screen. If that Checkbox is checked, the Gallery will filter to display only records created from the current year.

Filter( eTrackers, Len(TextInput1.Text) = 0 || StartsWith( 'eTracker Number', TextInput1.Text ), !Checkbox4.Value || Created >= Date( Year(Today()), 1, 1 ) && Created <= Date( Year(Today()), 12, 31 ) )

These are only a couple of examples and there are many others, but the key point is that the functions used need to be delegable with your data source.

Further reading:

https://learn.microsoft.com/en-us/connectors/sharepointonline/#power-apps-delegable-functions-and-operations-for-sharepoint

Was this reply helpful? Yes No
MJS1987 47 on at

Like
a
(0)

Report
Copy link

Link copied!

Very grateful. Thank you so much.

Was this reply helpful? Yes No

Join the conversation