I have a user case to update more than 2000 records at the end of each month. When a condition of the parent record is true a child record need to be updated. One parent record is having only one child record and can be more than 2000 parent records for each month. My flow picks first 100 records and then fires 101 SOQL error.

I collect all parent records and loop through to get the corresponding child record. As it it is running a SOQL query for each loop it hit the governor limit

enter image description here

  • assuming TA is the parent, why aren't you making that the object associated with the Schedule-triggered Flow Start element? -- then SFDC takes care of the batching for you and you will be far less likely to run into governor limits
    – cropredy
    Jan 14 at 20:18

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.