cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
abbyamante
Helper I
Helper I

Sharepoint Item List Workflow help/suggestion

Capture.PNGhello

im trying to build a flow that will automatically trigger an email every time the list status has change.

there is 2 department has will update the status on the SP list.

  1.  when the WS status is changed to PENDING trigger an email
  2.  when the WS status is changed to COMPLETE trigger an email
  3. when the FS status is changed to PENDING trigger an email
  4. when the FS status is changed to COMPLETE trigger an email

the problem on the flow that i created is when WS status is currently already set on PENDING then the FS status was changed, its firing an email for for both FS and WS status.

what i would like to happen is it should only fire an email for the recent status change.

 

Any suggestions what conditions or functions to use to fire an email only when the status is change?

thank

 
 
 
 
1 REPLY 1
RaashiSen
Community Support
Community Support

Hello @abbyamante ,

 

If I see the Flow condition correctly, you are using AND function for both WS Status = Pending, complete and FS Status equals Pending, Complete, which will always trigger on both conditions, because it even meets when WS is Complete, but FS is pending, and vice versa.

 

You might want to put condition like-

OR

-> AND
WS Status =Pending
FS Status= Complete
->And
WS Status =Pending
FS Status= Pending

If Yes, 
Send email for WS status

or something along these lines based on your requirement. I also see another condition above this in your screenshot, so not sure if that as well sends an email.

 

let us know if that works for you.

Helpful resources

Announcements
Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

New Ideas Forum MPA.jpg

A new place to submit your Ideas for Power Automate

Announcing a new way to share your feedback with the Power Automate Team.

MPA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

MPA Licensing.jpg

Ask your licensing questions at the Power Automate AMA!

Join Priya Kodukula and the licensing team, super users and MVPs to find answers to your questions on Power Automate licensing.

Users online (2,790)