117
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.
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.
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?
When you run the flow can you click on Show raw outputs for both Total Stock and Safety Stock to ensure they are both numbers (not enclosed within double quotes).
I've checked everywhere but it keeps giving the same error.
When I run a test for Flow, it calculates Total Stock and Safety Stock correctly.
Test for product no: 423538
Total stock is: 445 (400+45)
Safety stock is: 480
but it gives an error in the condition part 😞
Values of 0 wont' cause an error.
Are you able to check the internal column names for your Total Stock and Safety Stock and make sure those are the names you're using in your expressions?
Also, just to confirm, you updated both the expressions for Total Stock and Safety Stock (not just pasted the text)?
Columns don't actually have blank lines. I also checked the column types. All of them are number type.
The Total_Stock row has numbers 0. Could it be related to that?
Are some of your Safety Total columns blank (don't have a number)?
In your Filter Query on Get items you should be testing with Titre, not Product No.
And for Total Stock and Safety Stock you need to add those expressions as per the screenshot below (not just pasted into the input as text):
#1
Michael E. Gernaey
497
Super User 2025 Season 1
#2
David_MA
436
Super User 2025 Season 1
#3
Riyaz_riz11
244
Super User 2025 Season 1
Share
Report
All responses (
Answers (
