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

Modified Approval repeats

I have an approval email sent when a file is modified, not an issue with that, the problem starts after the file is approved.  When I click approve and it updates the SharePoint List field I get another modified approval email.  So when I approve the file, SharePoint is detecting the change and sending another email.  This only happens once because, on the second email, nothing is changed.

 

Any help to prevent this second email from being sent?  Also, I tried the approval email templates, however, I have to look deeper to see what field is updated so that I can trigger views from the change, any help there would be appreciated as well.

 

Michael

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Power Participant
Power Participant

Re: Modified Approval repeats

If i undestood correctily.

 

I recommend you to create a column in SP like 'EmailSent' and update them in first approval, after this you can use a condition in MS Flow to send email only if not yet sent


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

Gustavo Moraes, o astronauta brasileiro do Flow!


View solution in original post

4 REPLIES 4
Highlighted
Power Participant
Power Participant

Re: Modified Approval repeats

If i undestood correctily.

 

I recommend you to create a column in SP like 'EmailSent' and update them in first approval, after this you can use a condition in MS Flow to send email only if not yet sent


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

Gustavo Moraes, o astronauta brasileiro do Flow!


View solution in original post

Highlighted
New Member

Re: Modified Approval repeats

I will try that tonight when I log into the office, that makes sense and I will read up on using conditions.  If I do set that 'EmailSent' flag, that would mean the next time I update I just need to change that either to remove it/clear it.  With that, I wonder if there is a way to clear the email sent field when I post an update, in the entire email approval process.  I had a long explanation all typed out and then saw the error before I posted.  I will try this tonight and report back the results, thank you for the help.

 

On another note do you know if Flow can use Choice fields for updates yet or is it best to just use a Single Line text field for my 'EmailSent' flag?

 

Michael

Highlighted
Power Participant
Power Participant

Re: Modified Approval repeats

Hi Michael, flow accept choice field and 'yes or no'. I think if you need only two options 'yes or no' column is the beat choice

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

Gustavo Moraes, o astronauta brasileiro do Flow!


Highlighted
New Member

Re: Modified Approval repeats

I agree, if I use a Choice field it does not show up in Flow as a field I can assign information to, using a yes/no field helps.

 

I tried the conditional statement and that is keeping me from getting the second set of emails, thank you for that.

Helpful resources

Announcements
firstImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

firstImage

Join the new Power Virtual Agents Community!

We are excited to announce the launch of Power Virtual Agents Community. Check it out now!

firstImage

New & Improved Power Automate Community Cookbook

We've updated and improved the layout and uploading format of the Power Automate Cookbook!

thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

Users online (9,483)