Checking two lists on SharePoint for date criteria

[nvargas]

I have two lists on SharePoint:

1. Blackout Dates
2. Work Items

List Criteria:

• The Blackout Dates list has a "Blackout Start" date column, a "Blackout End" date column, and a "Stage" column. (Approved, Pending, Rejected, Cancelled)
• The Work Items list has an "Execution" date column and a "Blackout?" choice column (True/False).

I want to populate the "Blackout?" column with true if the Execution date falls within the Start and End dates of an approved Blackout (Stage = Approved).

Is there an easy way to do this?

[abm]

Hi @nvargas 

First read the work items records. Add a loop to iterate all the records. Inside the loop Read the Blackout Dates list filtered by Execution Date >= Start Date and Execution Date <= End Date and Stage approved. If record count is one then update the list.

All date must be formatted to yyyy-MM-dd format using the expression. See below example.

use formatDateTime('DateColumn', 'yyyy-MM-dd')

How many records you having?