none
Use library Name field in List lookup

    Question

  • I have a list and a library.  I want to create a lookup column in the list that grabs the Name value from the Library items.  This doesn't seem possible as Name is not provided as a selection in the drop down list.  Is there a workaround that does not involved custom coding?


    There are no mistakes; every result tells you something of value about what you are trying to accomplish.

    Wednesday, January 08, 2014 11:03 PM

Answers

  • Hello,

    Without having the relation between lists, it is not possible to update item specific item via workflow. So either you can fill Title field while uploading document so it can be set as lookup in list OR maintain some relation in both list to match the items.


    Hemendra:Yesterday is just a memory,Tomorrow we may never see
    Please remember to mark the replies as answers if they help and unmark them if they provide no help

    Monday, January 13, 2014 8:36 AM
  • Hi run4it,

    It should be not an easy thing to show related library document link in second list directly Out of the box, I tested and the lookup column hyperlink in list could only be pointing to the library item display form (not the document itself) without code approach.

    And here is an article about custom multiple column lookup field for SharePoint 2007(I haven't tested yet), you can take a look.

    http://pholpar.wordpress.com/2010/02/15/multiple-column-lookup-field-for-sharepoint/

    Thanks


    Daniel Yang
    TechNet Community Support

    Tuesday, January 21, 2014 2:32 AM

All replies

  • Hello,

    Since you can't lookup "Name" column so can you consider the Title of doc lib? You can fill title column in library then make it lookup in list.


    Hemendra:Yesterday is just a memory,Tomorrow we may never see
    Please remember to mark the replies as answers if they help and unmark them if they provide no help

    Thursday, January 09, 2014 6:50 AM
  • Hi run4it,

    You can create another new single line of text column (e.g. DocName, you can hide it from library form and view page if you want) in library and trigger a workflow to update this custom column with "Name" column value, then create a lookup column in the list to look up the library DocName column.

    Thanks,
    Daniel Yang
    Forum Support
    If you have feedback for TechNet Subscriber Support, contact tnmff@microsoft.com. 

    Daniel Yang
    TechNet Community Support

    Thursday, January 09, 2014 12:24 PM
  • I've tried a few things unsuccessfully.   I thought I could create a custom workflow on the library that would grab the Name field from the library and copy it to a field in the list.  From there I could create the hyperlink in the list. The problem is there is no relationship, other than the one I am trying to create, to link the list item with the library item. So in the workflow I cannot tell it which item in the list to update.

    There are no mistakes; every result tells you something of value about what you are trying to accomplish.

    Thursday, January 09, 2014 6:07 PM
  • Hello,

    Without having the relation between lists, it is not possible to update item specific item via workflow. So either you can fill Title field while uploading document so it can be set as lookup in list OR maintain some relation in both list to match the items.


    Hemendra:Yesterday is just a memory,Tomorrow we may never see
    Please remember to mark the replies as answers if they help and unmark them if they provide no help

    Monday, January 13, 2014 8:36 AM
  • Hi run4it,

    It should be not an easy thing to show related library document link in second list directly Out of the box, I tested and the lookup column hyperlink in list could only be pointing to the library item display form (not the document itself) without code approach.

    And here is an article about custom multiple column lookup field for SharePoint 2007(I haven't tested yet), you can take a look.

    http://pholpar.wordpress.com/2010/02/15/multiple-column-lookup-field-for-sharepoint/

    Thanks


    Daniel Yang
    TechNet Community Support

    Tuesday, January 21, 2014 2:32 AM