department value autopopulated using listform json

sweetu ve 281 Reputation points
2022-11-10T16:33:00.823+00:00

i created listform using JSON and i need to auto populate employees department using json in my list form

is it feasible by JSON?

SharePoint
SharePoint
A group of Microsoft Products and technologies used for sharing and managing content, knowledge, and applications.
10,242 questions
0 comments No comments
{count} votes

2 answers

Sort by: Most helpful
  1. Tong Zhang_MSFT 9,141 Reputation points
    2022-11-11T03:22:08.85+00:00

    Hi @sweetu ve ,

    Do you want to auto-populate fixed values to SharePoint list columns? If my understanding is wrong, please feel free to contact me.

    If yes, you can try to use the following JSON code:

    {  
       "$schema": "https://developer.microsoft.com/json-schemas/sp/v2/column-formatting.schema.json",  
       "elmType": "div",  
       "txtContent": "department"  
    }  
    

    My test result:
    259326-image.png
    259317-01.png

    Hope it can help you. Thanks for your understanding.


    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.



  2. sweetu ve 281 Reputation points
    2022-11-11T04:02:15.317+00:00

    Thanks for response

    I am looking for auto populated values based on employees department for example if employee department is finance department then it should fetch the values from azure directory to display the values and your above code is unfortunately unhelpful in this context of requirements.

    I appreciate kind help.

    Thanks in advance.

    0 comments No comments