0

This is my first time asking a question on here, so please bare with me on this. I am creating a tool to collect averages based on a 1 to 5 scale over 4 different lists, and then collaborate those averages based off of the team chosen to another list so I can create a Chart WebPart. Here's the run down: -4 separate lists with multiple questions in a number column limited to a response of 1 - 5 "Required". -In each list there is also a "Calculated Column" that will provide an "average". (this part of the project works fine)

-I have created another List to collaborate the data (we will call this "List X) with the following columns (Team) , (Date Of Report) , (List 1 Average) , (List 2 Average) , (List 3 Average) , (List 4 Average).

-Next I need to create workflows for each list that is triggered upon a new item created. This workflow will need to update the Average for each team on "List X"

-Finally I will create a Chart WebPart to display this information in a graph. I have already completed this whole process through Excel, but this requires user input and is not automated. Unless there is a way for me to update a specific cell in an excel spreadsheet based off of a created list item... I need to do this project through multiple lists and workflows.

2 Answers 2

0

Questions: Which version of SharePoint are you using, Online or on-premises? Why don’t you update the SharePoint List X directly with workflow, but build the process through Excel?

--

SharePoint Designer (2010) workflows do not have the ability to update Excel spreadsheet. You will have to build the workflow with customization.

If you are in SharePoint Online, you can use Microsoft Flow to update the Excel spreadsheet on SharePoint list item creation.

Reference: Introducing Microsoft Flow integration in Excel.

3
  • My apologies, I am using a 3rd party hosted platform of SharePoint 2013 but only able to use SharePoint 2010 Workflows on SPD. Commented Oct 9, 2020 at 7:48
  • So the other lists have several yes/no questions as well as a number column associated to that column. (example: Does the Unit have good mental health? {yes/no} and then rate the overall mental health from 1 to 5. there will be several more questions within this specific list that an average is calculated upon submitting.. the average is a calculated column that displays in a view, but I also need to push that number to update another list (list X) automatically. Commented Oct 9, 2020 at 7:56
  • @BillyWhitley You can build a SharePoint 2010 workflow in one of these lists where you will manually create new items, and then trigger the workflow on item creation. The "Update List Item" action provides the ability to select the fields and corresponding values to update, so you will need to decide which fields in List X need to be put in. See a reference here: macaalay.com/2013/11/25/… Commented Oct 12, 2020 at 7:12
0

The issue I had was not having any items in "List X".. thus, I had nothing to update when using the "Update List Item" SharePoint 2010 Workflow Action in SPD. After adding the multiple Items, I then went back to Lists A, B, and C and updated the workflows to point to the corresponding items to update.

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.