Country or region and language

    Choose your country or region and your language.

    Suggested for you

      All countries and regions

        Choose your character

        It shows in the top bar and on your profile. Change it any time.

        Power Fx formulas and quick reference

        A formula belongs to a property. Check its type and result, then change the input that should make it recalculate.

        Checked 15 November 2026

        A repair-request example

        The fictional Finch Loom team stores request IDs, priorities and estimated hours. Two requests can have the same title, so a title alone doesn’t identify a saved record. These examples use US formula punctuation and original data names.

        Property or task Formula Result to inspect
        Label text "Request " & Text(Gallery1.Selected.ID) The selected request ID
        Open requests Filter(Requests, Status = "Open") A table of matching requests
        One identified request LookUp(Requests, ID = 42) One record, or blank
        Missing owner Coalesce(Gallery1.Selected.Owner, "Unassigned") A display fallback
        Numeric input Value(HoursInput.Text) * 2 A number, or a conversion error

        A display fallback doesn’t fill the source’s Owner column. Likewise, a number displayed as text doesn’t change the column’s type. Record the expected value before changing a formula; otherwise a plausible label can distract you from the wrong row.

        Property and behavior formulas

        A label’s Text property describes its current value. A button’s OnSelect describes an action. Keep data writes in the intended behavior and verify that a later input change updates the displayed calculation without repeating an earlier write.

        In the local workspace, practice Set, collections and supported behavior functions only where the lesson exposes them. A collection is an in-memory table. Its contents don’t establish that every row from a remote source was loaded.

        Function names stay English. Decimal-comma authoring uses different argument and chaining separators; the Microsoft localization reference explains those rules. A dot in Gallery1.Selected remains a property-access dot.

        Checks and limits

        Change the selected ID, enter a blank owner and try an invalid numeric input. Inspect a record that shares its title with another request. Each test probes a different assumption.

        The course uses the official interpreter for its supported formulas and local models for canvas controls and data operations. It doesn’t implement the whole platform. Continue with gallery filters, forms and Patch or the Power Apps course.

        Sources

        Your Work Gym account

        Save your progress and pick up on another device. Your browser's progress comes with you.

        or

        You can keep practicing without an account.

        Help and feedback

        Ask a question, tell us what is not working, or share an idea. We reply by email.

        What is it about?

        We use it only to reply to you.