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
Super User

@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

 

 

 

Helpful resources

Announcements
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.

Microsoft Build 768x460.png

Microsoft Build is May 24-26. Have you registered yet?

Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.

May UG Leader Call Carousel 768x460.png

What difference can a User Group make for you?

At the monthly call, connect with other leaders and find out how community makes your experience even better.

PA Survey Carousel Image.png

We want to hear from you!

If you are a small business ISV/Reseller, share your thoughts with our research team.

Users online (1,271)