Showing results for 
Search instead for 
Did you mean: 
Helper II
Helper II

App is missing records from SharePoint List

I have SharePoint Online list which has about 320 records.

I am pulling this Items in My app using this formula:


SortByColumns(Filter([@Facility], TextSearchBox1.Text in Facility && Facility_x0020_status.Value = "Active"), "Facility", If(SortDescending1, Descending, Ascending))


I have Items missing in the app. As you can see that I am filtering Items where Status = Active. I made sure that Missing Item's Status = Active.


Please help troubleshooting the missing Items.


Thank you

Helper II
Helper II

I found that I am only getting 256 items from sharePoint online list. 

I tried to change my function to pull all the items, it always brings only 256 items from SharePoint List.

I have read some topics where you guys were mentioning that SharePoint should support 500 list Items.


Please let me know if you have any ideas.


Thnak you

Community Support
Community Support

Hi Daleritf,


What is your PowerApps version? Please update it to the latest version.
May I suggest you recreate the App from data with SharePoint list to see if you could get all the items?


Best regards,
Mabel Mao

Community Support Team _ Mabel Mao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Thnak you for the reply. I have the latest version of app but I think powerApps does not support more than 256 Items from SharePoint list.


If yupo are able to pull more than that, please let me know how do you do this.


Thnak you again

Hi Daleritf,


I test this issue again, I create an App based on SharePoint list which has 500 items, the result is that I there are only 256 items shown in my App. I will follow this issue and update you once I get useful information.


Best regards,
Mabel Mao

Community Support Team _ Mabel Mao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.



I have the same problem with my powerapps application. I have only some objects of my sharepoint list. not all object (more of 500 items).

When i create an object with application it's synchronize on my sharepointlist but when i create on object on sharepoint object is not on powerapps.

I'ts a licence type problem ? Or is anything else ?




Do you have any idea for the solution ? Because we can use this application wihout all datas..


Thanks for you help

I learned about the 256 record limit the hardway.

My intial workaround was to use SPO Workflow and add and delete records as needed.

But, that was a work around.

Now, I'm using the OOB solutions -Common Data Services- provided by PowerApps.  Then I use FLOW to update my SPO list(s).


Good luck.

Helpful resources

PA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

This training provides practical hands-on experience in creating Power Apps solutions in a full-day of instructor-led App creation workshop.

Microsoft Build 768x460.png

Microsoft Build is May 24-26. Have you registered yet?

Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.

May UG Leader Call Carousel 768x460.png

What difference can a User Group make for you?

At the monthly call, connect with other leaders and find out how community makes your experience even better.

Top Solution Authors
Top Kudoed Authors
Users online (1,352)