Dear all,
May I know that how can I access 2000 records from Share Point list through Power Apps?
I have try to use collection already but it just collect first 2000 records only.
Kindly advice.
Share
ReportConcurrent(
ClearCollect(CollectionA,Filter(varDB,Value(ID)<2000)),
ClearCollect(CollectionB,Filter(varDB,Value(ID) >=2000 And Value(ID)<5000)));
ClearCollect(NameofCollection,CollectionA,CollectionB)
Thanks.
Hi all,
One solution that is frequently forgotten is very useful in cases where a large dataset is used to lookup values that are not edited or modified frequently. There may be a limited application for this but it is great in the right circumstance. An Excel Static datasource can be added in seconds to an app and has a limit of 15000 items. All PowerApps functions work without delegation issues including Collect and ClearCollect. In my post https://powerusers.microsoft.com/t5/News-Announcements/Automatically-Prefill-City-and-State-using-Zip-Codes-in-your-App/ba-p/200465 I was able to bring in 43000 items in a few seconds and combine them into a single collection that I use for looking up cities and states from US zipcodes.
hi,
Please advice: I do not work with a filter with signs greater or less, I can only use equals. Can you give me some advice?
For example: Collect(colXXX; Filter(MySPlist; ID > MaxID))
Is it possible for you to share your flow? I'd be interested in seeing how you've set it up.
Cheers
Hi, I have Canvas apps using lots of records, like >6.000 from Excel or > 10.000 from CDS, saved in collections for further processing.
To overcome the limit of 2.000 recs I would create a flow with Power Automate, triggered by a Power App with the SharePoint List Items action followed by a Respons action.
Within the app you just trigger the flow and receive the data, without any 2.000 record limit.
Works like a charm for me!
Good luck!
Maurits
Dear all,
I have found the problem is collection cause it can not show all the records.
Collection just collect the amount of data as per Power Apps limit.
Thanks for all your contribution advice.
@Anonymous
You cannot filter the SharePoint List ID column using '>' or '<', it only accepts '=':
Note 2 here (link: https://docs.microsoft.com/en-us/connectors/sharepointonline/#powerapps-delegable-functions-and-operations-for-sharepoint)
2. The SharePoint ID field for a table is a number field in PowerApps. However, SharePoint only supports the equal ('=') operation for delegation on an ID field.
To 'access' more than 2000 records in a SP List you need to use a gallery (like @poweractivate suggested) then use Filter() or Gallery.Selected.Item to get access to / adjust these items. You cannot, without serious code, create collections of 2000 record lots in your app - and most seasoned PowerAppers will tell you to not do this anyway. I've had a long learning journey with the same issues.
By default, galleries display data in 100 records (rows) batches so as you scroll to the bottom, the next 100 records are loaded. You can test this in your app by adding a label below you gallery with this code:
CountRows(Gallery1.AllItems)
Then as you scroll to each 100 record set this label will update.
I recommend watching this video series on Delegation by @RezaDorrani . It greatly helped with my understanding of how to access data and managing delegation:
@Anonymous
Yes you can check below and attached
Latest version of Licensing Guide: https://go.microsoft.com/fwlink/?linkid=2085130
On Page 6 of the PDF file (Page 4 of the document) , Per App Plan Details
On Page 7 of PDF file (Page 5 of document), Per User Plan Details
A common assumption people make is they get PowerApps with Office 365.
That is somewhat true, but not all features are included - see Page 8 of PDF file (Page 6 of document)- Office 365 use rights:
Also, see Page 8 of PDF File (Page 6 of document) for Dynamics 365 license use rights with Power Platform:
Also see Page 25 of PDF File (Page 23 of document) for a list of licenses that quality for the limited Office 365 rights or Dynamics 365 rights as they relate to PowerApps.
Also check
https://powerapps.microsoft.com/en-us/pricing/
Right now, PowerApps Plan 1 and 2 may technically still be available for purchase, but there are the new plans which are the main ones, and these are these two plans:
PowerApps Per User Plan
and
PowerApps Per App Plan
Hello @Anonymous
please find attached some information that may help you
#1
WarrenBelz
146,695
Most Valuable Professional
#2
RandyHayes
76,287
Super User 2024 Season 1
#3
Pstork1
66,015
Most Valuable Professional
All responses (
Answers (
