cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
camertens
New Member

Looking for modified data and then sending an email

I have a simple SharePoint 2010 Workflow that I'm trying to reproduce with PowerAutomate.  Here is the Workflow.

 

camertens_0-1601991143573.png

I can monitor the list for the field to change to "Yes" and send the email and then change the field back "No" but then the flow runs again and sends a 2nd email.  

 

Here is the PowerAutomate Steps I have so far:

camertens_0-1601992367040.png

 

 

I am not a developer by trade so any help is appreciated.

 

1 ACCEPTED SOLUTION

Accepted Solutions

@camertens 

 

This is the reason flow is sending emails again because update action updates your list which flow considered as modified item.

To Over come with this-

1. enable versioning in SharePoint List

2. Create a multitext column-'StopRun' with plain text and append setting.

Hardesh15_0-1601992776495.png

 

3. Go to your Trigger setting and add following  Trigger condition- (@equals(triggerBody()?['StopRun'],null))

 

Hardesh15_1-1601992842374.png

 

4. in Update Action- See column name StopRun and add this text-NoRun

Hardesh15_2-1601992904073.png

 

try this it will work.

 

Thanks

Hardesh

 

 

 

View solution in original post

3 REPLIES 3
Hardesh15
Super User II
Super User II

@camertens 

 

are you using 'When item is created or modified' trigger with update Action? Pls share your flow screens.

 

Thanks

Hardesh

@Hardesh15 I've edited the original post to add a screenshot of the Flow I have thus far.

 

and yes, I'm using the "When item is created or modified"

@camertens 

 

This is the reason flow is sending emails again because update action updates your list which flow considered as modified item.

To Over come with this-

1. enable versioning in SharePoint List

2. Create a multitext column-'StopRun' with plain text and append setting.

Hardesh15_0-1601992776495.png

 

3. Go to your Trigger setting and add following  Trigger condition- (@equals(triggerBody()?['StopRun'],null))

 

Hardesh15_1-1601992842374.png

 

4. in Update Action- See column name StopRun and add this text-NoRun

Hardesh15_2-1601992904073.png

 

try this it will work.

 

Thanks

Hardesh

 

 

 

View solution in original post

Helpful resources

Announcements
MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

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

secondImage

Are Your Ready?

Test your skills now with the Cloud Skill Challenge.

Top Solution Authors
Users online (49,434)