Power Platform Community Forum Thread Details

I am writing a lookup against a sharepoint list which ha more than 6000 items.

i can find items with = but not with in operatot.

i have text field that may or may not contain my text, if it contains my text it should result that item.

its not delegable, is there a workaround for this situation.

If(

LookUp(

'EMployee',

'Position Title' in Text(text1.Value)

).ID > 0,

Set(

employeeitem,

LookUp(

'EMployee',

'Position Title' in Text(text1.Value)

)

);

if i use = inplace of in that it works. but i need to do the contains search.

Categories:

lookup funciton with IN text comparison not resulting any values