Domain 3 of 3 · Chapter 3 of 3

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 pointCalculated columnFormula columnRollup column
What it computesOne row's value from the row or a related parentOne row's value from a Power Fx expressionSUM, COUNT, MIN, MAX, or AVG over related rows
How you define itCondition and Action sections with built-in functions such as ADDDAYSA Power Fx formula; the formula sets the result typeSource table, related table, filters, and aggregation
Null numeric inputPropagates 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 limitUp to 5 chained calculated columns, no cyclesDepth up to 10, 1,000-character formula, no cyclesCannot roll up another rollup column
Currency resultSupportedNot supported; convert currency inputs with Decimal()Supported
FreshnessAvailable to forms, views, and charts in real timeCalculated when the row is retrieved (a fetch operation)Refreshed asynchronously by system jobs or a manual Recalculate
Offline behaviorNot displayed in Outlook Client Offline mode tile views or main formsNot displayed in mobile offline modeManual Recalculate works only online
Can start a workflowNo (nor a plug-in)No (nor a plug-in)No, and it cannot be used in a workflow wait condition

Decision tree

Guide people throughordered stages?YesBusinessprocess flowNoDerive a columnvalue?YesCalculated,formula, orrollup columnNoReact to data entry on amodel-driven form or withEntity (table-wide) scope, noother-table reads or rollback?YesBusiness ruleNoEnforce for every writerwith other-table readsor rollback?YesAutomatedlow-codeplug-inNoReusable operationapps and flows call?YesDataversefunctionNoLonger-running,multi-connectorsequence?YesCloud flowNoPower Fx in the app

Cheat sheet

  • A specific form scope limits a business rule to that form
  • Canvas apps use table-scoped rules without model-driven UI actions
  • Business rules implement conditional validation and value changes
  • Active business rules must be deactivated before editing
  • Form rules need their referenced columns on the form
  • Business rules exclude some column types
  • Unified Interface rules should reference component columns
  • Editable subgrids do not support business rules
  • A business-rule recommendation waits for the user's acceptance
  • Set Default Value initializes only an empty column
  • Set Business Required changes a column's form requirement conditionally
  • Business process flows guide users through stages
  • Required steps gate movement to the next stage
  • A required Yes/No process step must be Yes
  • Saved process drafts are unavailable until activated
  • Process order selects the first eligible default
  • Switching processes preserves each instance's state
  • Process definitions have table, stage, and step limits
  • Offline process use requires a single-table process
  • Business process instances require privileges on their own process table
  • A custom table must be enabled for business process flows before participating
  • Enabling business process flows on a custom table cannot be undone
  • Branching conditions use steps from the preceding stage
  • One branching rule cannot mix AND and OR
  • Peer branches must converge consistently or end
  • Visible branch structure can disclose sensitive process information
  • Stage relationships enable reuse of related rows
  • Flow Steps run instant cloud flows from inside stages
  • Action Steps invoke actions or on-demand workflows
  • Stage and global workflows respond to different process events
  • A successful Flow Step needs its process log updated to record completion
  • Flow Step status display requires read access to System Jobs
  • Column values set by business rules or form scripts also appear in the process control
  • Hiding a form column also hides it in the business process flow control
  • Data entered through process steps also updates form columns
  • Calculated columns derive values from the current row and its parent
  • Parent references require a supported table-specific lookup
  • Calculated output may require protection independently of its inputs
  • Calculated chains are bounded and cannot be cyclic
  • Certain calculated dependencies disable sorting
  • Calculated-column DIFF functions require matching date behaviors
  • Calculated-column ADDDAYS takes the day count before the date
  • Calculated columns cannot trigger workflows or plug-ins
  • Calculated columns do not trigger duplicate detection rules
  • An existing simple column cannot be converted into a calculated column
  • Rollups aggregate qualifying related records
  • Rollup refresh is asynchronous
  • Manual recalculation requires source-row write access
  • Manual rollup limits differ from background calculation limits
  • Accessory columns expose rollup freshness and errors
  • Rollups follow configured relationships rather than every associated-grid row
  • Rollups calculate in system context rather than per viewer
  • Rollup precision is applied before aggregation
  • A rollup cannot aggregate another rollup column
  • A rollup cannot reference a calculated column that depends on another calculated column
  • Updating a rollup value cannot trigger a workflow
  • A workflow wait condition cannot use a rollup column
  • Formula input support depends on column format as well as type
  • Formula ranges constrain intermediate calculations rather than offering editable field limits
  • A formula expression determines its column's result type
  • Formula arithmetic treats numeric nulls differently from calculated arithmetic
  • Formula columns convert supported currency inputs but cannot return Currency
  • Numeric text conversion requires an explicit supported format
  • Formula date calculations must respect date behavior compatibility
  • Formula dependencies are bounded and cannot be circular
  • Only suitable simple formulas can feed rollups
  • Formula columns have offline, sorting, and trigger restrictions
  • Dataverse functions centralize parameterized server operations
  • Functions access data in the invoking user's context
  • Apps invoke Dataverse functions through Environment
  • Existing apps need refreshed Environment metadata for new functions
  • Cloud flows invoke functions with Perform an unbound action
  • Responsive app logic and longer-running orchestration favor different execution surfaces
  • Transaction-bound Dataverse Power Fx logic keeps related database changes atomic
  • Power Fx server logic can return an Error to the invoking app or flow
  • An automated low-code plug-in selects a data event on its associated table
  • The automated plug-in stage determines whether logic precedes or follows the data change
  • Low-code plug-in expressions access Dataverse tables with native Power Fx functions
  • Low-code plug-in connector calls use the connection reference's internal name
  • Dataverse function tracing requires plug-in trace logging

