cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Not applicable

custom action to loop through a different list and check dates.

I have a calendar list which has columns like start date and end date and location and have another list by the name Holidays which has a date of the holiday, location etc

I have a item level workflow assigned to the calendar list. Now when an item is entered in the calendar, it should loop through all the items from the holiday list and then for each item in the holiday list will be checked to find if it is in between start and end dates.

Could you please let me know which custom action could be suitable for this situation and how can i achive that

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

Re: custom action to loop through a different list and check dates.

Look at the query list action for this and query the holiday list. You will also want to consider a collection action as well to manipulate any results of that query.

You might find this tricky because you are doing comparisons, so I would simplify it, try to figure out how to return the holidays that are between those dates, and then use that value(s) as needed.

0 Kudos
Reply