I am trying to learn more about Process Builder along with Visual Workflow.
Currently, I have some apex code that operates in bulk that will query a set of accounts in a trigger to see if a text field City__c is NOT null. If it's not null it will store the id of the account and City__c. It will then query a custom object called Baseball Team and return the id of the Baseball Team based on the name of the city. Once done it will update the account lookup field with the id of baseball team.
How can I move this to Visual Workflow and Process Builder. If certain fields are checked I want this to affect all records. e.g. Dataloading 2000 files.
Currently I have a Custom Button passing in an account id and the city to the flow but this doesn't scale. I want to operate on more than 1 record at a time. Thank you in advance.