Data Row Limit Update

[ATUFAILHAASAN]

I am having a power app setup that pulls data from a share-point list. I have the Gallery setup to show the data from my Sharepoint list. But once my Sharepoint list hits the 2000 limit it does not update any further and it stop showing the list. 

How can I make the power app list to show just the latest 2000 records and or update my sharepoint list to create a power flow to move anything more than 2000 records to a different sharepoint list along with attachments. 

[Pstork1]

You can't go higher than the 2,000 records. But you can have the gallery show the latest 2,000 records.  Sort the records by Created or Modified date in Descending order and then take the first 2,000 records. That will be the latest 2,000 records created or modified depending on which date you sort on.

[TheRobRush]

for starters, make sure you write all the stuff inside powerapps to be delegable. should help with viewing higher number of items (get rid of those yellow !'s) you can also write 

 Sort(listName, ID, SortOrder.Descending)

and items will be returned to your gallery in reverse order IE) most recent first.

you can also duplicate the list and rename it something like listnameArchive and then have at a certain time of day have powerautomate do a pull on it filtering the odata to anything older than say 60 days and take that and create that in archive list, then remove from original list. can also base that on a completed column etc anything you want really

[ATUFAILHAASAN]

Hello @TheRobRush ,

This is how I have set my gallery Items. But it still doesnt pull the latest data. 

Can you help me with how to do the power automate thingy and does it also transfer the attachments? 

[TheRobRush]

Going to be a lot of delegation issues there, but in the meantime (before jumping to flow) might see if restructuring the filter like so might work better for you

Filter(
	Filter(
	 	SortByColumns('Stator Hourly Inspection_2',ID,SortOrder.Descending),
			And(
				Created >= DateFrom_1.SelectedDate, 
				Created <= DateTo_1.SelectedDate
		   	   )
      		),
             And(			
			Overall_Status.Text in 'Overall Status 2', 
			SerialNumberSearch.Text in 'Stator Assembly Serial Number' 
		)
	)

[TheRobRush]

*Edit 
    Changed Sort to SortByColumns

[ATUFAILHAASAN]

[ATUFAILHAASAN]

[TheRobRush]

Powerapps is case sensitive and you dont have descending written anywhere in there uncapitalized so I am not sure where this error is coming from. place my code in a notepad and clear the items property of the gallery then start off by TYPING this part, 

SortByColumns('Stator Hourly Inspection_2',ID,SortOrder.Descending)

but do it manually so you can see the suggestions as you go. ID is a column on EVERY sharepoint list so it should have been fine to use as the sort. Once you get that part working add the stuff before and after it back in one piece at a time as well.