.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
david stephan
Gaurav Pal
Post New Web Links

Workflow on status column change

Posted By:      Posted Date: December 04, 2010    Points: 0   Category :SharePoint

I want a workflow on a content type with a status column (new, pending, completed, ....)

I want it to fire off when this column changes, not when the item is updated, because it might be updated for other reasons (the title changed).  How do I make sure it only happens on the column change? 


View Complete Post

More Related Resource Links

Why is workflow status column empty and how to change it?


One particular instance of the workflow shows workflow status column as empty although it should be showing IN PROGRESS since if click on workflows from item's context menu I can see the workflow running on it;  _layouts/workflow.aspx show it as in progess.
This workflow was not created 60 days ago and its not complete. I wonder why it displays empty in the workflow status column.

Also can this column be changed from web service? I tried using:

<FieldRef Name='myworkflow'>2</Field><FieldRef Name='ID'>23</Field>

and updating it. While the webservice code does not throw any error and ListService.UpdateItems() returns 0x000000, this column doesnt get updated. Any ideas what could be wrong?

Change the Workflow Status through code


HI Folks,

I have a scenario where i need to develop a 6 stage approval workflow(sequential) using WWF and depoly it to sharepoint. Everythigns fine till here.

Now we look ahead to change the Status field on the documents library which actually has the Workflow Name as the column name and its value being In Progress, depending on the stage of approval. Like(Approved 1, Approved 2, Approved 3.)

And if rejected the status should be rejected than Completed. Any idea how can we update this column of the List item.

I have tried item[workflowProperties.Workflow.ParentAssociation.Name]="Approved 1";

But this throws an error saying input string is not in a correct format.

Any information would be of great help :)


Sreeharsha Alagani

How to Change Workflow Status Programatically on DueDate reached


I have developed a sharepoint approval workflow using VS.NET 2008. Workflow fires when any new item is created. Three parallel task is created and waiting for approval.

Workflow will only completed when all three approvers approves/completes their task. I want to change the status (denied) of the workflow every tuesday 11:59PM if any one of the approval is pending. This  denial work I want to perform by programatically within the workflow.

so I need suggestion how do I achieve the above scenario?

Do I write any timer job to monitor workflow status on every tuesday 11:59PM and denied as per the logic mentioned above.


Do I encaptualte the denial logic withing the workflow itself?

Please suggest a way to solve the problem...

thanksArup MCTS - SharePoint

Play Sudoku

Change the Status in Gridview column




I have a gridview and a button-Start in aspx page.

In gridview 3 columns checkbox , Name and Status.

Select multiple columns and click on Start then Status column for selected rows should be changed to "Starting...", later it should be changed to "Started".


But it is showing directly "Started". In the mean time i should see "Starting..." also.


Here is my code


<b>Aspx page</b>


 <asp:GridView runat="server" AutoGenerateColumns="False">


<asp:TemplateField>   <ItemTemplate>                                                    <asp:CheckBox runat="server"/>



<ItemTemplate> <asp:BoundField HeaderText="Name" DataField="Name" />  

<asp:TemplateField HeaderText="Status">          &nb

Bug: Does not change column type from nvarchar to ntext


Scenario: If you create a table with a column of type nvarchar, populate it with some content and try to modify it using the WebMatrix editor, from nvarchar to ntext, it does not display any error message or warning that this is not possible. It silently saves and reverts the change, back to nvarchar. Wasted some hours on this issue as I thought my column was ntext, but in fact was still nvarchar.

Expected behavior: It should change to ntext, or if SQL CE doesn't support that, it should notify the user that no change was applied.

dynamically change column names in Crystal reports


I need to develop 3 pages.

On the first page user defines atmost 7 column names to be displayed on the report. I'm saving these names in a Sql DB table 'Columns' with Column_Nm and Column_ID as Table columns.

On the second page I'm retrieving column_Nm from the table and displaying them on the page so that the user enters the data. This data is saved in another table 'Summary' with the Columns column1 through column7.

on the 3rd page I need to show a report of 'Summary' table.

How do I dynamically replace column1 through column7 names with that of 'Column_Nm' on the report?

Any help/suggestions would be appreciated.


How to make the Workflow Status remain "In Progress" when a task is "Rejected"


Hi Sir/Mam,

I have a work flow running on a list, when a task is Rejected at a stage then the Workflow status is set to "Completed". Instead of this I want the Status to remain as "In Progress", so that in future after the modification of the document the Approver may Approve it and then take it to the next stages. This is not possible if the Workflow is set to "Completed".

Can you please suggest an easy way to do this

Thanks in Advance


change the font color according to the column



