Sharepoint Forum

Ask Question   UnAnswered
Home » Forum » Sharepoint       RSS Feeds

Workflow in Sharepoint Designer with tasks to users in a sequence

  Asked By: Kiara    Date: Jan 24    Category: Sharepoint    Views: 2475

My scenario for the workflow in SharePoint Designer is that i want to create a
workflow where on my site

i have 3 custom lists Tests, Reviewers (Columns: ReviewerName, Sequence# )and
Approvers (Columns: approverName, Sequence# ). If any item is added in Tests
then the workflow must be started and the user in the Reviewer list with
sequence # 1 must review it. If he passes it then the user in the Reviewer list
with sequence # 2 must review it and so on . After the users of the Reviewers
list the users of Approvers list with sequence # 1 ,2 3... must approve it

Problem is that workflow works fine for single Reviewer and Approver but how to
assign the task to the users in list on the basis of sequence in the workflow.
any help will appriciated (I know it can be done in Visual Studio but how in
SharePoint Designer)



3 Answers Found

Answer #1    Answered By: Kaila Hahn     Answered On: Jan 24

I haven't tried this so take it with a grain of salt.

You can capture the taskid for the first review  task you create  in a variable
(reviewtaskid1). check the status of this task  for completion before you proceed
to the second review step. Repeat the same for Approvers as well.

Review these videos
00667661033 they might help, though the scenario  is not the same but technique
can be reused.

Answer #2    Answered By: Ada Sosa     Answered On: Jan 24

If you set up the Reviewers list  so that the Title is Reviewer1, Reviewer2,
Reviewer3, etc. then you should be able to create  an integer variable in your
workflow that you increment by 1 each time.

Set workflow  variable 'intCounter' to 1.
Build Dynamic String with 'Reviewer[%Variable:intCounter%].'
Do Calculation 'intCounter' plus 1.

You can do your lookup based on that value in your dynamic string.

Answer #3    Answered By: Cheyenne Lewis     Answered On: Jan 24

Visual Studio is the best option to create  workflows.
And from the sound of this workflow  is one that you are going to need.
Comaprison of workflows