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
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.