Skip to main content

Notifications

Power Automate - Building Flows
Suggested answer

Send an email when an Item is created or edited

(0) ShareShare
ReportReport
Posted on by 289
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
  • Suggested answer
    David_MA Profile Picture
    David_MA 9,039 on at
    Send an email when an Item is created or edited
    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:
     
    This is a good blog post with more information on trigger conditions: A simple way to create a trigger condition in Power Automate

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,636

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,942

Leaderboard