cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Super User
Super User

Re: How to access more 2000 records

Can you try the collection process outside of the Concurrent function as suggested by @dynamicsedge?

---
If you like this reply, please give kudos. And if this solves your problem, please accept this reply as the solution.

Thanks!
Hardit Bhatia
The Power Addict
https://thepoweraddict.com
ivanlawcy
Level: Powered On

Re: How to access more 2000 records

Yes, I am using the List. 

I solved the delegation warning by change data set to variable as I posted.

 

ivanlawcy
Level: Powered On

Re: How to access more 2000 records

@PowerAddict 

 

Yes, I did but I face the delegation warning.

 

Microsoft Yeiner
Microsoft

Re: How to access more 2000 records

Hello @ivanlawcy 

 

please find attached some information that may help you

dynamicsedge
Level 8

Re: How to access more 2000 records

@Yeiner 

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

ivanlawcy
Level: Powered On

Re: How to access more 2000 records

@dynamicsedge and @Yeiner 

 

Did you have the details about these two plans?

 

Thanks

dynamicsedge
Level 8

Re: How to access more 2000 records

@ivanlawcy 

 

Yes you can check below and attached Power Apps Power Automate and Power Virtual Agents Licensing Guide - Jan 2020.pdf 

 

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

 

 

PerAppDetailPage6.png

 

On Page 7 of PDF file (Page 5 of document), Per User Plan Details

 

PerUserDetailPage7.png

 

 

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:

 

Office365RightsPage8.png

 

Also, see Page 8 of PDF File (Page 6 of document) for Dynamics 365 license use rights with Power Platform:

 

Dynamics365RightsPage8.png

 

 

 

 

 

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.

 

Page25AppendixDRights.png

 

 

Also check

 

https://powerapps.microsoft.com/en-us/pricing/

 

PowerAppsPricingComparison.png

 

 

 

Eelman
Level 10

Re: How to access more 2000 records

@ivanlawcy 

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-oper...)

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 @dynamicsedge  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:

https://www.youtube.com/watch?v=gwiErbYtRdA

ivanlawcy
Level: Powered On

Re: How to access more 2000 records

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. 

Highlighted
Maurits
Level 8

Re: How to access more 2000 records

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

 

Helpful resources

Announcements
thirdimage

Power Apps Super User Class of 2020

Check it out!

thirdimage

New Badges

Check it out!

thirdimage

Power Apps Community User Group Member Badge

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

sixthImage

Power Platform World Tour

Find out where you can attend!

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

SecondImage

Difinity Conference

The largest Power BI, Power Platform, and Data conference in New Zealand

Top Solution Authors
Top Kudoed Authors
Users online (5,671)