Tony Rockwell – Info

sharepoinTony@info – Cloud Computing adventures

Posts Tagged ‘SharePoint Links’

Happy Earth Day – SharePoint for a green planet!

Posted by sharepoinTony on April 22, 2009

Wouldn’t it be nice if so many companies started using SharePoint in such a way that they saved on paper and collaborated online enough to reduce their impact on the planet?

Posted in Green | Tagged: , | 1 Comment »

Nice site

Posted by sharepoinTony on April 20, 2009

Just found this SharePoint News site, I like it:

Posted in SharePoint Links | Tagged: , , | Leave a Comment »

SP2010 announcement

Posted by sharepoinTony on April 16, 2009

Microsoft SharePoint Server 2010

With all of the buzz around the Microsoft announcement regarding the new 2010 version of products, with the significant title on many blogs  being: Microsoft SharePoint “14” is now Microsoft SharePoint 2010 (see the SharePoint Team Blog)… I had to get my word in.

Considering the new official name is Microsoft SharePoint Server 2010, the good old “MOSS” acronym will have to go by the wayside.  Many have pointed out that one cannot rush to use the acronym “MSS” as this refers to Microsoft Search Server.  The reasoning behind the removal of “Office” from the name is sound in my judgment, and I am glad to see the differentiation between the client ‘Office’ applications and the server suite of products.   Anyway, the important part of this message is the critical issue of what everyone in the trenches will call this new version of SharePoint.  I am here to help.

Being an extrodinary sooth-sayer, philosopher and cutting-edge technologist it was easy for me to declare the new shortcut/acronym that will be used by all for this new version of SharePoint will be…


You are welcome.


Posted in Commentary, SharePoint Links | Tagged: , | Leave a Comment »

Using alternate list data in a SPD Workflow.

Posted by sharepoinTony on March 27, 2009

Background:  MOSS 2007, SharePoint Designer 2007 used to create the workflow.

I have a user request workflow which is initiated when a new item is created in a user request list.  The user is required to select a ‘location’ when submitting the form (this form is used by many different locations in the USA).  Depending on the type of request an approval may be needed and I send an email to a designated approver based on the location that was selected by the user.   The user doesn’t know who the approver is and the support desk staff may or may not know either.  I currently am using hard-coded email addresses for the approvers in my workflow.  I ‘set’ a column with the email address once it is determined in the workflow and in later steps use that field in the email message.

What I would like to do is use another list to allow us to maintain the approvers, their appropriate email address, and the location where they are allowed to approve requests.

Here is how I did it:

  1. Edit my workflow in SharePoint Designer (SPD)
  2. Navigate to the appropriate step and conditional branch.
  3. Modify the “Set” field line,  selecting my  ‘other list’ as Source in the “Lookup Details” section of the Define Workflow Lookup window (note that this window opens when you select another list in the Source drop-down).
  4. Select the field in that source that I want used in the user request list for the Field selection of the Lookup Details section.
  5. Under “Find the List Item” section, I used the other list Location column in the Field selection.
  6. I then used the current list Location in the Value selection
  7. Click OK to close the Define Workflow Lookup window.
  8. Click YES to the warning (if it displays) that says “The lookup that you defined is not guaranteed to return a single value.” etc.. “Do you want to continue?”
  9. Finish your workflow to save and close the Workflow Designer window.
  10. Test it out – The appropriate approver is pulled from my “approval maintenance” list and placed into the current list item in my user request list!

This took me a little effort to figure out, it isn’t clearly documented and I couldn’t find it in the SPD help.  Maybe someone else will be able to use this, and shortcut their search effort to figure out how to do this kind of lookup in a workflow.

Posted in Designer, SharePoint Links, Workflow | Tagged: , , | 2 Comments »