cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
ivanlawcy
Helper II
Helper II

Export CSV

Hi,

 

I try to export CSV file from Sharepoint. However I face a problem that Powerapps can not export more than 2000 records.

Unless we scroll the gallery until in the end. Then we can export more than 2000 records.

 

Source for learning : https://www.youtube.com/watch?v=QTbVMu6DIfQ

 

Kindly advice.

 

Thanks.

 

1 ACCEPTED SOLUTION

Accepted Solutions

Try creating a collection on the Onselect of a button, then use the Collection name CombinedRecords on your Gallery;

Concurrent(
ClearCollect(col1,
Filter('YourSPList', ID >= 1 && ID <= 2000)),
ClearCollect(col2,
Filter('YourSPList', ID >= 2001 && ID <= 4000)),
ClearCollect(col3, Filter('YourSPList', ID >= 4001 && ID <= 6000)),
ClearCollect(col4, Filter('YourSPList', ID >= 6001 && ID <= 8000)),
ClearCollect(col5, Filter('YourSPList', ID >= 8001 && ID <= 10000)));
ClearCollect(CombinedRecords, col1, col2, col3, col4, col5)

Note that if you don't have an ID Column, create one

------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

View solution in original post

11 REPLIES 11
ivanlawcy
Helper II
Helper II

May I know that who can advice on this?

 

Thanks

eka24
Super User
Super User

Watch this tutorial, that should address your request;

https://youtu.be/IOG0AecA6xE

------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

Hi @eka24 

 

Thanks for your reply,I had study and try to implement it.

However I do not have the luck that the responses feature in under Premium license, then the sharepoint limit still at 5000 records only. It can not export as per our list records.

Hope that we can discuss and come out an solution.

I will update this post once I got the answer too.

 

Thanks.

Try creating a collection on the Onselect of a button, then use the Collection name CombinedRecords on your Gallery;

Concurrent(
ClearCollect(col1,
Filter('YourSPList', ID >= 1 && ID <= 2000)),
ClearCollect(col2,
Filter('YourSPList', ID >= 2001 && ID <= 4000)),
ClearCollect(col3, Filter('YourSPList', ID >= 4001 && ID <= 6000)),
ClearCollect(col4, Filter('YourSPList', ID >= 6001 && ID <= 8000)),
ClearCollect(col5, Filter('YourSPList', ID >= 8001 && ID <= 10000)));
ClearCollect(CombinedRecords, col1, col2, col3, col4, col5)

Note that if you don't have an ID Column, create one

------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

View solution in original post

Your suggestion is not bad.

However it will cause a delegation in list when I applied your suggestion.

 

Thanks

Have you tried the formula, what Delegation did you get or anticipate getting?

The formula is rather to avoid delegation issues.

Can you give details of the delegation you are talking about?

------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

Hi @eka24 

 

I had solve the problem when I use the SQL as my database by using your method.
It is not a perfect solution ,but it can solve the current problem. The delegation will happened when use filter the ID range in list.

 

Thanks

Hi @eka24 ,

 

I have a question the method you give. I try already it can appear once. But I face another problem that it can not show others fields.

May I know that why?

 

Concurrent(
ClearCollect(col1,
Filter('YourSPList', ID >= 1 && ID <= 2000)),
ClearCollect(col2,
Filter('YourSPList', ID >= 2001 && ID <= 4000)),
ClearCollect(col3, Filter('YourSPList', ID >= 4001 && ID <= 6000)),
ClearCollect(col4, Filter('YourSPList', ID >= 6001 && ID <= 8000)),
ClearCollect(col5, Filter('YourSPList', ID >= 8001 && ID <= 10000)));
ClearCollect(CombinedRecords, col1, col2, col3, col4, col5)

Is there any steps need to take care of it?

 

Thanks

Please explain further, which field is not showing

------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

Helpful resources

Announcements
PA_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Welcome Super Users.jpg

Super User Season 2

Congratulations, the new Super User Season 2 for 2021 has started!

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Top Solution Authors
Top Kudoed Authors
Users online (1,194)