Automatically send an email when an item is passed its due date, but ignore blank cells

[brodiej]

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 or do not fit the date format. 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! I would like the email to be sent out automatically every day at 9am (GMT) and I want the email to contain the Chemical Name Description, Cat No, Lot No, and ExpiryRetest Date. I want the email to be sent when the expiry date is reached, however, just ignore the cells that do not contain a date. I can't make up a date so need to keep these blank or with other information in them.

Thank you

Chem Inventory Test.xlsx
	A	B	C	D	E	F	G	H	I	J	K	L
9	Item No.	Location Within Room	ChemicalNameDescription	Company	Cat	Lot	Container Type	No. of containers	Container size(g,µl,ml,kg,l)	Physical State	Expiry	Container empty?
10	1	Chemical Bay	Chemical 1	Comp 1	Cat 1	Lot 1	Plastic	1	1	Powder	11/1/25	No
11	2	Chemical Bay	Chemical 2	Comp 2	Cat 2	Lot 2	Plastic	1	1	Powder	Retest 2025	No
12	3	Chemical Bay	Chemical 3	Comp 3	Cat 3	Lot 3	Plastic	1	1	Liquid	NA	No
Test

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
L10:L903	Cell Value	contains "Yes"	text	NO
K10:K544	Expression	=$K10<TODAY()	text	NO

Cells with Data Validation
Cell	Allow	Criteria
L10:L12	List	Yes, No
J10:J12	List	Solid, Liquid, Gas, Powder, Mixed
G10:G12	List	Plastic, Glass, Cardboard, Metal