SharePoint Inventory List: How to set email alert when below min qty

[WhatisPowerApps]

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

[WhatisPowerApps]

Anyone?