what is best practice for filtering one record when navigating between screens? first & filter give delegation warning

[fess]

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!

[gabibalaban]

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 !