Export CSV

[ivanlawcy]

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.

[ivanlawcy]

May I know that who can advice on this?

Thanks

[eka24]

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.

[ivanlawcy]

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.

[eka24 · Accepted solution]

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.

[ivanlawcy]

Your suggestion is not bad.

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

Thanks

[eka24]

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.

[ivanlawcy]

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

[ivanlawcy]

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

[eka24]

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.