Answered

Common Data Service and CSV Data Operation Row Limit?

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Dear Community,

I am working on building this flow to pull data from our common data service and create a CSV table with the information. I am running into a row limit I believe of 5,000 because the CSV file will only ever contain 5,000 rows. The report should come out to over 100,000 rows.

Is there any way to get around this row limit?

Basically I just need to schedule getting data out of a Common Data Service and I thought Power Automate would work well. Any help is appreciated!

Categories:

Building flows

I have the same question (0)

All responses (11)

Answers (1)

Verified answer

MJain 2,450 on at

Like (1)

Report
Copy link

Link copied!

Hi @Anonymous ,

While you are using List Records you can click on ellipsis button at the right and select settings and turn on pagination and add threshold value.

Thanks

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

It is still resulting in only 5,000 rows. Does the CSV Table data operations have a row limit in it?

Thank you for your help!

Was this reply helpful? Yes No
MJain 2,450 on at

Like (0)

Report
Copy link

Link copied!

Hi @Anonymous ,

Which action are you doing first ? is it list records or excel ? Please share screenshot

Thanks

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Yes, I am doing the list records action then creating the CSV table and saving it to a file.

Was this reply helpful? Yes No
MJain 2,450 on at

Like (0)

Report
Copy link

Link copied!

Hi @Anonymous ,

Have you specified value to threshold field to 10000 if you are getting 5000 only.

Thanks

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Yes - I am going to try logging out the web browser and testing again.
Edit: that did not fix anything it is still only giving me 5000 rows on my CSV file.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

I appreciate all your help! Do we know what else it could be? I might reach out to Microsoft soon.

Was this reply helpful? Yes No
MJain 2,450 on at

Like (0)

Report
Copy link

Link copied!

Hi @Anonymous ,

Have you tried saving only selected columns could be up to 5 columns . I tried with 1 and it is showing me 10000 records.

Thanks

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Yes, I just tested it with only bringing in a simple text column and it is still only showing the first 5000 rows, sadly.
Is there a license requirement for using pagination?

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

I found my issue - I am using a fetch xml query which has a row limit of 5,000. Link to article

Was this reply helpful? Yes No