Well I am missing the part when you created new table Inventory Transaction, what have you add in that table and how it is connected to Inventory Management table. Also how you managed to deal with lowering the Stock when someone ordered item and to check if Points are bellow exp: 5 and then to send the email. Thanks!
So in the demo, we used the Copilot feature which uses Generative AI to create a new table called Inventory Management that has sample data then created an App. After that we created an automation flow that runs automatically. The trigger has an OData filter that checks when the Points are less than 5. If this condition is met, the automation will run and if the points are above 5 the automation will not run. I hope this helps! PowerApps for app creation Power Automate for automations Dataverse for the table