lookup filtered by user

Forums vLooup for SharePoint lookup filtered by user

Tagged: ,

Viewing 1 reply thread
  • 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

Viewing 1 reply thread
  • You must be logged in to reply to this topic.