Lookup help

(0) Share

Report

Posted on by ckserra33

421

Hi everyone. Need some help with a lookup function in my inspection app.

I have a label with the current formula "

LookUp(TTDDefectCaptures,CompareDefect = ThisItem.CompareGameList).defectSubWeek"

This returns a week that an item was inspected. Since we are not clearing the data out, it stores each week that data was created. The week we are in is week 11, last week being week 10. The issue I am seeing is that the lookup will look for the oldest entry, or it will not see a new entry. So if I do an inspection today, the lookup will not see week 11 in the lookup formula. Ive messed with using First, but to no avail. Any help would be amazing, thank you!!!

Chris

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (2)

rubin_boer 4,843 Super User 2024 Season 1 on at

Like (1)

Report
Copy link

Link copied!
hi @ckserra33 lookup will return the first value

Consider a tabe as datasource: Table({a:0, b:1},{a:0, b:2},{a:0, b:3})

a = yourItem

b= weeknumber

Lookup the latest weeknumber would be.

LookUp( Sort( Table( {a:0, b:1}, {a:0, b:2}, {a:0, b:3} ), b, Descending ), a = 0 ).b

yours

LookUp(

Sort(TTDDefectCaptures,CompareDefect = ThisItem.CompareGameList),defectSubWeek,Descending).defectSubWeek

)

hope it helps,

R

Was this reply helpful? Yes No
Verified answer

techie-t 18 on at

Like (2)

Report
Copy link

Link copied!

This sounds like it could be related to delegation. When you go to Settings > Data Row Limit , try increasing this to 2000. Alternatively, if your list could potentially increase to larger than 2000 rows, try to filter your list before you use lookup. Something like LookUp(Filter(TTDDefectCaptures, ______ = ___),CompareDefect = ThisItem.CompareGameList).defectSubWeek). Another option is to try sorting your list before you lookup so that you are querying the newer items first such as LookUp(SortByColumns(TTDDefectCaptures, "createdon", Descending),CompareDefect = ThisItem.CompareGameList).defectSubWeek

Was this reply helpful? Yes No
Verified answer

ckserra33 421 on at

Like (0)

Report
Copy link

Link copied!

Thank you @techie-t and @rubin_boer for the quick responses!! I wound up using your solution snd sortbycolumns before the lookup, and it worked great!

Here is the formula, thanks again!!

LookUp(SortByColumns(TTDDefectCaptures,"createdon",Descending),CompareDefect = ThisItem.CompareGameList).defectSubWeek

Chris

Was this reply helpful? Yes No