App is missing records from SharePoint List

[daleritf]

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

[daleritf]

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

[v-yamao-msft]

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

[daleritf]

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

[v-yamao-msft]

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

[Anonymous]

Hello,

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 ?

[Anonymous]

Hi,

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

Thanks for you help

[Beuferd]

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.