Skip to main content

Notifications

Announcements

Welcome to the Power Platform Communities
News and Announcements icon
Power Platform Community / Forums / Building Flows / Power Automate & Share...
Building Flows
Unanswered

Power Automate & SharePoint 365 - Isolating Automatic Emails

(1) ShareShare
ReportReport
Posted on by Kchesshir 4
Hello,
I would appreciate any help I can get from the experts on this board!!!!
 
I'm trying to build a basic flow for purchase order requests based in SharePoint 365.  I'm trying to keep it fairly simple, but would like automatic email capabilities.   I can get separate emails sent based on what dropdowns are selected and saved (from columns "DeliveryStatus" and "ApprovalStatus".  However, my issue is that when I go into an entry and change other fields ("Vender, Request Description, etc.") and save it, it still sends the email for the "DeliveryStatus", "ApprovalStatus".
 
 
 
 
First Iteration....Separate emails are sent based on what is selected via the dropdowns.  However, changing other fields and saving causes the current unchanged "DeliveryStatus" value to be emailed.  
 
 
 
 
 
My attempt at trying to isolate any emails being sent to the ApprovalStatus ONLY if it is changed from its current status.
 
 
Thanks!
 
Categories:
Business Process Flows
  • Suggested answer
    FLMike Profile Picture
    FLMike 23,361 on at
    Power Automate & SharePoint 365 - Isolating Automatic Emails
    Hi
     
    I kept trying to post this last night.
     
    You have 2 issues.
     
    1. You are checking the Has Changes, but you aren't doing anything with the results, so your flow will just keep going
     
    2. You should add a Trigger Condition that only triggers if one of those 2 columns are changed, this way you don't even trigger.
     
    Here is a great example
     
    If this helped please Mark as the Answer, and also a like please.
  • Nived_Nambiar Profile Picture
    Nived_Nambiar 15,886 on at
    Power Automate & SharePoint 365 - Isolating Automatic Emails
    Hi,
     
    if i am right- you need a flow which sends an email only when approval status column value changed from current value - correct ?
     
     

Helpful resources

News and Announcements

Welcome to the Power Platform Communities

Quick Links

Welcome to the Power Platform…

We are thrilled to unveil the newly-launched Power Platform Communities!…

Community Update Sept 16…

Power Platform Community Update…

Welcome to the new Power Platform Community!…

We are excited to announce our new Copilot Cookbook Gallery in the Community…

more Community News

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 140,745

#2
RandyHayes Profile Picture

RandyHayes 76,308

#3
Pstork1 Profile Picture

Pstork1 63,355

Leaderboard

Featured topics

Product updates

Microsoft Power Platform Community release plans