cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
DSCARANELLO
Frequent Visitor

Avoid duplicate flow emails

@abm 

 Hi abm, 

I really hope you can help me out to solve an issue with my flow. I have tried your YouTube suggestion to add an additional column on my list , add a trigger condition and update item. It did work, but then I realised this is not actually what I need. 

 

There are 3 columns on my list that needs to be updated by the manager . 

 

  1. Approved -Yes or No  - The email must be sent IF is either approved or denied . This column can be changed from No to Yes  - Once changed another email must be sent. 
  2. Sap system updated -Yes or No - When this column is modified another email is sent  - I don't want this to happen 
  3. Trapeze system updated  - Yes or No  -When this column is modified another email is sent - I don't want this to happen 
  4. Approved by  - Name of the manager.  - When this column is modified another email is sent - I don't want this to happen 

 

I created a flow When an item is created or modified. 

DSCARANELLO_0-1660298490334.png

DSCARANELLO_1-1660298540787.pngDSCARANELLO_2-1660298575615.png

DSCARANELLO_3-1660298599545.png

 

 

 

 

 

11 REPLIES 11
abm
Super User
Super User

Hi @DSCARANELLO 

 

Looks like you need to set conditional triggers. I have a tutorial video about this.

 

https://www.youtube.com/watch?v=2k8J6MR0z9E&t=397s

 

If you need further help let me know.

 

Thanks



Did I answer your question? Mark my post as a solution!

If you liked my response, please consider giving it a thumbs up


Proud to be a Flownaut!

Learn more from my blog
Power Automate Video Tutorials

Can you help me with this. 

I need to get the peek code for the expression below, but to be honest, which kind of expression should I use? Remember this value (Sap entry)  YES, NO choice -I don't want the email to be sent when this item is modified. 

 

DSCARANELLO_0-1660306176318.png

I really appreciate your help. 

Hi @DSCARANELLO 

 

See below

 

image.png

 

Select Peek code. You may need to use not equal to as the operator.

 

Thanks



Did I answer your question? Mark my post as a solution!

If you liked my response, please consider giving it a thumbs up


Proud to be a Flownaut!

Learn more from my blog
Power Automate Video Tutorials

Hi again, 😞 

It doesn't seen to be working. 

 

DSCARANELLO_0-1660309065117.pngDSCARANELLO_1-1660309185832.png

 

Hi @DSCARANELLO 

 

Try the below

 

@not(or(equals(triggerBody()?['body/SAP Entry'], 'USA'), equals(triggerBody()?['body/SAP Entry'],'Tesla')))

 

Thanks



Did I answer your question? Mark my post as a solution!

If you liked my response, please consider giving it a thumbs up


Proud to be a Flownaut!

Learn more from my blog
Power Automate Video Tutorials

Hi and thank you for you help. 

Still not working, multiples emails are sent when the sap column is updated. I have added the trigger condition you suggested, to no avail. 

DSCARANELLO_0-1660314540612.png

DSCARANELLO_1-1660314630025.png

 

 

 

Hi @DSCARANELLO 

 

You can't use the condition like below to evaluate both values in one.

 

image.png

 

Change the first condition to 'Yes'. Then you need to click the Add button and extend the condition for No. 

 

Thanks



Did I answer your question? Mark my post as a solution!

If you liked my response, please consider giving it a thumbs up


Proud to be a Flownaut!

Learn more from my blog
Power Automate Video Tutorials

Hi, 

I have tried all the options given, unsuccessfully. It would be nice if try to do the same kind of of flow and see the result you get, with the suggestion you sent me. Thanks a million for trying. 

DSCARANELLO
Frequent Visitor

Can someone please help me to sort this out. 

 

  1. Approved -Yes or No  - The email must be sent IF is either approved or denied . This column can be changed from No to Yes  - Once changed another email must be sent. 
  2. Sap system updated -Yes or No - When this column is modified another email is sent  - I don't want this to happen 
  3. Trapeze system updated  - Yes or No  -When this column is modified another email is sent - I don't want this to happen 
  4. Approved by  - Name of the manager.  - When this column is modified another email is sent - I don't want this to happen 

Regards. 

DSCARANELLO
Frequent Visitor

Hi all, 

 

I have managed to find a solution to stop multiples emails been sent when others columns are modified in a sharepoint list. 

 

I have added  the following action after when an item is created 

 

DSCARANELLO_0-1660895323443.png

it works perfectly.. Anyway thank you for trying to help me out. 

Regards 

DSCARANELLO
Frequent Visitor

Can you  help me with a flow that I creating.  

when an item is created, publish app, post a message in chat or channel 

 

DSCARANELLO_0-1660913841766.png

error message is : 

 

DSCARANELLO_1-1660914044582.png

 

Helpful resources

Announcements
Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Difinity Conference 2022

Difinity Conference 2022

Register today for two amazing days of learning, featuring intensive learning sessions across multiple tracks, led by engaging and dynamic experts.

European SharePoint Conference

European SharePoint Conference

The European SharePoint Conference returns live and in-person November 28-December 1 with 4 Microsoft Keynotes, 9 Tutorials, and 120 Sessions.

Top Kudoed Authors
Users online (3,655)