3

Environment: SharePoint 2013 Enterprise

Is it possible to sum the numeric values in a column and show the output on a new column in SharePoint 2013 List using SharePoint Designer Workflow?

List schema and result screenshot for better understanding:

screenshot

3
  • Did you try with count option of column and than to use rest api to catch that value and put it in new field/column.
    – Danilo
    Jun 21, 2016 at 6:34
  • I`m well versed on rest api, any article that gives deeper update for freshers
    – Jason
    Jun 21, 2016 at 7:35

1 Answer 1

3

Yes it is possible through SPD 2013 workflow along with REST Webservice call. Follow the steps below,

  1. Create a list workflow for the list where Column1 is present
  2. Configure the workflow to get triggered on Item Adding and Item Edit
  3. Edit the workflow
  4. Build a dictionary with below parameters and set output variable as Request Header

    accept : application/json;odata=verbose content-Type : application/json;odata=verbose

  5. Call HTTP Web Service with following parameters

    HTTP Web Service URL: <Site Url>/_api/Web/Lists/GetByTitle('<List Name>')/items?$select=Column1

    HTTP Method: HTTP GET

    ResponseContent to Variable: data In the properties of this action, set RequestHeaders parameter to Variable: Request Header created in the step 4

  6. Add the below steps

    Get d/results from Variable: data (Output to Variable: dataList )

    Count Items in Variable: dataList (Output to Variable: count1 )

    Log Variable: count1 to the workflow history list

    Set Variable: index to 0

    Set Variable: Sum to 0

  7. Create a loop block with Loop n Times then add the following steps into it,

    The contents of this loop will run Variable: count1 times

    Get d/results([%Variable: index%])/Column1 from Variable: data (Output to Variable: Column1Value )

    Calculate Variable: Sum plus Variable: Column1Value (Output to Variable: calc1 )

    Set Variable: Sum to Variable: calc1

    Calculate Variable: index plus 1 (Output to Variable: calc )

    Set Variable: index to Variable: calc

  8. Now you will get the summation of Column1, using the below step add/update item in the corresponding list

    Create item in this list (Output to Variable: create )

This is the basic logic for your requirement, enhance the code based on your further requirements.

Refer the following links for more informations,

CALLING THE SHAREPOINT 2013 REST API FROM A SHAREPOINT DESIGNER WORKFLOW

Looping Through List Items in SharePoint 2013 Designer Workflows

9
  • Nagarajan, appreciate for such a detailed explanation. Will test n update
    – Jason
    Jun 21, 2016 at 8:51
  • Wecome.. awaiting your response Jun 21, 2016 at 9:08
  • Hope this can be reused by making it part site template? As that is my destination.
    – Jason
    Jun 21, 2016 at 9:45
  • Jason, making a site template and reusing it can be done. But did this worflow gave you the needed solution? Jun 21, 2016 at 10:16
  • Give me few hours, as need to access my dev environment to test the same.
    – Jason
    Jun 21, 2016 at 11:57

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.