Answered

Data Table not seeing December Records

(0) Share

Report

Posted on by newbeetle

Hi I have a DataTable that pulls through data from a Sharepoint list, the DataTable is filtered to only show records for teh current year and data for the Current User.

SortByColumns(Filter('Toolbox Talk Monthly Returns', Name = 'Pull-Through-Current-User'.Text && Right('Date.',4) = Text(Year(Now()))),SortColumn,If(SortDecending,Ascending,Descending))

For some reason it will not show records for December, the SharePoint list has not been altered and that does hold December records.

Any ideas welcomed.

Many thanks

Categories:

General Questions

All responses (2)

Answers (1)

newbeetle 56 on at

Like (0)

Report

Re: Data Table not seeing December Records

Hi Jeff,

Thanks for this, adjusting to 2000 has solved the problem 😀, but I see this will be a short term fix as records will go above 2000 next year, I will research for ideas on how to adjust the formula.

Many thanks
Verified answer

Jeff_Thorpe 6,085 Super User 2024 Season 1 on at

Like (0)

Report

Re: Data Table not seeing December Records

I know you mentioned that there are records for December but do the records for December match the current user's name? The other ting that could be causing missing records is a delegation issue. I assume there is a blue line in the formula under "Right('Date.',4)" giving you a warning that the query isn't delegable.

If it is a delegation issue and your list is under 2000, you can go into the Power Apps settings, scroll down in General and change the default Data row limit (delegation limit) from 500 to 2000. If your list is larger then 2000, you will need to change the formula.