cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
hardy-liu
Nintex Newbie

Use lookup can not output data filter on Number

Jump to solution

I use lookup to get data from List Part. 

When I use the below formula to display Description data from List Part. I find the below problem.

Formula Builder

lookup("Part","PartNo",PartNo,"Description")


I could get result when I  input string like "ssss" , But can not get anything when I typed number like "00010"

 

List Part:  column PartNo is Single line of text

   

Tags (1)
0 Kudos
Reply
2 Replies
hardy-liu
Nintex Newbie

Re: Use lookup can not output data filter on Number

Jump to solution

UseRyan Duguid‌ provide 

lookup("Part","PartNo",toLower(PartNo),"Description")

 I remove the "0" before the number, this formula is working. in production environment, all PartNos do not start with 0

Reply
cyclonereverb
Nintex Newbie

Re: Use lookup can not output data filter on Number

Jump to solution

Been working on getting this to work for hours now. Thanks for providing the toLower solution

0 Kudos
Reply