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 !
Stay up tp date on the latest blogs and activities in the community News & Announcements.
Mark your calendars and join us for the next Power Apps Community Call on January 20th, 8a PST
Dive into the Power Platform stack with hands-on sessions and labs, virtually delivered to you by experts and community leaders.
User | Count |
---|---|
202 | |
185 | |
77 | |
47 | |
37 |
User | Count |
---|---|
325 | |
259 | |
123 | |
72 | |
58 |