i have a one to one relationship between 2 tables, 1 is 'overview' table & 2nd serves as 'details' table.
i navigate from overview to details by passing ID. details is in edit mode. i filter details using first(filter(details, id=selectedid)).
i get a delegation warning. it works fine but is there a recommended way to do this?
shall i just ignore warning if it is not relevant? thanks!
Hi @fess ,
Use the lookup function instead of First(Filter(....), something like this:
Lookup(details, id=selectedid)
You receive the delegation warning because the First function is not delegable to Sharepoint (strangely!).
I hope i'm not worng, but I noticed that the delegation warning can be avoided also by using Last() function and sort Descending your filter results.
Hope it helps !
User | Count |
---|---|
205 | |
94 | |
87 | |
47 | |
43 |
User | Count |
---|---|
252 | |
104 | |
103 | |
62 | |
57 |