Practice Lab 7 – Trigger filters

In this lab you will filter on an update trigger.

What you will learn

Navigate to the Power Apps Maker portal https://make.powerapps.com
Make sure you are in the Dev One environment.
In the left navigation pane, select Tables.
Select Opportunity.
Under Schema, select Columns.
Select the Status column.
Expand Advanced options.
Copy the Logical name for use in the flow.

Note: The prefix for your Status column may be different.

Select the When a row is added, modified, or deleted step.
Select the When a row is added, modified, or deleted step name and enter Opportunity changed
Select Modified for Change Type.
Select Opportunities for Table Name.
Select Organization for Scope.

Select the + icon under the trigger step and select Add an action.
Enter email in search.
Select Send an email (V2) under Office 365 Outlook.
Select Send an email (V2) step name and enter Notify by email
Select To field and select Enter custom value.
Enter your tenant user id for To.
Select Subject field and enter Opportunity closed
Select Body field and select the Dynamic content icon.
Select Opportunity Subject from Opportunity changed.
Select Body field and select the Dynamic content icon and select See more.
Select Status from Opportunity changed.

Select the Opportunity changed trigger step.
Select Show all
Select the Select Columns field and enter the Logical name from the previous exercise, for example: cr977_status

Note: The prefix for your status column will be different.

Select the Opportunity changed step.
Select Show all
Select the Filter Rows field and enter cr977_status eq 3 using the Logical name from the previous exercise.

Note: The prefix for your status column will be different.
Select Save.
Select the <- Back button from the top left of the command bar.