Per our requirement, we need to send an email alert 7 days prior to a date field on the Case object. In the criteria we have built a formula to check the record type and if that date is being changed (Recordtype && ISCHANGED(Datefiled)). In the scheduled action, we added a condition to send an email alert 7 days prior to the same date field. If there are multiple changes on the date field in a way that it is more than 7 days from now and finally we update that date field to a value within 7 days or exactly 7 days from now, system is sending multiple emails.
Eg: If today's date is 3/4/XX and I updated the date field to 3/13/XX, 3/12/XX and finally to 3/11/XX, I'm getting three emails(As there are 3 changes) instead of one.
Is there any way to make it work as expected?