Showing results for 
Search instead for 
Did you mean: 
Helper III
Helper III

Reminder before the exp. date



My sharepoint list is like below.



There are 2 things I want to do.


1-) SKT column means expiration date. I want it to send an e-mail 7 days before the expiration date.


2-) There are lot numbers for the material codes in the titer column. If the Total_Stock total in all lots of a material code is less than the number in Safety_Stock, send a notification mail.


I checked many topics in the forum, I tried, but unfortunately I could not. I will be grateful if you could help me.





hi @grantjenkins 








Are you adding the output from both of those in the Condition? If so, then there shouldn't be an error that one of them is a string (not a number). Can you check the Outputs you used in your Condition?

If I've answered your question, please mark the post as Solved.
If you like my response, please consider giving it a Thumbs Up.

Hi @grantjenkins 

You're great, it's working now. Thank you so much 🙂
Can I make this process automatic every day?
Without the need to change a line.

There was the following request.




Helpful resources

Power Automate News & Announcements

Power Automate News & Announcements

Keep up to date with current events and community announcements in the Power Automate community.

Community Calls Conversations

Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Users online (3,280)