Hi,
I have a SharePoint inventory list that contains 300+ items. How do I go about setting email alert when below min qty that I'm trying to set? Can Power Automate handle this job?
If I do it in PowerBI, I have to do one by one for all 300+ items. Is there an easy way to do it?
SP List:
Product | Inside_Outside | Barcode |
AA | Inside | 11 |
AA | Outside | 22 |
BB | Inside | 33 |
BB | Inside | 44 |
BB | Outside | 55 |
CC | Inside | 66 |
CC | Inside | 66 |
Power BI:
Product | Inside | Outside | Total | Min qty |
AA | 1 | 1 | 2 | 2 |
BB | 2 | 1 | 3 | 4 |
CC | 2 | 0 | 2 | 4 |
Anyone?
User | Count |
---|---|
26 | |
13 | |
12 | |
8 | |
8 |
User | Count |
---|---|
49 | |
29 | |
23 | |
20 | |
20 |