Hi,
I would recommend 3 approaches, depending on your requirement.
The main question is, do you want "just" someone to get informed when prices are changed, or do you want to prevent any changes before the change is approved?
If it is sufficient to get informed about price changes:
Approach 1:
- Create (develop) a Business event when a price is changed.
- Create a Power automate (PA) flow that is triggered on the business event. This flow sends then an email to the responsible employee, shared mailbox or Teams chat or channel, to check if it is valid or not.
Approach 2:
Same like approach 1 but with a dataverse connection. Once you establish a dataverse connection in Power Platform admin center, you will have access to virtual entities. Through this approach you can create a PA flow that is being triggered whenever a value in a table is add\changed. There should be a virtual entity that covers the item price already, but I am not sure. It has to be checked. There is no developement requirement in this approach, only configuration. Once you configure everything you are set up for more possibilities in the future, not only for your mentioned case.
There is no release required in this approach compared to creating a business event or to approach 3.
If you want to allow changes only after an approval:
Approach 3:
Extend (develop) the standard workflow engine, so that any changes on a certain field (Price on Item master) requires an approval from one or more people. This is the most restrictive solution. No one will be able to change the price, unless the price change is being approved according to the setup.
There might be also other solutions on this, but these are the ones I am aware of.
Once you give us more information if you need a hard restriction or if an information is sufficient, we can help you further with a proper solution.
Kind regards, Adis
If this helped, please mark it as "Verified" for others facing the same issue
Keep in mind that it is possible to mark more than one answer as verified
