Reminder before the exp. date

[koray1]

Hello,

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.

Regards.

[koray1]

hi @grantjenkins 

Sure.

[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?

[koray1]

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.