1

I am hoping someone could direct me to the right path on being able to do the following.

I have an "issue tracker" list, and a "Team Discussion" list. When adding a new item to the "issue tracker, I would like for SharePoint to automatically add a new item in "team discussion" list that I will use to relate/connect to the item associated with in the issue tracker using the lookup column.

I'm doing this to utilize discussing topic at work in a more appreciate area such as the "team discussion" list instead of using emails back and forth with colleagues and our partners.

I know that I can do this manually, but I'm hoping to utilize a workflow to automate this process.

Here are the current steps: 1. Create new item in "Issue tracker" with a topic. 2. Create new item in "Team Discussion" relating to above topic. 3. Edit Issue Tracker item with related item in Team Discussion list using "Lookup" column 4. Edit Team Discussion item with related item in Issue Tracker list using the "Lookup" column.

I hope this make sense and appreciate your help and direction.

  • Any idea to post a reply to a discussion via a workflow? I want to post changes to the Task meta data directly into the list (Eg assigned to or due date changes) – P Howley Oct 2 '17 at 13:36
2

You need to create two lists, Issues and Discussions with a lookup column on each referring to the other list (so, in the Issues list the lookup column points to Discussions and in the Discussions list the lookup column points to Issues).

Then, you create a worflow attached to the Issues list with the following configuration:

enter image description here

Inside the "Create item in Discussions" action, you need to assign the Title value (eg: Discussion for [%Current Item:Title%]) and the Issue lookup column value to Current Item:ID.

Then, you add an action of type "Set field in current item" where you set the Discussion lookup column value to the Variable:create value.

As a last step, you need to set the workflow to start automatically upon item creation.

| improve this answer | |
  • Thank you very much! This sounds very great. I'll try it and report back. – Humble Val Jan 14 '14 at 21:50
  • is this a question? if so, I would suggest that you ask another question so that others can have a look as well – MdMazzotti Jan 29 '14 at 15:59
  • Here's the question: sharepoint.stackexchange.com/questions/89088/… – Humble Val Jan 29 '14 at 16:32
  • I do have the same requirement. Could you please describe the steps for the below two processes. 1. lookup column on each referring to the other list 2. create a workflow. – user41160 Apr 7 '15 at 1:49

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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