Data Table not seeing December Records

[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

[Jeff_Thorpe · Accepted solution]

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.

[newbeetle]

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