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