AB-410: Intelligent Applications Builder Associate exam prep

Explore Power Platform licensing options for Power Apps, Power Automate, AI Builder, and CoPilot Studio; compare premium, developer, and per-user plans, and understand credits and environment setup.

Power Platform access requires a work email; discover getting a free Microsoft 365 Business Basic trial, set up, and optional domain-based email as your work address.

Learn to create and manage environments in the Power Platform via the admin center, choosing production, sandbox, standard trial, or developer environments and configuring regions and Dataverse stores.

Navigate the PowerApps interface, create a new solution, and set it as the default solution. Learn to add sample data, move objects, and publish customizations in unmanaged and managed solutions.

Create a model driven app from the accounts Dataverse table, organize views and forms, add Dataverse tables, web resources, dashboards, and generative pages, and publish your customizations.

Create and edit tables in the data workspace using Copilot to model employees and expenses, define one-to-many relationships, and configure lookup columns and properties.

Create and customize standard tables using the new table approach, defining a primary column, advanced properties, and GUID key, then manage ownership and save.

Configure table properties via advanced options such as duplicate detection, track changes, and audit changes. Enable features like mail merge, SharePoint management, and mobile offline.

Add and modify columns in the employee table, including start date and currency, across data types. Configure options like time zone independent, auditing, and column security for model driven apps.

Create a model-driven power app from the employee table, publish and save, and add a new employee like Philip Burton. Anticipate missing columns and plan future enhancements using model-driven apps.

Learn how to compose a model-driven app by modeling data with tables and relationships, defining security, designing forms, views, charts, dashboards, and business processes using power automate in app designer.

Configure a main form for a Dataverse table, add fields and sections, arrange tabs and layouts, review related forms like quick view, quick create, and card forms, then publish.

Configure access to forms by assigning security roles in form settings, selecting the fallback form, and publishing all customizations for the employee and expenses app.

Configure public views by editing, adding, or removing columns, applying sort and filters, and setting security roles; manage public, system, and personal views and publish changes.

Learn to create and configure personal views owned by individuals in a model-driven app, edit columns and filters, save as new or default views, and manage or share visibility.

Learn to create and configure charts in model-driven apps by building salary by level visualizations, exploring column, bar, area, pie, funnel, and donut charts, including stacked and 100% stacked variants.

learn to create and configure a single stream dashboard in model-driven apps, including naming, filtering by a dataverse table, adding charts and streams, and using visual filters and time frames.

Build model-driven app multi-stream dashboards by inserting charts and lists from multiple tables, save and publish, and manage personal and shared dashboards with filters.

Create a generative page in a model-driven app by describing the page and linking up to six dataverse tables, then preview, edit code, and publish.

Configure access to model-driven apps by granting privileges to dataverse tables (at least read), security roles, and environment access. Share the app with users and assign appropriate security roles.

Create an expenses table in the data model with an auto-number expense ID (exp- prefix), a claim date, status options, and currency fields for amount and tax.

Configure table relationships by linking the expense table to the employee table with a one-to-many relationship, adding a lookup column and setting referential behaviors such as cascade and remove link.

Add the expense table to the model-driven app, customize its forms and views with claim date, amount before tax, sales tax, employee lookup, claim status, and description, then publish.

Add an expense subgrid to the employee form using the active expenses view to show the employee's expenses, then publish all customizations and verify the subgrid appears.

Create a calculated column in the expense table to compute the total amount as amount before tax plus sales tax, using a currency data type.

Create a formula column with Power Fx to calculate totals like amount before tax plus sales tax. Learn inserting formulas, handling data types, and using autocomplete and get formula suggestions.

Create and configure a roll-up column in a table to calculate the sum of expenses from related records, filtered by draft status, with currency data type and 12-hour scheduled recalculation.

Configure and enable raw summaries in a model-driven app's environment, select fields such as employee name and start date, and view them via a summary button across main forms.

Configure security on tables by creating custom security roles, assigning them to users and teams, and applying column security profiles to restrict sensitive fields.

Apply business rules in the dataverse to enforce data integrity in model-driven apps. Restrict staff expense approval limits to 800 and validate data before saving to prevent invalid records.

Learn to create and configure a business process floor in model driven apps using dataverse, guiding expenses across five tables with 30 stages and 30 steps each.

Sign in to Power Automate, explore templates, and design flows using connectors like Outlook, OneDrive, Dropbox, Teams, and Excel to automate tasks such as saving attachments, reminders, and notifications.

Explore cloud flow triggers in Power Automate, including automated, scheduled, and instant flows, with manual triggers, input parameters, and connectors, showcased by a weather floor example.

Examine the connectors in Power Automate, including AI Builder, Excel Online, Google Sheets, Microsoft Teams, Mail, OneDrive for Business, SharePoint, Microsoft Dataverse, and SQL Server, with their actions and triggers.

Create a scheduled flow with for each loop and recurrence trigger to pull expenses from a Dataverse table and send a mobile notification, using OAuth, list rows, and string variables.

Test a Power Automate scheduled flow by listing rows from the Dataverse expenses table, initializing a variable, and using a for each loop to build an email text.

Map numeric claim status values to text using a switch control in Power Apps, handling draft, submitted, approved, and rejected with a default fallback.

Explore the condition control in a flow, filtering rows by draft status, using a for-each loop and a true/false condition to append to a string variable.

Explore built-in functions in Power Automate, including string, arrays, logical, conversion, and formatting functions, and learn to create expressions with Copilot by using the fx button.

Create an automated cloud flow named approval that triggers when a Dataverse expense row is submitted, routing to a manager for approval and updating the claim status.

Test the approval flow by saving, publishing, and changing a row to submitted to trigger a Power Automate approval that emails for signoff and approval types, history, and row status.