Lookup Function with condition to match with other types

[Murtuza_Masalawala]

Hello,

I am unable to Lookup on an Integer Column in Data Entity with an integer value. It returns a Blank even when the record is present. Do the Lookup/Filter functions work only with String Types or am I not doing something right. Help would be appreciated. Thanks!

[Arvind_Kumar1 (Arvind Kumar)]

Can you try with one filter first and see if you are getting result back?

[Murtuza_Masalawala]

Yes, with one filter it worked as it is looking up a variable value which has been populated by a previous lookup of a column which is an integer column.

Using variables it works for multiple filters. In mu case I have to add 1 to the current level, eg if current user role level is 1 then the approval has to move to the next level, so I am adding 1 to the current variable and then trying to look up the user key for that level, that fails for some reason. Hope I am making sense.

[Arvind_Kumar1 (Arvind Kumar)]

Are you passing correct value into filter? I am sure something is not passing so it’s returning null.

[Murtuza_Masalawala]

Passing a static value of 1 = Lookup(Table,[IntCol,“=”,1]), is 1 considered as string or integer here ?

[Arvind_Kumar1 (Arvind Kumar)]

This will consider as integer.

[Murtuza_Masalawala]

Thanks Arvind, you rock.