Integrating Holiday calendar into Nintex form

Hi ​@Pavithra Mani,

Can you please clarify the platform you are using?
This post is in Nintex for SharePoint, which is for on-premise Nintex, but you have tagged the post with Nintex Automation Cloud. The solution most likely will be different depending on which platform you use.

we are using Nintex automation cloud for SharePoint online

Hi ​@Pavithra Mani,

There are many ways to achieve this solution; it all depends on how complex you want to get.

The easiest way is to add a validation rule that checks if the date chosen is between certain dates. You could have one rule for all holidays or a rule per holiday so that you could customise the validation message for that particular holiday. This does not use your SharePoint list of holidays, though.

 

Next option, you could use a data variable to look up the dates on your SharePoint list.  You feed this into a collection contains function that compares the collection of dates to the date entered into the date time control.  You will need to format the date to match the format of the dates coming from SharePoint. This will output a boolean true or false, which you could then use to either display a message or disable the submit button, etc.

The formula would look something like:

collectionContains([Table data].[holidays].[Rows].[Date],convertToString(formatDate([Form].[Datetime 1],"YYYY-MM-DD")))

Nintex does not do pop-ups by default, so you could use the JS-Insert plugin from the Nintex Gallery to trigger a pop-up: https://gallery.nintex.com/t/js-insert

Or check out this plugin I developed a while ago, which uses the sweet Alert library for custom popups.
https://github.com/Smuntz/Sweet-Alert

Thanks for the information. But we are trying to upload the holiday dates for the 5years, so it will be tough to create the rule for the upcoming 5 years.
The second option how can i insert inside form SharePoint lookup. can you show me

Hi ​@Pavithra Mani,

Please see the help file regarding data variables.
https://help.nintex.com/en-US/nwc/Content/Designer/FormsExternalData.htm