Need help with Power automate flow - Inventory management using Power Automate

(0) Share

Report

Posted on by SS-11110207-0

I am having trouble setting up a flow in Power Automate. I have an MS Form to track PPE requests for our site, which includes questions like Requestor Name, Requested Date, and PPE Required (with selectable options). I’ve also created an Excel table with headings such as "PPE Required" (listing all PPE items) and "Quantity Required."

I would like to create a flow that automatically reduces the quantity of a selected PPE by 1 each time a request is submitted via the MS Form. Additionally, I want the flow to send a high-priority email when the stock of any PPE drops below 5, prompting a restock order.

For example:

Gloves: 5
Hat: 10

If a request is submitted for gloves, the flow should reduce the stock of gloves by 1, leaving a balance of 4. Since the stock is now below 5, a high-priority email should be sent with a message like, "Order more Gloves."

Categories:

Business Process Flows

I have the same question (0)

All responses (2)

Answers (0)

VictorIvanidze 13,054 on at

Like (0)

Report

Need help with Power automate flow - Inventory management using Power Automate

Could you show your flow?

Was this reply helpful? Yes No
SS-11110207-0 2 on at

Like (0)

Report

Need help with Power automate flow - Inventory management using Power Automate

Was this reply helpful? Yes No