cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
daleritf
Level: Powered On

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

7 REPLIES 7
daleritf
Level: Powered On

Re: App is missing records from SharePoint List

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 Team
Community Support Team

Re: App is missing records from SharePoint List

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.
daleritf
Level: Powered On

Re: App is missing records from SharePoint List

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

Community Support Team
Community Support Team

Re: App is missing records from SharePoint List

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.
Largomax
Level: Powered On

Re: App is missing records from SharePoint List

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 ?

 

Largomax
Level: Powered On

Re: App is missing records from SharePoint List

Hi,

 

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

 

Thanks for you help

Beuferd
Level: Powered On

Re: App is missing records from SharePoint List

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

Announcements
firstImage

Microsoft Business Applications Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

firstImage

Demo Extravaganza Championship Voting Open

Voting Ends: October 30, 2019!

firstImage

Watch Sessions On Demand!

Continue your learning in our online communities.

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

FirstImage

Power Platform World Tour

Coming to a city near you

thirdimage

PowerApps Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

FourthImage

Join PowerApps User Group!!

Connect, share, and learn with your peers year-round

Top Kudoed Authors
Users Online
Currently online: 456 members 5,319 guests
Please welcome our newest community members: