Unanswered

Only 256 Entries show from Sharepoint list?

(3) Share

Report

Posted on by FlashFire

I can only get the first 256 entries to show on a powerapp from a sharepoint list with ~ 1,000 entries.

Online is says that there were problems with delegation 3 months ago where only the first 500 results would show. Responses to that said it would get fixed in about a month, so I'm wondering if this issue is still current, but changed from 500 to 256?

Thanks

Categories:

Building Power Apps

All responses (33)

Answers (0)

Sort by

KeremY Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!

Hi FlashFire, this is a current limitation but we have a fix on the way.

We expect to have this fixed with our next connector deployment, (expected in the next two weeks), and then in a later update we will also add better support for filters, searching and sorting.

Thank you for your patience while we catch up with our backlog and please keep the feedback coming!
Kamil 22 on at

Like
a
(0)

Report
Copy link

Link copied!

Is this solved and SharePoint list can be used with more than 500 items? Can't find any information about, and don't know if I'm doing something wrong or this limitation is still valid.
MichelLaplane 8 on at

Like
a
(0)

Report
Copy link

Link copied!

I have the same problem using browsegallery control from a list datasource. Only the 255 first item are retrieved. Are we able to give a retrieval range.--0-255, 256-499 and so on ?
Are there other turnaround (my list is about 500 items.
Best regards
koconnor 14 on at

Like
a
(1)

Report
Copy link

Link copied!

Has there been any resolution to this? I saw this posted back in August but I am still experiencing this exact issue.
MichelLaplane 8 on at

Like
a
(2)

Report
Copy link

Link copied!

AFAIK not for now but it's very annoying every use of your list is limited to 256 including filtering. So my turnaround was two split my list into several list. I've try to use View in the list and to modify default view of the list but you get always the full list.
I think this is a huge problem.
Perhaps PowerApps team can provide some paging capability.
Community Power Pla... Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!

Hi KeremY,

I can see that you have replied this back in August, it's surely been more than 2 weeks since then and there's still now improvement on this. Can you please at least let us know what's happening?
This is a major step back for anyone trying to use SharePoint with PowerApps.

Thank you,
MelindaK
KeremY Microsoft Employee on at

Like
a
(6)

Report
Copy link

Link copied!

Hi MelindaK, and others who are waiting for this. We apologize for how long this is taking, we hit some snags in our development and testing. We understand that this is an important missing piece and are actively working on this at the moment, and hope to get this deployed during the first half of November.
koconnor 14 on at

Like
a
(1)

Report
Copy link

Link copied!

Please do let us know when the fix has been completed.

Thanks for the response,

Kevin
KProuty 178 on at

Like
a
(2)

Report
Copy link

Link copied!

Showing my Program Director an app next Tuesday, would glady trade you a hamburger today for the upper limit to be fixed next Tuesday! 😉
Community Power Pla... Microsoft Employee on at

Like
a
(2)

Report
Copy link

Link copied!

I get the impression that this is not a high priority for Microsoft in hopes that people will migrate their data from SharePoint to CDS.