Unlock with Premium — includes all practice exams and the complete study guide.

References

  1. https://learn.microsoft.com/en-us/power-apps/maker/data-platform/processes
  2. https://learn.microsoft.com/en-us/credentials/certifications/resources/study-guides/ab-410
  3. https://learn.microsoft.com/en-us/power-apps/maker/data-platform/data-platform-create-business-rule
  4. https://learn.microsoft.com/en-us/power-apps/maker/data-platform/low-code-plug-ins
  5. https://learn.microsoft.com/en-us/power-apps/maker/model-driven-apps/create-business-rules-recommendations-apply-logic-form
  6. https://learn.microsoft.com/en-us/power-apps/developer/data-platform/reference/entities/workflow
  7. https://learn.microsoft.com/en-us/power-automate/business-process-flows-overview
  8. https://learn.microsoft.com/en-us/power-automate/create-business-process-flow
  9. https://learn.microsoft.com/en-us/power-automate/enhance-business-process-flows-branching
  10. https://learn.microsoft.com/en-us/power-automate/overview-cloud
  11. https://learn.microsoft.com/en-us/power-automate/overview-solution-flows
  12. https://learn.microsoft.com/en-us/power-automate/create-instant-flows
  13. https://learn.microsoft.com/en-us/power-apps/maker/data-platform/define-calculated-fields
  14. https://learn.microsoft.com/en-us/azure/logic-apps/expression-functions-reference
  15. https://learn.microsoft.com/en-us/power-apps/maker/data-platform/formula-columns
  16. https://learn.microsoft.com/en-us/power-apps/maker/data-platform/define-rollup-fields
  17. https://learn.microsoft.com/en-us/power-apps/maker/data-platform/functions-overview
  18. https://learn.microsoft.com/en-us/power-apps/maker/data-platform/functions-invoke
  19. https://learn.microsoft.com/en-us/ai-builder/powerfx-in-powerapps
  20. https://learn.microsoft.com/en-us/ai-builder/use-a-custom-prompt-in-flow
  21. https://learn.microsoft.com/en-us/power-automate/guidance/coding-guidelines/integrating-cloud-flows-power-apps