I need to create an auto-generated email when date in the one of columns in the list matched today's date.
1 Answer
If you are on SharePoint online it is now a OOTB Flow. Another option could be a timer job in Azure that checks the dates in the list against today.
If you are using on premises a scheduled timer job (C# or PowerShell) could be an option
In both cases you can use either CAML or Search to locate the items where the date field matches today (be careful about the timezone issue)