Skip Ribbon Commands
Skip to main content

Quick Launch

Todd Klindt's home page > Todd Klindt's Office 365 Admin Blog > Posts > Workflow to automatically approve my comments
December 23
Workflow to automatically approve my comments

As you can imagine, a top-notch web site like mine gets a lot of traffic. Sometimes those people leave me comments. Usually to tell me I’ve typoed the name of a Netcast, or that I’m flat out wrong about something. The important thing is that they care enough to leave comments. There is another, darker, evil group of people that leave comments on my blog. Spammers. We hate them. To discourage spammers from leaving comments on my blog I’ve taken two steps. First, I require a valid date to be entered for a comment to go through. Second, I require each comment be lovingly approved by yours truly before it shows up. That way if a spam comment sneaks through I can delete it before it shows up. It also gives me the opportunity to edit out any unflattering things that might accidently get submitted. Together I think these do a pretty good job of keeping the riff-raff out. There is one downside to all these hoops, when I submit my own comments in reply to other comments I have to approve them too. If only there was a way for SharePoint to know that any comment posted by me was pure gold and should be approved automatically. Oh wait, there is…

Oddly enough, laziness is a great motivator. My hatred for approving my own comments forced me outside of my comfortable IT Pro box and into the scary realm of end userdom. I decided that a workflow was the easiest way to accomplish this. First, let’s identify the enemy:

SNAGHTMLc752a5

That’s just unacceptable. The first step to my remedy is to fire up SharePoint Designer and open up my site and then open the Comments list.

image

After your list is open, go to the lower right corner to the Workflows section and click New:

image

I called the workflow “Auto approve TK’s comments.” I recommend you do the same.

SNAGHTMLcc2fba

After the workflow is created, you need to add a condition for the workflow. This is how it figures out whether to act or not. Since this workflow needs to determine if I’m the one submitting the comment, the condition I used is “Created by a specific person.”

image

After the condition is created we need to define it. Click “specific person” and either type the username in, or pick it from the list:

image

I pick…me!

SNAGHTMLd362cb

Next we need to assign and action to our condition. The action I used was “Set Content Approval Status.”

image

After the action was added, I clicked “this status” and selected “Approved.”

image

image

It may seem like that’s all we need to do, but there’s a couple more very important steps. First, we need to tell SharePoint to run this workflow automatically when a new item is created. In this case when a new comment is added. Go back to the workflow’s settings page and click “Start workflow automatically when an item is created.”

image

The final step is to save and publish the workflow to our list:

image

That’s all there is to it.

Now when I submit a comment to my blog the workflow runs and automatically approves it. No more of that pesky clicking for me.

image

Hope someone can make use of this.

tk

Comments

Very useful!

Such a simple solution, yet not exactly an obvious one to me. Thanks for taking time to post.  Also, am enjoying "Real World SharePoint 2010".
 on 1/10/2011 10:50 AM

Pending approval

Cool post. Laziness can be such a motivator (remote controls, cars, and computers all spring to mind). Kind wishing we were using SP for our external blog so that I could implement this!
 on 1/18/2011 3:10 PM

No Joy

I am in SP 2007 and have tried the same thing (though it works slightly differently) but for a document library (i.e. if one of the document's upload fields has a specific value I want it to auto-approve) but for some reason, although the workflow is running (I know that as I have added a step after to fire off an email to tell the creator that the doc has been approved and that is sending), the approval status remains at 'Pending'.  Now scratching head!
 on 3/2/2011 9:49 AM

Very usefull

I´m still trying to do that on my blog. :)
 on 10/9/2012 1:35 PM

Re: Very usefull

It's very handy. :)

tk
Todd O. KlindtNo presence information on 10/10/2012 9:23 AM

Thanks

Thanks for this amazing blog. I have a question though, I am trying to do this on my site, but instead of having it auto-approve for an individual, I would like to do the same for a SharePoint group we have.

Ex. If an announcement has been created by anyone that is in SharePointGroupA, approve announcement.

I've tried replacing the individual name with SharePointGroupA. But it doesn't work.

Any ideas?
 on 1/29/2013 3:00 PM

SharePoint Group

I too would like to know if you could use a Group as well as an individual in this new workflow.  Any update would be great.
 on 5/21/2013 12:10 PM

Auto Approve Task After Specific Days

Dear Sir,

I have a scenario where my workflow starts with managers approval, but some time managers will be not available so i want to set specific days and auto approve the task.

please guide me to solve this issue.

Thanks
 on 3/12/2014 4:50 AM

Workflow completed but approval status is still pending

Hi,
Thanks for your information as this is really helpful.
Unfortunately, I followed the instructions in creating this 2010 workflow for my SP2013 site, it doesn't work as expected.
When the specific person create a new post, which should then get automatically approved, the status was showed as "pending" but the workflow status was completed.
Can you please kindly shed some light in resolving this?
Many thanks.
 on 8/15/2014 12:09 AM

Nice Info

very nice post, i certainly love this website, keep on it

DAUNPKR.COM AGEN POKER DOMINO ONLINE INDONESIA TERBAIK TERBESAR DAN TERPERCAYA - http://berkontesseo.blogspot.com/2014/08/daunpkrcom-agen-domino-online.html

JagadPoker.com Agen Texas Poker Dan Domino Online Indonesia Terpecaya - http://berkontesseo.blogspot.com/2014/07/jagadpokercom-agen-texas-poker-dan.html

RajaPoker88.com Agen Texas Poker Dan Domino Online Indonesia Terpecaya - http://berkontesseo.blogspot.com/2014/08/rajapoker88com-agen-texas-poker-dan.html

BEJOQQ.COM AGEN TEXAS POKER DAN DOMINO ONLINE INDONESIA TERPERCAYA - http://berkontesseo.blogspot.com/2014/08/bejoqqcom-agen-texas-poker-dan-domino.html

PokerBuaya.com Agen Judi Poker, Domino Online Indonesia Terpercaya - http://colyminati.besaba.com/pokerbuaya-com-agen-domino-online-indonesia-terpercaya/

POKERPELANGI.COM AGEN TEXAS POKER DOMINO ONLINE INDONESIA TERPERCAYA - http://berlombakontesseo.blogspot.com/2014/08/pokerpelangi-com-agen-texas-poker.html
 on 8/27/2014 12:12 AM

Add Comment

Items on this list require content approval. Your submission will not appear in public views until approved by someone with proper rights. More information on content approval.

Title


Body *


Today's date *

Select a date from the calendar.
Please enter today's date so I know you are a real person

Twitter


Want a message when I reply to your comment? Put your Twitter handle here.

Attachments

 

 SysKit