Lookup function for list more than 5000 items

  • 16 December 2021
  • 1 reply
  • 60 views

Badge +1

Hello,

 

I have  list with more than 5000 items, I'm trying to use lookup function  to that list in calculated field to get a value. 

It is simple lookup which looks like this lookup("PO","Title", Control on form,"VALUE"). It is showing #value! error right from the start. Is it possible to use a lookup function for a list with more than 5000 items? Strangely, I have another list which has more items than this one, I'm able to use the lookup to that list. What am I doing wrong?


1 reply

Badge +4

did you fixed? i have same problem..

Reply