Module 5: Power Apps Formulas & Business Logic (Beginner Guide)

 

Module 5: Power Apps Formulas & Business Logic (Beginner Guide)

📑 Table of Contents

1. What Are Formulas in Power Apps?

2. Why Business Logic Is Important

3. Understanding the Formula Bar

4. Basic Power Apps Functions

5. If Condition Explained Simply

6. Using Navigate Function

7. Using SubmitForm and ResetForm

8. Patch Function Explained with Example

9. Working with Variables

10. Validation Logic in Forms

11. Show and Hide Controls

12. Real Example: Leave Request Logic

13. Common Beginner Mistakes

14. Best Practices for Writing Formulas

---

1️⃣ What Are Formulas in Power Apps?

Formulas are used to control how your app works.
They tell Power Apps what to do when a user clicks, types, or selects something.

Power Apps formulas look similar to Excel formulas.
That makes them easy for beginners.

Examples of what formulas can do:

• Navigate to another screen

• Save data to SharePoint

• Show or hide controls

• Validate user input

Without formulas, an app is only a design.
With formulas, it becomes a working application.

---

2️⃣ Why Business Logic Is Important

Business logic means rules.

Rules decide:

• When data can be saved

• Who can see what

• What happens after submit

Example:

• If leave days > 5 → Manager approval needed

• If field is empty → Show error

Business logic makes apps smart and safe.
It prevents wrong data entry.

Real companies always expect logic in apps.

---

3️⃣ Understanding the Formula Bar

The formula bar is at the top of Power Apps Studio.

It is used to:

• Write formulas

• Edit logic

• Set control behavior

When you select a control, you can choose a property:

• OnSelect

• Text

• Visible

• DisplayMode

Each property can have a formula.

Example:
Button.OnSelect → Navigate(Screen2)

This is where most logic is written.

---

4️⃣ Basic Power Apps Functions

Every beginner must know these functions:

• Navigate()

• SubmitForm()

• ResetForm()

• If()

• Set()

• Patch()

These functions are used in almost all apps.

You do not need to memorize all functions.
Understand how they work with examples.

---

5️⃣ IF Condition Explained Simply

The If function is used for conditions.

Simple meaning:
If something is true → do this
Else → do something else

Example:

If(TextInput1.Text = "", Notify("Enter name"))

This means:
If name is empty, show message.

Another example:

If(Dropdown1.Value = "HR", Navigate(HRScreen))

If conditions are used in:

• Validation

• Navigation

• Visibility

This is the most important function to learn.

---

6️⃣ Using Navigate Function

Navigate is used to move between screens.

Example:

Navigate(Screen2, ScreenTransition.Fade)

Used when:

• Button is clicked

• Icon is selected

Best practice:

• One main flow

• No confusion

Good navigation improves user experience.

---

7️⃣ Using SubmitForm and ResetForm

SubmitForm()

Used to save data.

Example:

SubmitForm(Form1)

ResetForm()

Used to clear form fields.

Example:

ResetForm(Form1)

Common usage:

• Submit button → SubmitForm

• Cancel button → ResetForm

Forms + these two functions = easy data handling.

---

8️⃣ Patch Function Explained with Example

Patch is used to create or update data manually.

It is more powerful than forms.

Simple example:

Patch(EmployeeList, Defaults(EmployeeList),
{
 Name: TextInput1.Text,
 Department: Dropdown1.Value
})

Patch is used when:

• Custom logic needed

• Multiple data sources

• Advanced scenarios

Beginners should first learn forms, then Patch.

---

9️⃣ Working with Variables

Variables store values temporarily.

Set() – Global variable

Set(varUserName, "Manoj")

UpdateContext() – Screen variable

UpdateContext({showPopup: true})

Variables are used for:

• Popups

• User data

• Temporary values

They make logic clean and readable.

---

🔟 Validation Logic in Forms

Validation ensures correct data.

Example:

If(IsBlank(TextInput1.Text),
 Notify("Please enter name"),
 SubmitForm(Form1)
)

Validation prevents:

• Empty fields

• Wrong entries

Always validate important fields.

---

1️⃣1️⃣ Show and Hide Controls

Controls can be shown or hidden.

Use Visible property.

Example:

If(varIsAdmin, true, false)

Real example:
Show approval button only to managers.

This improves security and UX.

---

1️⃣2️⃣ Real Example: Leave Request Logic

Logic flow:

• User fills form

• Clicks submit

• Validation checks fields

• If days > 3 → approval required

• Else → auto approve

This logic makes app business-ready.

---

1️⃣3️⃣ Common Beginner Mistakes

Avoid:

• Writing logic everywhere

• Long formulas

• No validation

• No comments

Keep logic simple.

---

1️⃣4️⃣ Best Practices for Writing Formulas

Best practices:

• Use clear variable names

• Break logic into steps

• Test often

• Keep formulas readable

Clean logic = easy maintenance.