I have a process builder which runs when a record is created/edited. The object has various fields. The process builder runs only when a field named emailid is empty. The immediate action in the process builder is sending an email alert saying the email field is missing.
Problem: when I do a data load of 10,000 records and if all 10,000 record's emailid field is missing. Then the email alert is sent 10,000 times thereby flooding the concerned persons inbox. Is there a way that I can consolidate the records with missing emailid fields and send them in one email alert? IS there any approach?