cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
stars75238
Level: Powered On

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

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

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

stars75238
Level: Powered On

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

Super User
Super User

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!


stars75238
Level: Powered On

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

Incoming: New and improved badges!

Look out for new contribution recognition badges coming SOON!

firstImage

Power Platform Online Conference

Join us for the first ever Power Platform Online Conference!

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!

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

sixthImage

Power Platform World Tour

Find out where you can attend!

seventhimage

Webinars & Video Gallery

Watch & learn from the Power Automate Community Video Gallery!

Users online (4,412)