Avoid duplicate flow emails

[DSCARANELLO]

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

[abm]

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

[DSCARANELLO]

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. 

I really appreciate your help. 

[abm]

Hi @DSCARANELLO 

See below

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

Thanks

[DSCARANELLO]

Hi again, 😞 

It doesn't seen to be working. 

[abm]

Hi @DSCARANELLO 

Try the below

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

Thanks

[DSCARANELLO]

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. 

[abm]

Hi @DSCARANELLO 

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

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

Thanks

[DSCARANELLO]

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]

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]

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 

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

Regards 

[DSCARANELLO]

Can you  help me with a flow that I creating.  

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

error message is :