powerautomate

Conditions and Switches inside Power Auromate

Use a condition to specify that a cloud flow performs one or more tasks only if a condition is true or false.

The Switch function evaluates a formula and determines whether the result matches any value in a sequence that you specify. If a match is found, a corresponding value is returned. If no match is found, a default value is returned. In either case, the returned value might be a string to show, a formula to evaluate, or another form of result.

If and Switch are very similar, but you should use the best function for your situation:

• Use If to evaluate a single condition. The most common syntax for this function is If( Condition, ThenResult, DefaultResult ), which provides the common “if … then … else …” pattern seen in other programming tools.
• Use If to evaluate multiple unrelated conditions. In Power Apps (unlike Microsoft Excel), you can specify multiple conditions without having to nest If formulas.
• Use Switch to evaluate a single condition against multiple possible matches. You can also use If in this case, but you’d need to repeat the formula for each possible match.

In this Lab

In this lab, you will create a cloud flow using a Power Automate to work with conditions and switch functions.

• Learning objectives- Conditions and Switches
• Duration - 30 minutes
• Scenario - Send an email based on the conditions and switches on when a an item is created or modified in a SharePoint list.
• Prerequisites - Each student must have a dedicated custom SharePoint list named Work Progress Tracker. This list was already created during the basic flow lab.

Task 1

a. Create an automated cloud flow called Conditions Demo and the trigger would be When an item is created or modified (SharePoint list)

b. Configure the SharePoint trigger:

• Site Address: https://edumscloud.sharepoint.com/sites/PowerAutomateDemos
• List Name: Work progress tracker

c. Add a new condition - if Priority Value is equal to High OR Priority Value is equal to Medium.

d. Add a __Send an Email(v2) action for the True and False Branches:

e. Save and Test the flow.

• Modify an item in the Work Progress Tracker SharePoint list.
• Verify the email based on relevant conditions.

Task 2

a. Modify the condition - if Priority Value is equal to High AND Progress Value is equal to Not started.

b. Save and Test the flow.

• Modify an item in the Work Progress Tracker SharePoint list.
• Verify the email based on relevant conditions.

Task 3

a. Modify the condition - if Progress Value is equal to Blocked AND if Priority Value is equal to High OR Priority Value is equal to Medium

b. Save and Test the flow.

• Modify an item in the Work Progress Tracker SharePoint list.
• Verify the email based on relevant conditions.

Task 4

a. Replace the If condition with a Switch statement of the Priority Value

• Case 1 equals High > Send email to yourself with subject Case High
• Case 2 equals Medium > Send email to yourself with subject Case Medium
• Case 3 equals Low > Send email to yourself with subject Case Low
• Case 4 equals Critical > Send email to yourself with subject Case Critical

b. e. Save and Test the flow.

• Modify an item in the Work Progress Tracker SharePoint list.
• Verify the email based on relevant conditions.