Filled Out Custom list field values based on Sub Site hierarchy

adil 1,351 Reputation points
2024-11-05T10:53:13.79+00:00

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

SharePoint Server
SharePoint Server
A family of Microsoft on-premises document management and storage systems.
2,389 questions
SharePoint
SharePoint
A group of Microsoft Products and technologies used for sharing and managing content, knowledge, and applications.
10,926 questions
SharePoint Server Management
SharePoint Server Management
SharePoint Server: A family of Microsoft on-premises document management and storage systems.Management: The act or process of organizing, handling, directing or controlling something.
2,968 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. AllenXu-MSFT 21,666 Reputation points Microsoft Vendor
    2024-11-06T03:10:46.8733333+00:00

    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.

    User's image


    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.


Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.