Hi guys!
I'm trying to create an email notification that refreshes and sends every morning and will tell an individual when a safety data sheet (SDS) has expired.
So far this is what I have:
Under filter array, this is what I've input:
The one i arrowed is not supposed to be there 😞
Sorry if this question is dumb, its my first time trying out flow automate!! Thanks for helping in advance!!
Yes! that works as well. Thank you again!!!
Hi @Anonymous
Do you only want to display the date at expiry, not including the time?
If yes, you can change the Select action as below:
Expression:formatDateTime(item()?['SDSExpiryDate'], 'yyyy-MM-dd')
Best Regards
Thank you so much! This solution 100% works! This is how it looks like now:
Thanks again!
Hi @Anonymous
The From value of Create HTML table should be filled with the body of the filter array.
I created a simple Flow, you can refer to as below:
This is my file library:
Flow in details:
Expression:formatDateTime(item()?['SDSExpiryDate'],'yyyy-MM-dd')
Expression:addDays(utcNow(),-1,'yyyy-MM-dd')
After flow runs, I will receive notification as below:
Hope the content above may help you.
Best Regards
If my solution helps, then please consider Accept it as the solution to help the other members find it more quickly.
Michael E. Gernaey
497
Super User 2025 Season 1
David_MA
436
Super User 2025 Season 1
Riyaz_riz11
244
Super User 2025 Season 1