Filled Out Custom list field values based on Sub Site hierarchy

Question

Hi ,

I have created a new site collection ( Team Site modern ) in SharePoint 2019 On premise, under this it has below hierarchy

Root Site (Company) (level 1 )>Sub Site ( Sub Department ) level 2 > Departments Sites (level 3) , example: Networks Site, Systems Site etc.

I created List 1 Sub Departments > in main Site

List 2 Departments > in main Site> Lookup Column Lookup_SubDepartment = it get Sub Department name from Sub Departments List

here i created some departments items in department list

At Level 3 departments sites i want to create some projects

for this i created custom list Projects and created two text fields Sub Department, Department

here for example when user trying to create new project in network department site

Sub Depart Name , & Depart Name filled out automatically

Answer 1

Hi @adil,

According to your description, I understand that you want to fill out fields in the list automatically, right? As per my knowledge, I'm afraid the only solution to this requirement is setting default value for those fields manually. SharePoint doesn't have any feature which can fill out fields based on site hierarchy. You can go to site settings > Columns > select the field > Default value to set default values for those fields. Then when users create list items, those fields will be filled out with default value. By the way, you can also set Column Validation if you don't want users to change the values in those fields.

---

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

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.