Forum Discussion
List and sublist; Is this possible?
not_a_pro You can create hierarchy in SharePoint lists using lookup columns.
You can create a "Orders" list with common details for all suborders and 2nd "Suborders" list to store details of each suborder - in suborders list, you can create a lookup column from "Orders" list.
Documentation: Create list relationships by using lookup columns
Please click Mark as Best Response & Like if my post helped you to solve your issue. This will help others to find the correct solution easily. It also closes the item. If the post was useful in other ways, please consider giving it Like.
- So the user would have to enter data on two separate forms? I was hoping to avoid this.
not_a_pro You can create a simple canvas power apps to combine the list forms and submit the data in two separate lists.
Please click Mark as Best Response & Like if my post helped you to solve your issue. This will help others to find the correct solution easily. It also closes the item. If the post was useful in other ways, please consider giving it Like.
Do you have a good source how to do this?
I have connected 3 lists to a single Power App form.
My problem now is, that i cant connect multiple entries from List 2 to one entry from parent list.
The multiple entries from List 2 should be variable, i want to have the possibility to just have one entry or more than 10.
