Cert EspressoLearn. Practise. Find your flow.

A LITTLE FOCUS.
A BIG NEXT STEP.

Your pace. Your space.
Microsoft · AB-410

Calculated, rollup, and formula columns

AB-410 · Lesson 17 of 17 · 2:03:36

YouTube loads only after you press play. This chapter opens at its timestamp in the full course. Watch on YouTube ↗

In this lesson

Prepare for the AB-410 exam (Building Intelligent Applications). In this lesson: Power Fx formula columns, classic calculated columns, rollup columns and their background jobs, and how to choose between business rules, columns, cloud flows, plug-ins, and app formulas for each piece of business logic. Includes three original practice questions.

Preview the topics
  • Contoso wants each building to show the number of its open work orders, and a delay of up to an hour is acceptable. Which column fits?
  • When a work order is completed, Contoso must email the building’s manager and update a supplier’s system, and a short delay is fine. Where does this logic belong?
  • Saving a work order must fail, in the same transaction, when its parts exceed the stock, whichever app or integration saves it, with complex logic. What should Contoso use?