Displaying report results in a gallery

(0) Share

Report

Posted on by Station1901

209

Hello,

I have a gallery which displays the search results from a specified date range but it isn't working properly and I was hoping someone could help. I have 2 date selectors BeginDate and EndDate. As soon as the dates are selected the results displayed in my Gallery using a filter command. The information comes from a Sharepoint list 'MaintenanceLog' which has information going back to 01/01/2018 to the present date. Now here's the puzzling part (for me). If I enter a date range between 01/01/2018 and 09/07/2018 the Gallery will display all of the information requested but if I enter a date range between 10/07/2018 and say 25/11/2019 there are no results displayed even though the data is there in the sharepoint list. I have included the filter formula below I have used in my Gallery though I think I have proved this works as it does produce results before 09/07/2018. I suspect it may be something to do with the actual sharepoint list but I am completely stumped. - any help would be greatly appreciated

The formula in my Gallery is:

'SortByColumns(Filter(MaintenanceLog,Date>=BeginDate.SelectedDate && Date<=EndDate),"Date",Descending)'

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (1)

mdevaney 29,989 Moderator on at

Like (0)

Report
Copy link

Link copied!

@Station1901
Do you need any additional help here?

Was this reply helpful? Yes No
Delid4ve 795 on at

Like (0)

Report
Copy link

Link copied!

You could use msflow to return the data (response or respond to powerapps)

I use response with SQL server, it imports 25000 records into collections from 12 tables in 5-10 seconds.

Each table on its own only takes between 0.1 - 2 seconds depending on size. I dont know if it works with sharepoint but its solved me so many headaches.

Was this reply helpful? Yes No
mdevaney 29,989 Moderator on at

Like (0)

Report
Copy link

Link copied!

@Station1901
Yes, the problem is SharePoint stops looking for matches after the 500th result (or 2,000th if you've bumped up the limit in advanced settings). This is the very definition of a "delegation issue" in PowerApps 😑

Until dates can be delegated I would suggest you try strategy #2 or #3 from my list above.

Was this reply helpful? Yes No
Verified answer

Station1901 209 on at

Like (0)

Report
Copy link

Link copied!

What you have said makes absolute sense. When I've checked the log 09/07/2018 is the 500th record. In reality the results should never exceed 2000 records however the Sharepoint list will hold well over 2000 records - is that the problem ?

Was this reply helpful? Yes No
mdevaney 29,989 Moderator on at

Like (1)

Report
Copy link

Link copied!
@Station1901
I do not believe there is anything wrong with your SharePoint list. Dates cannot yet be delegated in SharePoint. That's why you cannot see past the 500th record when looking for dates between 10/07/2018 and say 25/11/2019.

There are a couple of general strategies you could employ. Which one would you like to follow?
Increase delegation limit to 2,000 records in the advanced settings (works if your list will always be less than 2000 records)
Pre-Filter your results in some way (e.g. Equipment, Location) so the initial result is less than 2,000 then Filter by Dates.
Make a secondary column to store the date as a number in SharePoint (e.g. 2019-11-26 becomes 20191126). In theory this would work but I've never tried it.

---
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."

Was this reply helpful? Yes No