i have 3 SharePoint lists (Processes, Systems & SystemsClassifications)
In list SystemsClassifications i have a lookup collumns for Systems and Processes.
i want to fill a dropdown whit the systems used for that proces.
In my application i catch the Proces in a variable from a gallary whit source:
Set(Var_Scr_Proces, Gal_Processes.Selected)
I have set a filter on my dropdownlist as Items
Filter('SystemsClassifications',Proces.Value = Var_Scr_Proces.Title)
I can see the "Value" properties and the correct records in the filter.
But i can't see the system field in the value property, or if i change the Filter('SystemsClassifications',Proces.Value = Var_Scr_Proces.Title).System.
It won't work, problebly cause the values are records.
How can i get those values of the system field?
ps: (its a single value lookup collumn)
Kind regards,

Report
All responses (
Answers (