Hello Team,We need your assistance with implementing a validation requirement in SharePoint.Requirement details:We have a Holiday Calendar list in a SharePoint site where holidays are maintained with Start Date, End Date, and Holiday Name. There is another SharePoint list called Electronic, which uses an Nintex form In the Nintex form, there is a Date field where users select a date.Expected behavior: When a user selects a date in the InfoPath form:The system should validate the selected date against the Holiday Calendar list. If the selected date falls on a holiday (between Start Date and End Date), a popup message should appear informing the user that the selected date is a holiday. how to achieve this in Nintex

Question

Integrating Holiday calendar into Nintex form

Hello Team,

We need your assistance with implementing a validation requirement in SharePoint.

Requirement details:

We have a Holiday Calendar list in a SharePoint site where holidays are maintained with Start Date, End Date, and Holiday Name.
There is another SharePoint list called Electronic, which uses an Nintex form
In the Nintex form, there is a Date field where users select a date.

Expected behavior: When a user selects a date in the InfoPath form:

The system should validate the selected date against the Holiday Calendar list.
If the selected date falls on a holiday (between Start Date and End Date), a popup message should appear informing the user that the selected date is a holiday.
how to achieve this in Nintex