cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
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

10 REPLIES 10
Helper II
Helper II

May I know that who can advice on this?

 

Thanks

Super User III
Super User III

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
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

News & Announcements

Community Blog

Stay up tp date on the latest blogs and activities in the community News & Announcements.

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Community Highlights

Community Highlights

Check out the Power Platform Community Highlights

Top Solution Authors
Top Kudoed Authors
Users online (8,364)