Salesforce Stack Exchange is a question and answer site for Salesforce administrators, implementation experts, developers and anybody in-between. It only takes a minute to sign up.
Sign up to join this community
I want to do an update of a set of records on a daily basis with a flow. We are talking about 5,000 records on a batch. The issue I'm having is that when I assign the individual records to a variable and then to a list variable on a loop, I'm using all of the allowed iterations.
Is there a way to get my data and update it all together without having to loop to save the individual records?
You cannot avoid writing a loop, either in Apex or Flows.
You have to write your own batches, as noted in this help topic.
Here's what that looks like:
The "secret sauce" is that we use the Pause element to reset our limits. For efficiency, set your batch size to a reasonable value.
Here's some relevant screenshots for the various elements:
I hope that this provides enough information for you to get started.
Yes, you can update multiple records in Flow without a Loop in 2 ways.
If you are using a Schedule-Triggered Flow, you can pick an object and criteria to update those records in a batch.
For a record triggered flow, you add an Update Records element and choose "Specify conditions to identify records, and set fields individually". It will get all records that meet the criteria and update with the values you set.
The best answer from sfdcfox really helps! I was able to follow through and build the schedule triggered flow for our SF org.
Just want to add the reference to the SF document for Schedule-Triggered Flow Considerations where it mentions the tip for the pause element:
You can insert a Pause element that pauses the flow for only a moment. Configure the resume event to pause until a specified time, with a specific time as the time source. For the base time, specify the $Flow.CurrentDateTime global variable. Then set the offset to 0 hours. At run time, a Pause element that's set up this way typically pauses the flow for less than a minute.
This is what I wasn't aware when using the 'Pause' element to pause the flow for a moment.
