Share via

How to have all the Lookup Column information appear in the New Item Edit window

Volesini Matej 20 Reputation points
2023-01-16T10:44:38.39+00:00

Hello,

When you set the Lookup column in SharePoint list, you add some additional columns from the source list. However, when you create new items, those additional columns will not show in the window, only the primary one.

Is there a way to add them in the New Item edit window? Also, I reckon these additional columns are filled in only after you select data from the primary column and after you are done editing.

Is it thus possible to keep the New Item window open after editing it?

Thanks for all the suggestions and answers,

Matej

Microsoft 365 and Office | SharePoint | Development
0 comments
Accepted answer
  1. AllenXu-MSFT 24,951 Reputation points Moderator
    2023-01-17T06:37:34.5533333+00:00

    Hi @Volesini Matej,

    What environment is your idea based on, SharePoint Online or SharePoint Server? As per my knowledge, there is no OOTB way to achieve this in SharePoint Online. Found an alternative method by integrating with Power Apps, please see this post: SharePoint form cannot display additional field form lookup column. You can get help from Power Apps experts via posting here if you need further help: Microsoft Power Apps Community.

    If you are working in SharePoint Server classic list, you can achieve this via injecting JS to the New Item form. See this demo:

    SharePoint list custom edit form show related lookup column field values.

    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.

    1 person found this answer helpful.

0 additional answers

Sort by: Most helpful
Most helpful Newest Oldest

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.