Answered

Using flow in SharePoint list with stock

(1) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hello,

I am looking to use flow to send a email whenever stock hits a certain amount.

We are using PowerApps to order items within the company. It would be great that when a item hits (lets say 100) we get a e-mail there is only 100 items left.

I know there is a SharePoint option within flow that triggers whenever a item is added or modified. Would it be possible to use conditons that whenever a item gets orderd (so the item gets modified in the Sharepoint list, it detracts the amount orderd) Flow checks if its <100 and sends an e-mail?

Thanks in advance!

Categories:

Using flows

I have the same question (0)

All responses (3)

Answers (1)

Sort by

v-monli-msft Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!

Hi @Anonymous,

I think this could be achieve with the "ID" dynamic content from SharePoint list item action. ID increase with the number of items you add to the list.

Regards,

Mona

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hello @v-monli-msft,

I will try this and if it works accept as solution. Thanks for your input!

Was this reply helpful? Yes No
Verified answer

DouglasRomao 224 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Anonymous!

I created an example to show you how you can do this.

Create a SharePoint list named 'Products', with the fields Title, Stock and MinStock (that will be our trigger of the minimum);
Create a SharePoint list name 'Orders', with the fields Title, Product and Quantity;
Create a Microsoft Flow with the trigger 'When a item was created' and put it on the Orders list;
Add the action Get Items, and put it on the Products lists, creating a filter to get just the product that you select in the respective order (The ODATA filter will be ID eq 'The value of the Product Id selected in the order' ;
Set up a variable called 'FinalValue' of float type;
Add a repetition on Get Items;
For each item founded (should be just one), we will compose (calculate) the value of the official stock minus the quantity ordered;
Set this compose value on the FinalValue variable;
Add a condition to see if the FinalValue is less or equal to MinStock of the selected product, if YES, we will send an notification alerting that the minimum stock was reach;

Bellow you can see the images of the flow:

In my example, I created 2 products, and created one order to buy a lot of cars (to see if the minimum stock will reach)

The minimum was reached and a notification was send for me.

Please, check if it helps you and if there is something that I can help, please let me know.

Regards!

Douglas Romão

Was this reply helpful? Yes No