Implement business and process logic
Unlock the complete study guide.
Bundled into the existing Building Intelligent Applications premium course — no separate purchase.
14-day refund guarantee on one-time purchases and your first subscription charge.
Included in this chapter:
- Business logic in Microsoft Dataverse
- Business rules: conditions, actions, and scope
- Choosing the right business rule action
- Business rule lifecycle and troubleshooting
- Business process flows: stages, steps, and stage-gating
- How far a business process flow can reach
- Branching a business process flow
- Running automation from a process
- Activating, ordering, and securing process flows
- Calculated columns
- Formula columns
- Rollup columns
- Dataverse functions
- Automated low-code plug-ins
- Evaluating business logic use cases
- Business logic requirements matched to tools
Calculated, formula, and rollup columns compared
| Decision point | Calculated column | Formula column | Rollup column |
|---|---|---|---|
| What it computes | One row's value from the row or a related parent | One row's value from a Power Fx expression | SUM, COUNT, MIN, MAX, or AVG over related rows |
| How you define it | Condition and Action sections with built-in functions such as ADDDAYS | A Power Fx formula; the formula sets the result type | Source table, related table, filters, and aggregation |
| Null numeric input | Propagates null (null + 2 + 3 = null) | Treated as 0 (0 + 2 + 3 = 5) | Not part of this comparison: a rollup aggregates related rows instead of combining values within one row |
| Chain limit | Up to 5 chained calculated columns, no cycles | Depth up to 10, 1,000-character formula, no cycles | Cannot roll up another rollup column |
| Currency result | Supported | Not supported; convert currency inputs with Decimal() | Supported |
| Freshness | Available to forms, views, and charts in real time | Calculated when the row is retrieved (a fetch operation) | Refreshed asynchronously by system jobs or a manual Recalculate |
| Offline behavior | Not displayed in Outlook Client Offline mode tile views or main forms | Not displayed in mobile offline mode | Manual Recalculate works only online |
| Can start a workflow | No (nor a plug-in) | No (nor a plug-in) | No, and it cannot be used in a workflow wait condition |
Decision tree
Cheat sheet
Unlock with Premium — includes all practice exams and the complete study guide.
References
- https://learn.microsoft.com/en-us/power-apps/maker/data-platform/processes
- https://learn.microsoft.com/en-us/credentials/certifications/resources/study-guides/ab-410
- https://learn.microsoft.com/en-us/power-apps/maker/data-platform/data-platform-create-business-rule
- https://learn.microsoft.com/en-us/power-apps/maker/data-platform/low-code-plug-ins
- https://learn.microsoft.com/en-us/power-apps/maker/model-driven-apps/create-business-rules-recommendations-apply-logic-form
- https://learn.microsoft.com/en-us/power-apps/developer/data-platform/reference/entities/workflow
- https://learn.microsoft.com/en-us/power-automate/business-process-flows-overview
- https://learn.microsoft.com/en-us/power-automate/create-business-process-flow
- https://learn.microsoft.com/en-us/power-automate/enhance-business-process-flows-branching
- https://learn.microsoft.com/en-us/power-automate/overview-cloud
- https://learn.microsoft.com/en-us/power-automate/overview-solution-flows
- https://learn.microsoft.com/en-us/power-automate/create-instant-flows
- https://learn.microsoft.com/en-us/power-apps/maker/data-platform/define-calculated-fields
- https://learn.microsoft.com/en-us/azure/logic-apps/expression-functions-reference
- https://learn.microsoft.com/en-us/power-apps/maker/data-platform/formula-columns
- https://learn.microsoft.com/en-us/power-apps/maker/data-platform/define-rollup-fields
- https://learn.microsoft.com/en-us/power-apps/maker/data-platform/functions-overview
- https://learn.microsoft.com/en-us/power-apps/maker/data-platform/functions-invoke
- https://learn.microsoft.com/en-us/ai-builder/powerfx-in-powerapps
- https://learn.microsoft.com/en-us/ai-builder/use-a-custom-prompt-in-flow
- https://learn.microsoft.com/en-us/power-automate/guidance/coding-guidelines/integrating-cloud-flows-power-apps