I have this custom list that acts as an inventory database(lookup column)enter image description here

I have this custom list to create requests of items from the image above

enter image description here

The inventory database should automatically update whenever a request is filed. For example, After filing for 10 A4 Bond Paper, it should automatically change the quantity of my inventory database to 4990.

How can I make this happen?


I've come up with this workflowworkflow but I thinks it wouldn't be a good practice since for example I have 500 items in my inventory, that would let me do 500 if-else's and everytime I will add new item, I will have to edit my workflow.

Thanks everyone!

1 Answer 1


You have this correctly, created two lists where you have one with Total Amount and second with Requests.

On Requests list create simply SharePoint workflow, where you will find item in List Inventory by filter Name = CurrentItem:Item1 (LookUpField) and after this do calculation Quantity = Quantity-1

  • thank you for your response, see edit for clarifications
    – NoobPro
    Commented Jan 21, 2019 at 5:21

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.