How do I create a 2013 SharePoint Designer workflow to calculate points from two different types of awards?

morris greer 0 Reputation points
2023-12-31T21:15:54.13+00:00

What are the steps to create a SharePoint Designer workflow that calculates the points received from two different types of awards? Specifically, what are the steps to set a SharePoint Designer 2013 workflow trigger when an item is created or modified in a list, set the workflow variable value, run an 'If' statement to check the workflow variable totals points, and then send a notification email when the points total 4 points?

SharePoint
SharePoint
A group of Microsoft Products and technologies used for sharing and managing content, knowledge, and applications.
10,252 questions
SharePoint Development
SharePoint Development
SharePoint: A group of Microsoft Products and technologies used for sharing and managing content, knowledge, and applications.Development: The process of researching, productizing, and refining new or existing technologies.
2,800 questions
SharePoint Workflow
SharePoint Workflow
SharePoint: A group of Microsoft Products and technologies used for sharing and managing content, knowledge, and applications.Workflow: An orchestrated and repeatable pattern of business activity, enabling data transformation, service provision, and information retrieval.
549 questions
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Emily Du-MSFT 44,071 Reputation points Microsoft Vendor
    2024-01-01T08:24:58.24+00:00

    Per my test, SharePoint 2013 workflow cannot calculate points based on different award type and awardee.

    As a workaround, I suggest you group and count points in the view.

    1.Create a choice column named AwardType and a number column named Points.

    2.Add items.

    3.Modify current view, in the Group By section, choose Title.

    4.Modify current view, in the Totals section, in the Points column, choose sum.

    1

    User's image

    If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.