I have a use case that I am trying to solve. Not sure if there is a nice way to do this with a flow and not blow up my SOQL limits.
The org has about 40K contact records. The client would like to have a contact tagged is in our out of their geographic footprint based on the contacts city. There are over 6000 possible city values.
If I create a FootPrint Object would a Flow work to loop through the contact city, compare it to the collection of footprint cities and update a checkbox? Or would my SOQL explode any way I tried to do this? Once the data is set then the flow would only need to run if the field is changed.