cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

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
Anonymous
Not applicable

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.

Anonymous
Not applicable

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.

Anonymous
Not applicable

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.

Anonymous
Not applicable

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

Anonymous
Not applicable

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
Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Difinity Conference 2022

Difinity Conference 2022

Register today for two amazing days of learning, featuring intensive learning sessions across multiple tracks, led by engaging and dynamic experts.

European SharePoint Conference

European SharePoint Conference

The European SharePoint Conference returns live and in-person November 28-December 1 with 4 Microsoft Keynotes, 9 Tutorials, and 120 Sessions.

Power Apps Ideas

Changes to Ideas Coming

We are excited to announce a new way to share your ideas for Power Apps!

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