How to create my SharePoint lists for a defect detection system.. need advice

Question

I want to build the following defect detection system in SharePoint. The interface will be built using Power Apps. but currently i am struggled on how to build the SharePoint lists and the relation between these lists.

For sure i will have a list to store the main section marked in red, with these fields:-

ID
Name
Equipment ID
Type
Date / Time
Comments

But how i can represents the other info such as Heavy Equipment,Body Damage,fluid Leaks, etc.. for example? should they be represented using separate lists or one list with a category drop-down (the drop-down will have options including; Heavy Equipment,Body Damage,fluid Leaks, etc.. )? and their sub-sections?

Answer 1

@john john ,

Per my test, we could store Category and Defect details in two separate lists,then use cascading Lists in SharePoint and Power Apps to build connections:

https://learn.microsoft.com/en-us/microsoft-365/community/working-with-cascading-lists-in-sharepoint-and-powerapps

However, we could only select related defect details column based on category, not able to fill in a form like you said.

---

If an Answer is helpful, please click "Accept Answer" and upvote it.

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.