Hi, I was wondering if anyone knew how to create an automated email that is sent to staff when an item is past it's due date. My columns are Description, Cat, Lot, and ExpiryDate. I know power automate may work but I haven't had any success yet and I think the issue may be that there are some cells in the expiry date column that are blank. I can't fill these in unless there is a specific date, is there anyway around this, so it ignores the blank cells? I would be really grateful for any help!
Thank you
Bookmarks