lookup filtered by user

[Pedro Ramos]

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

[Alexander Bautz]

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

[Author]

Posts