Unanswered

Only able to retrieve 196 Salesforce records

(0) Share

Report

Posted on by fergs083

Hello,

I created a flow that is scheduled to run each morning and retrieve all SF records that are of a certain status and do not have a checkbox filled (if it matters, this is the actual SF query: Status eq 'Disconnect Email' AND RA_Case_Order_Disconnect_Email_Sent__c eq false). It worked great for several months, sometimes retrieving 500+ records. I did not make any changes, but for some reason, it recently started to only return a maximum of 196 records.

I verified that the pagination is set to 1,000 in the settings, but I can only retrieve 196 records. Any ideas why or how to fix?

This is a screenshot to show that I have pagination set to 1,000

This shows that 196 records were returned. There should have been over 250.

Records retrieved.png

Categories:

General topics

I have the same question (0)

All responses (4)

Answers (0)

lbendlin 8,474 Super User 2025 Season 2 on at

Like (0)

Report

How many rows do you get back when you run that query in DataLoader or Workbench (with the same credentials) ?

Was this reply helpful? Yes No
fergs083 4 on at

Like (0)

Report

255 rows. I determined this by a listview that I set up to show how many of these records are pending, and how many get processed each day. There were 255 records in the listview this morning, then the flow ran and processed 196 of them, leaving 59 that did not get processed.

Was this reply helpful? Yes No
lbendlin 8,474 Super User 2025 Season 2 on at

Like (0)

Report

Define "this morning". Remember that the service runs on UTC.

Was this reply helpful? Yes No
fergs083 4 on at

Like (0)

Report

The Power Automate flow is scheduled to run every day at 6:00 AM MT, or 12:00 UTC. The time is not the issue though.
The issue is that there were 850 records that were available to be processed 5 days ago, but the "Get Salesforce Records" activity in Power Automate is only retrieving 196 each day. It has taken 5 days to process records that should have been processed in one day. It is frustrating, because it used to be able to process 800 records at a time, and I didn't make any changes, but now it seems to only be able to do 196 at a time.
Are there any other settings besides pagination that affect how many Salesforce records can be retrieved/processed at a time?

Was this reply helpful? Yes No