Home

set dropdown filter in PSC lookup to dynamic value from reference column

%3CLINGO-SUB%20id%3D%22lingo-sub-769487%22%20slang%3D%22en-US%22%3Eset%20dropdown%20filter%20in%20PSC%20lookup%20to%20dynamic%20value%20from%20reference%20column%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-769487%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20the%20following%20problem%3A%3C%2FP%3E%3CP%3EFrom%20list%20%E2%80%9CA%E2%80%9D%20I%20want%20to%20look%20up%20information%20in%20list%20%E2%80%9CB%E2%80%9D%20using%20a%20column%20of%20type%20%E2%80%9CPSC%20Lookup%E2%80%9D.%20This%20column%20is%20named%20%E2%80%9Cvariants%E2%80%9D.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20managed%20to%20have%20a%20drop%20down%20list%20opening%20in%20column%20%E2%80%9Cvariants%E2%80%9D%20showing%20the%20preselected%20columns%20from%20list%20%E2%80%9CB%E2%80%9D%20which%20I%20have%20defined%20in%20dialogue%20%3CEM%3E%3CSTRONG%3E%E2%80%9CSearch%20fields%20definition%20(dropdown%20columns)%3A%E2%80%9D%3C%2FSTRONG%3E%3C%2FEM%3E%3C%2FP%3E%3CP%3EOne%20column%20in%20list%20%E2%80%9CB%E2%80%9D%20is%20named%20%E2%80%9Ctool%E2%80%9D%20and%20I%20want%20to%20set%20the%20filter%20option%20to%20filter%20the%20dropdown%20for%20a%20specific%20tool%20number.%20I%20can%20do%20so%20using%20the%20dialogue%20input%20line%20%3CSTRONG%3E%3CEM%3E%E2%80%9CConditions%20for%20search%20query%20(dropdown%20filter)%3A%E2%80%9D%3C%2FEM%3E%3C%2FSTRONG%3Eand%20enter%20e.g.%20%E2%80%9C%3CEM%3E%3CSTRONG%3Etool%20eq%20%E2%80%98123%E2%80%99%E2%80%9D%20%3C%2FSTRONG%3E%3C%2FEM%3EThis%20works%20fine!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EBut%20how%20do%20I%20set%20this%20filter%20to%20use%20a%20dynamic%20value%20from%20list%20%E2%80%9CA%E2%80%9D%20which%20is%20found%20in%20a%20column%20(Type%3Dtext)%20called%20%E2%80%9Creference%E2%80%9D%3F%20I%20tried%20%E2%80%9C%3CSTRONG%3E%3CEM%3Etool%20eq%20reference%E2%80%9D%3C%2FEM%3E%3C%2FSTRONG%3E.%20But%20this%20leads%20to%20an%20error%20message%20saying%20%3CEM%3E%E2%80%9CColumn%20reference%20does%20not%20exist%E2%80%9D%3C%2FEM%3E.%3C%2FP%3E%3CP%3ESo%20what%20would%20be%20the%20correct%20setting%20for%20having%20a%20filter%20set%20to%20the%20individual%20entry%20of%20a%20value%20in%20column%20%E2%80%9Creference%E2%80%9D%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20for%20your%20advices%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-769487%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ESharePoint%20Server%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Highlighted
Klaus_702
Occasional Visitor

I have the following problem:

From list “A” I want to look up information in list “B” using a column of type “PSC Lookup”. This column is named “variants”.

 

I managed to have a drop down list opening in column “variants” showing the preselected columns from list “B” which I have defined in dialogue “Search fields definition (dropdown columns):”

One column in list “B” is named “tool” and I want to set the filter option to filter the dropdown for a specific tool number. I can do so using the dialogue input line “Conditions for search query (dropdown filter):” and enter e.g. “tool eq ‘123’” This works fine!

 

But how do I set this filter to use a dynamic value from list “A” which is found in a column (Type=text) called “reference”? I tried “tool eq reference”. But this leads to an error message saying “Column reference does not exist”.

So what would be the correct setting for having a filter set to the individual entry of a value in column “reference”?

 

Thanks for your advices

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
48 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
30 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies