Saturday, August 19, 2017

Column Auto Increment through SharePoint Designer

Hi,

After adding a new item in the Sharepoint list, value should be incremented under a Sharepoint column ‘ChronoListField’.

This has to be achieved with SharePoint designer workflow.

To achieve this, first we have created a list ‘ChronoIncrement’ and added a column ‘AutoIncrement’ of type number.

Now we have created workflow in the list where column value needs to be incremented with newly added list item.

Through Do Calculation we have done the manipulation as below i.e.

Under Data source, have selected list ‘ChronoIncrement’ and have selected field ‘AutoIncrement’ field to retrieve.

To find the list item, have selected ID field and the Value ‘1’
Incremented the value and have assigned to a variable called ‘incrementedval’
After this have assigned variable ‘incrementedval’ value to SharePoint column ‘ChronoListField’
Then updated the value back to list ‘ChronoIncrement’ under column ‘AutoIncrement’ w.r.t ID value ‘1’

After this, logging the incremental value to the history list
Ended the workflow as below

At last below is the workflow that has been published
End Results
Below are the results that have been achieved