0

I have a list that contains usage information for tooling. Each time a tool is used, a new line item in the list in entered. This results in the "Tool ID" column being the same (tool ID number), but the usage specifics are different. Refer to this as List 1.

I have created a new list for documenting issues with tool usage. Refer to this as List 2. Among other things, I need to pull all of the usage specifics from List 1, based on the selection of tool ID. Ideally, the usage information from multiple lines in List 1 should be put into one line in List 2.

I have tried doing this through a lookup column in List 2, but I am running into the issue where my resulting pick list has a tool id number instance for every entry on List 1.

0

I have had to do similar thing before with ticketing systems and admin areas based off of data form separate list. One of the best methods I have found is with your list 1 and list 2 is as follows:

  • When a user creates a list item in list 1, have a workflow create an item in list 2

  • As part of list 2, create a meta column to capture a reference to the list item in list 1

  • Name it trackerID or something to help you remember

  • In your workflow that creates the item in list 2 when the list 1 item is created, set the trackerID in list 2 to the list item ID in list 1. This will create an artificle one-to-=one relationship between your two list.

  • your list items are now connected

Now you can create logic in workflows between the to list and link them.

For example:

When a user updates an item in list 1, I want to update fields 1, 2 and 3 in list two when trackerID eq list 1 item ID.

You can go the other direction as well. Now you can pass data back and forth between the list and also update data from the second list in relation to the list item in list 1.

[Use case]

User 1 has used a tool and it is updated in list 1. If useage of the tool in list 1 > 10, update list 2 meta data about the tool where list 1 item ID eq list item 2 trackerID

I hope this makes sence to you. Thi sis a great way to simply and effectivly link SharePoint lists items together. You can keep goin gwith this logic through several list and have them all connected to the original. I have systems that use 20 lists and I can always go back and forth at any poin tin my pogic using this method. Good luck!

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.