Hi all,
I have spent further hours trying to figure out what seems like such a fundamental piece of functionality in Model Driven Apps (using Dataverse) but am still no further forward - can anyone help?
Scenario: In a Model Driven App, a user completes a Product Order form - which is based on (saves to) a table named 'EquipmentOrders'. In that form, they specify the Quantity of the product they want to order. The available Quantity is sourced from a table named 'EquipmentQuantities'.
On submission of the Product Order Form, the corresponding Quantity in the EquipmentQuantities table should be reduced in accordance with the Quantity the customer specified on the Product Order form.
In a Canvas App this would be extremely straightforward via PowerFX. Surely this process is achievable via Model Driven, but how? In the methods I've tried so far, Business Rules can only be applied to a single table (entity) so don't seem to be relational. My separate thread on trying to do this via a Flow (Power Automate) didn't get any replies - can Flow in fact be used?
Any help on this would be very much appreciated, thank you very much!
