Model discount and commercial approvals with a related Dataverse table and controlled access.
Implementation
If standard opportunity fields and auditing do not capture the required review workflow, create a related custom table such as Opportunity Commercial Review. Suggested columns: Opportunity lookup, requested discount, approval status choice, justification, requested by, reviewer, decision date, and comments. Use Power Automate or a custom API for approval transitions where appropriate. Enforce reviewer permissions in Dataverse and retain audit history. Do not treat a canvas-app button’s visibility as an approval control.
Validation checklist
- Confirm table and column names in the target Dataverse environment.
- Check delegation and inspect requests with Power Apps Monitor.
- Test with realistic data and representative security roles.
- Handle empty values, network failures, and duplicate submissions.
- Include all dependencies in the solution before deployment.