i have a column in the list which has values 1.Added



i want to make the field values Killed to be make it as Red so i tried in sharepoint designer converting to xslt data view then did formatting but the problem is i am not able to see the edit in data sheet option. can you please is there any way i can have both to be working? or is there any alternate solution for formatting column based on values

thank you so much.



DataGridView>Edit Columns> Column Read Only property is unwilling to change

Hello, I am facing the following mystery: When changing the read only property of a column to false and reopening the "edit columns" window, it mysteriously turns back to true. Even when closing the designer and changing it in the designer code, the resulting execution does not allow edit, as well as when re-opening the designer you see true again.             this.numberDataGridViewTextBoxColumn1.DataPropertyName = "Number";             this.numberDataGridViewTextBoxColumn1.HeaderText = "Number";             this.numberDataGridViewTextBoxColumn1.Name = "numberDataGridViewTextBoxColumn1";             this.numberDataGridViewTextBoxColumn1.ReadOnly = true;//False is required We thought it might be related to data binding. rebinding the grid did not help as well. The is no other place in the code where it changes. Please advice, Thanks

Change workflow rule file

Hi, I create workflow and rule base condition for that ".rule file"  . But now i have to change rule condition . when i change the condition then it return error can't  validate because of it refer previous values.   Any one can tell how change rule base conditions in workflow.

Dynamically change column names in Crystal reports - ASP.Net

Hi I am developing an application in ASP.net 3.0 and MY SQL database . I want to display column names & values in crystal report as user selects in ASP.net application  and column names and corresponding values will be changed dynamically. Any help/suggestions and sample code would be appreciated. Thanks in advance....  

Change Default Column Value programatically

On a Document Library Settings Page, there is a new setting in SP2010: "Change Default Column Value". Changing the default value of the Field is different from this value. Does anyone know what this value is and where to set it programatically? Also, what libraries is this setting available on? This code updates the field's default value but not the property mentioned above: SPField field = list.Fields["Column"]; field.DefaultValue = "DefaultValue"; field.Update(); Thanks!

SPD workflow status show "starting" when I create a document from the library !!. and hangs

I have a document library in MOSS 2007. Have created a WF and that starts "autmatically when new item created" In the document library I have created couple of column those are mandatory (required columns) and user has to fill those column while uploading a document as well creating a document from library. WF has ran and completed succefully  when I use "upload" option to load a document.  As you are aware, when we "upload" a document, we will have to fill all "required columns" and the click "check in" command button.  After I do all this, document get loaded and WD ran succesfully. However, the WF is not running when I create a document (.docx) from this library (using "new" button) !!.  I have filled all required field in the document information panel . After save & exit from WORD application, I can see WF status as "starting". But, it never started and completed.  So I did following and found WF worked !! a) After creating document (.docx) using "new" option I found WF status "starting"!. So,  I did "Check-out and Check-in" manually from document library. After doing this,  WF ran and status has been changed as "completed" b) In SPD, I change workflow start option from "Automatic" to "Manually start".&nb

How do I change the order of column names in EditForm.aspx

I have an Announcements list to which I've added extra columns: Publish (date), De-Publish (date), and Category (choice).  When I go to EditForm.aspx, the columns display in this order: Title , Body, De-Publish , Category and Publish . I'd like to change the order of the columns on EditForm.aspx so that it is Title, Body, Category, Publish and De-Publish . Changing the All Items view doesn't do it. How might I change the order of columns that is shown to the user?

how to change the permissions list items using the workflow?

How to change the permissions list items using the workflow? Or how to instull SPDActivities on sharepoint 2010?

Fill person/group column with workflow

Hi all, I would like to retrieve the 'Department' value of the creator of a list-item. Therefore I created a column named 'Department' of type person/group, show field 'department' From a worflow created with SharePoint Designer, when a item is added to the list, I fill the column 'Department' with the field 'created by'. The result is that the column 'Department' nicely displays the Department of the creator of the added item. When I do the same for a library, the column Department don't get filled, and the workflow keeps the state 'Started'. Any idea what I'm doing wrong? Kind regards. #Update When I add a new document te the library, the column 'Department' stay's empty and the workflow keeps the status 'Starting' But when I save a new document, open it again, edit it and save it again, the column 'Department' shows the department of the creator !!

How to Change the Color of Link Label which is a Datagridview Column on a Row Selection?

Hi All I have a Link label as one of the column of Datagridview & also my SelectionBackColor set to Blue. Is there any way that i can change the link label color on a particular row selection as now my selectionbackcolor & link label color is matching...I am unable to the contents of that link label column. Should i do this on design level or in code level? Pls Help
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend