cancel
Showing results for 
Search instead for 
Did you mean: 
bimi82
Nintex Newbie

check if number/text already exist in the list when submitting

Jump to solution

I know this can be probably achieved via the workflow but wonder if it can be also done on the form when submitting??

 

How do we validate if the number/text within [PONumber] already exist in the List [Item Lists], colum [PONumber] and if it does then show error message. The form is loaded from the same list where it should validate against it, to check if the number/text exist in the column!

 

I was thinking something with lookup()

 

lookup("Item List", "ID", PONumber, "PONumber")

Please advise?

Labels: (1)
Tags (1)
0 Kudos
Reply
2 Replies
nico
Nintex Newbie

Re: check if number/text already exist in the list when submitting

Jump to solution

You can can achive this with just a SharePoint field configuration.

In the settings of your field you just have to check "Enforce unique values" to Yes

 

EnforceUniqueValues.png

 

With this settings, when you will save your form, if you have already save your value, you will have an error message "The list item could not be added or updated because duplicate values were found in the following field(s) in the list: [Titre]."

View solution in original post

0 Kudos
Reply
bimi82
Nintex Newbie

Re: check if number/text already exist in the list when submitting

Jump to solution
shame there is no option to change / modify the default message to something else...
0 Kudos
Reply