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

10 REPLIES 10
ivanlawcy
Helper II
Helper II

May I know that who can advice on this?

 

Thanks

eka24
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
PA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

secondImage

Demo Extravaganza is Back!

We are excited to announce that Demo Extravaganza for 2021 has started!

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

Power Apps June 2021

June Power Apps Community Call

Don't miss the call this month on June 16th - 8a PDT

Top Solution Authors
Top Kudoed Authors
Users online (36,586)