Inventory Management in Sharepoint

nc1999 this can be mostly automated and the way I would build this is, firstly, to use a form in Microsoft Forms for users to submit an incident report. That submission gets picked up by a flow in Power Automate that saves the details of the report into a separate incident reports list with the details of who used the items, when this happened, what they used and the quantity. That will effectively  provide you with an audit report of all the incidents recorded.

That same flow would update the stock list, reducing the items in stock by the number used.

A second flow would run automatically once a day and check each item in the stock list. If the number in stock for an item had reached the re-order level then send you an email to alert you to re-order the item.

What you couldn't automate is the periodic physical checks on the item or updating the stock levels  when new items are received.

Rob
Los Gallardos
Microsoft Power Automate Community Super User.
Principal Consultant, SharePoint and Power Platform WSP Global (and classic 1967 Morris Traveller driver)