cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
PBala
Helper II
Helper II

SharePoint Status Change Workflow

Hi,

Using a SharePoint list and I have a Status column with following values.

Status = Received, Pending and Completed.

I want email users based on the status.

when a item is created, default status= Received - send email

Change status= Pending -Send email

Change status- Completed -Send email

 

I used the switch step but the issue is , when something else is changed in the list, like comments column, email is sent again. I want email to be sent only when the status column is changed.

Any help is appreciated.

 
 
 

FlowSwitch.PNG

 

Thanks

PBbala

 

1 ACCEPTED SOLUTION

Accepted Solutions
ChristianAbata
Super User II
Super User II

hi @PBala  you need to use trigger conditions to prevent the execution from editing other fields see

 

https://powerusers.microsoft.com/t5/Power-Automate-Community-Blog/Power-Automate-Trigger-Conditions-...



Did I answer your question? Please consider to Mark
my post as a solution! to guide others :winking_face:

Proud to be a Flownaut!


If you want you can follow me at www.christianabata.com Quieres contenido en español? Síguenos en Power Automate LA

View solution in original post

2 REPLIES 2
ChristianAbata
Super User II
Super User II

hi @PBala  you need to use trigger conditions to prevent the execution from editing other fields see

 

https://powerusers.microsoft.com/t5/Power-Automate-Community-Blog/Power-Automate-Trigger-Conditions-...



Did I answer your question? Please consider to Mark
my post as a solution! to guide others :winking_face:

Proud to be a Flownaut!


If you want you can follow me at www.christianabata.com Quieres contenido en español? Síguenos en Power Automate LA

View solution in original post

Thanks for point me in the right direction.

 

I used the below trigger to achieve the result.

 

@or(equals(triggerBody()?['Status']?['value'],'Received'),equals(triggerBody()?['Status']?['value'],'Pending') ,equals(triggerBody()?['Status']?['value'],'Completed'))

 

Thanks

Pbala

Helpful resources

Announcements
Process Advisor

Introducing Process Advisor

Check out the new Process Advisor community forum board!

MPA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

Users online (47,197)