Hi,
Hi i want to lookup an item in a distinct gallery. The code that i use doesnt work... Does someone know how to fix it?
I want to lookup a date that matches with the gallery result ("Title" ) (Thisitem.Result)
So if the gallery say: Test 1(" project" ) i want to display the date ("datumretour") thats in the same column of the sp list in the gallery.
Gallery:
Code Gallery:
Distinct(SortByColumns(Filter([@Uitgeleend]; StartsWith(project; TextSearchBox1.Text)); "project";If(SortDescending1; Descending; Ascending));project)
Code label in gallery (does not work):
LookUp(Uitgeleend;"project"=ThisItem.Result;"datumretour")
Thanks!
Solved! Go to Solution.
It may be a language difference in how formulas are written, but I don't think you should have the parts of your formula in double quotes (").
LookUp formula should be:
LookUp(Uitgeleend;Uitgeleend[@project]=ThisItem.Result;datumretour)
It may be a language difference in how formulas are written, but I don't think you should have the parts of your formula in double quotes (").
LookUp formula should be:
LookUp(Uitgeleend;Uitgeleend[@project]=ThisItem.Result;datumretour)
thanks, it works!
User | Count |
---|---|
196 | |
125 | |
87 | |
49 | |
42 |
User | Count |
---|---|
284 | |
162 | |
138 | |
75 | |
72 |