Hi everyone.
I want to check (once a week) if the quantity in column A is less than column B from the same SharePoint list.
For example:
Column A is the number of products in stock. (QTY = 30)
Column B is the safety stock. (QTY = 5)
If the column A is less than 5, it will be gotten to the list.
Then, it will be sent by email to be ordered.
Now, I can't get items from the SharePoint list.
If anyone knows, please suggest me.
Many thanks.