lookup filtered by user

Forums vLooup for SharePoint lookup filtered by user

Tagged: ,

This topic contains 1 reply, has 2 voices, and was last updated by  Alexander Bautz 3 years ago.

  • Author
    Posts
  • #13604

    Pedro Ramos
    Participant

    Hi Alexander,

    There will be a way to filter a lookup using a people picker column?

    Example:
    List one: Products column and People Picker column
    List two: Lookup to Products but filtered by the People Picker column

    Each user can see only corresponding products to your column People Picker

    Something similar to this post without answer https://spjsblog.com/forums/topic/pre-filtered-lookup-list/

    Thanks
    and
    Thanks for this product

  • #13646

    Alexander Bautz
    Keymaster

    Hi,
    You can put this in the “Write your own CAML-query” field in the vLookup config:

    <Where><Eq><FieldRef Name="NameOfPeoplePickerField" LookupId="true" /><Value Type="Integer"><UserID /></Value></Eq></Where>

    Replace “NameOfPeoplePickerField” with the internal name of your People picker.

    Alexander

You must be logged in to reply to this topic.