Contents
As the Text column is supported to be used in Lookup column, a thought is that, you can create an extra Text column, then develop a SharePoint Designer workflow to copy the value of the “Person or Group” column to it. By doing this, in the second list, you will be able to create Lookup column to get data from this extra Text column instead.
Where to find information about SharePoint 2010 development?
Questions about SharePoint 2010 development can be answered here: http://social.msdn.microsoft.com/Forums/en-US/sharepointdevelopmentprevious and for previous versions here: http://social.msdn.microsoft.com/Forums/en-US/sharepointsdevelopmentlegacy 1 1 I’ve created two sharepoint lists.
How to get first level folder in SharePoint?
Use this forum to discuss topics about traditional SharePoint development for the RTM release version of SharePoint 2013.
In SharePoint Designer workflow, there is an action “Set filed to value” can be used to set a field in the current item to a value: https://support.office.com/en-us/article/Workflow-actions-in-SharePoint-Designer-2010-A-quick-reference-guide-5a7ad276-0ed7-49b0-b652-e56a77dd96c6 Please let me know if you may have question about it.
Then go back to the Library setting and Under content types select the “Document” Content type. THen Select Title Column and then Select “Required (Must contain information)” and say OK. Now try uploading a document to this document library.
How to create a lookup column that targets a document?
Well there is a simple solution to that and in might work in some case. In the nutshell if you make the Title field Mandatory, this will force the user to enter a title. In that manner we can use title field as a lookup field. Now How to do that? One you are done create a document library go to the library setting.
How to look up Docs in SharePoint Online?
In SharePoint Online I have a doc library (Reference Docs) and a list (Projects). The goal is for users to choose a doc from a lookup drop-down in Projects, which, when clicked, will directly open the chosen document stored in Reference Docs.
How to create a Lookup column in SharePoint. Step 1: Build the custom lists (or document libraries) Just to be clear, you can connect not just the SharePoint lists, but also the document Step 2: Create a Lookup Column. Step 3: Tag the entries. Step 4: One to Many Lookups (Optional)
How many lookup columns can I create in a view?
According to Nate Chamberlain, you can only have a max of 12 lookup columns in a view. You cannot create lookups across sites (linked lists and libraries need to reside in the same site) The lookup column only creates a one-way link.
What is the definition of a lookup column?
What is a Lookup column A Lookup column is a column type that allows you to connect a list or a library to a column from another list or library you have on your site and also pull in other information from that other list and display it the list you are connecting from. If I just confused you, let me give you an example.
Can a lookup column create a 2 way link?
The lookup column only creates a one-way link. In other words, if you link Contact A to Company ABC, it won’t create a link from Company ABC to Contact A. So, if you want to do a 2-way relationship, you will need to do this manually both ways.
When do you create a lookup column in a source list?
When you create a lookup column in a source list, the primary column displays values from the target list column, but you can also specify that additional, secondary columns from the target list also display alongside the primary column and the other source list columns.
Can a unique column be used in a lookup column?
The following table summarizes what column types can and cannot be used to create unique columns. To create a relationship between two lists, you create a lookup column in the source list that retrieves (or “looks up”) one or more matching values from a target list.