Build an Opportunity Approval and Discount Review Log in Dataverse: Series 9

Build an Opportunity Approval and Discount Review Log in Dataverse: Series 9

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.