Power Platform Community Forum Thread Details

Hello,

I've a SharePoint list connected to Power Apps. I want to trigger email when 3 fields are edited i.e. Valid Date, Material No. and Verification No.

Initially when a new item is created, send email to self (person creating a new item)

Once the form is saved, the person who created the item, he/she will go to the form within PowerApps and will enter the Valid Date.

After Valid date is entered and the form is saved, send email to Person A.

Person A will receive a notification, where he/she will update Material No.

After Material No. is entered and the form is saved, send email to Person B.

Person B will receive a notification, where he/she will update Verification No. And the flow stops here after verification no. is updated.

Please advise.

Thanks,

Prem

Categories:

Building flows

You can do this, but I would create multiple workflows.

Initially when a new item is created, send email to self (person creating a new item). Simple enough, create a workflow that is triggered when a new item is added to the list and send the e-mail.
Once the form is saved, the person who created the item, he/she will go to the form within PowerApps and will enter the Valid Date. After Valid date is entered and the form is saved, send email to Person A. Create a second workflow that triggers when the item is modified. You will use trigger conditions to prevent the flow from running unless it was modified by the person who created the item, and the valid date is not null. You will need an additional condition to prevent the flow from running again if the created by person modifies it again. These are examples of the trigger conditions, which all must evaluate to true for the flow to trigger:
- @equals(triggerOutputs()?['body/Author/Email'],triggerOutputs()?['body/Editor/Email']): This one checks to see if the request was modified by the person who created it.
- @not(empty(triggerOutputs()?['body/ValidDate'])): checks to make sure the date is populated.
- @equals(triggerOutputs()?['body/ValidDatePopulated'],false): this is the field you will update once the flow triggers and you will update the value to true.
Person A will receive a notification, where he/she will update Material No. I am not sure what this is. Does it get sent when the Valid Date is entered? If so, send the e-mail with the above workflow.
After Material No. is entered and the form is saved, send email to Person B. Create a third workflow, which will have two triggers. One trigger will be when the material number is not empty, and the other one will be a check field that you will update from false to true when the flow runs.
Person B will receive a notification, where he/she will update Verification No. And the flow stops here after verification no. is updated. I assume this occurs when the third flow triggers, so just incorporate this into that flow.

You can use the expression builder to create the conditions. Then just take the expression and in the settings of the trigger, and the trigger conditions with @ before the expression: