Skip to main content

I am new to the world of Nintex so am unsure how to approach this.

I have a list which has a Status, at first it is defaulted to New. I want my workflow to change all the items that have a status of New when there created date is Today +2.

first of all, are you sure your condition should be Created == Today + 2days?

if Created is meant OOTB sharepoint's column, you will hardly find items created two days in future ....

anyway, the procedure might be like this:

- create a site workflow and schedule it to run daily

- within workflow, first query for all the items that needs to update. use Query list action and configure it like this

207505_pastedImage_3.png

so it return all the item IDs with status NEW and created == Today+2 and stores them into a collection variable.

(Note that condition on created date will likely need to be slightly changed)

here is whole CAML

<Query>
  <Lists>
    <List ID="{8BF2B7A1-A3BE-44D7-940C-FBF9EE867555}"/>
  </Lists>
  <Where>
    <And>
      <Eq>
        <FieldRef Name="Status"/>
        <Value Type="Choice">NEW</Value>
      </Eq>
      <Eq>
        <FieldRef Name="Created"/>
        <Value Type="DateTime">
              <Today OffsetDays="2"/>
        </Value>
      </Eq>
    </And>
  </Where>
<ViewFields>
<FieldRef Name="ID"/>
</ViewFields>
</Query>




‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

note: do not forget to change list ID to yours.

- then you will need to loop over collection of IDs returned with for each loop action

207506_pastedImage_4.png

- and within loop update status of current item with Update item action

207507_pastedImage_5.png

so overall workflow might look like this

207508_pastedImage_6.png


Reply