jackjen
Novice

Nintex Forms Max ID with lookup formula

Hello All,

I have been trying to get last record from a sharepoint list in the Nintex Forms (the maximum id based on a column as filter). I have used :

lookup("List","ID",max(lookup("List","Item Child Count","0","ID",true)),"ColumnYouWantOnPreviousItem") based on this solution by Nintex

-The function requires a number type parameter

-The function requires a string type parameter. Do you have any solution for that or any workaround?

Thank a lot

hdo box

0 Kudos
Reply
5 Replies
MillaZ
Community Manager
Community Manager

Re: Nintex Forms Max ID with lookup formula

@Cheyanneong Could you perhaps assist here?

0 Kudos
Reply
Cheyanneong
Nintex Analytics Expert
Nintex Analytics Expert

Re: Nintex Forms Max ID with lookup formula

Hi, this question is not relevant for Nintex Analytics, I believe this is a question for the Workflow Automation team. I would recommend you post this in their forum instead and someone will be able to assist you.

0 Kudos
Reply
Cheyanneong
Nintex Analytics Expert
Nintex Analytics Expert

Re: Nintex Forms Max ID with lookup formula

@SeeDee could you please take a look at this and see if you are able to assist, thanks.

0 Kudos
Reply
SeeDee
Nintex Employee
Nintex Employee

Re: Nintex Forms Max ID with lookup formula

@sid Hey Sid - can you please help here? thanks

0 Kudos
Reply
sid
Nintex Employee
Nintex Employee

Re: Nintex Forms Max ID with lookup formula

Hi JackJen

 

I would like to understand your use case a bit better to attempt to give you a better solution.

 

Looking at the formula that you have created, the reason you are getting those error messages is because:

 

- the inner "lookup function" is expecting a number, so instead of "0", try using just 0

lookup("List","ID",max(lookup("List","Item Child Count","0","ID",true)), "ColumnYouWantOnPreviousItem")

- Similar to that the outer "lookup function" is expecting the inner lookup function to return data of type number, but a lookup function always returns a text value. So to make this work the value out from the inner lookup would need to be converted to number data type.

 

In the post you have mentioned a Nintex Solution, would you be able to point me to that as well?

 

Thanks

 

0 Kudos
Reply