Share via

Microsoft Lists - Inventory Tracking List Question

Anonymous
2022-01-08T05:26:39+00:00

I have built a List to keep information about and keep track of a large number of pieces of technical field service testing equipment. Some of the items in the list are singular pieces of equipment (i.e. one handheld combustion analyzer), while others are service kits which contain a number of individual pieces of equipment (i.e. multiple different Fluke test instruments, handheld pressure pumps for calibrating instruments, digital pressure gauges, etc.).

My List is currently built to treat each kit as a singular item, with one status indicator (Available, Checked Out, Permanently Assigned to Tech, Needs Repair, etc.). I would like to be able to individually list all of the components in each kit as individual items in the list, but keep them grouped together as one kit. For example, if one piece of equipment inside the kit is sent out for repair or calibration, that can be noted on that item individually, but the rest of the kit as a whole can still have it's own status, parameters, etc.

What is the best way to accomplish this? Enabling the creation of Folders in the List and create each kit as a Folder and then list the individual pieces of equipment inside the kit as list items within that folder?

Your suggestions as to best practices and best way to accomplish this greatly desired.

Microsoft 365 and Office | Install, redeem, activate | For business | Other

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments No comments

Answer accepted by question author

  1. Anonymous
    2022-01-08T11:36:12+00:00

    Hi IAmA#Banana,

    I go through the post carefully, yes, as there could be no built in feature to create subitems in a List, create folder in the list could be an easier way to meet your requirement. There are also other alternatives though, for your references:

    You may create a task list(Site Content>new App>Classic Experience>Task List app), and  add the kit as task in the task list. You may add pieces of Equipment as subtask in the task list(To switch a task between Task and sub task, Select item>Tasks tab at top>Outdent/Indent), and add columns you want for the list. However, you may not need the original form of the list and you may need to edit it with SharePoint designer.

    If you save kit information in different lists, you may try using Power Apps to create Cascading lists: Working with Cascading Lists in SharePoint and Power Apps | Microsoft Docs

    Best Regards,

    Clark

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments No comments

1 additional answer

Sort by: Most helpful
  1. Anonymous
    2022-01-11T09:35:42+00:00

    Hi IAmA#Banana,

    Please feel free to post back if you still need assistance.

    Regards,

    Clark

    Was this answer helpful?

    0 comments No comments