Is it possible to query an Item with two or more conditions in OOB Update List Item WF Step

Question

In SharePoint Designer 2010, in Workflows, is it possible to give more then one condition when querying items? Let me explain, it is fairly easy to drop Update item in this list step, and say, for example, Update item with ID X. However, if is it possible to do something along this lines with OOB steps, Update an item in this list where Title is Equal to "abc" and Modify date no older then 3 days.

Update: Workflow is started when the item is added to the list. What I would like is to update some fields on this item depending on information in this item and in external list. For example

• Current Item Field 1 has value "abc"
• Current Item Field 2 has value "123"
• Current Item Field 3 has value "456"
• External List has Item with value in Field 1 "123"
• External List has Item with value in Field 2 "abc"
• External List has Item with value in Field 3 "xyz"
• Update Current Item Field 3 with value "xyz"

In short I would need following query - Update Current_Item_Field_3 with value from External_List_Field_3 where Field 1 is equal to Current_Item_Field_2 and Field 2 is equal to Current_Item_Field_1

Answer 1

This would be tricky with modified date, you would need 2 workflows.

Here is an example of something I did recently using 2 fields.

There was 1 list where you selected a 'Certification' and a second list which had a number of 'Vouchers' for that certification. I wanted to select a voucher for the specific certification type and make sure it was active.

So what I did was:

On the 'Voucher' list I have:

-Certification Type (Tableau, Cloudera, Etc) -Status (Active or Inactive) -CertificationStatus - A calculated field which concatenated the two fields above.

Then when the first list runs and queries the item. I concatenate in the selection in SPD and have it look for [Certification Type]+"Active" then I mark it inactive in the workflow so the next run pulls a new voucher off the top.

It's not 100% the same but it's an idea of how to query based on 2 fields, use a calculated field. If you need to use a date field, you might need to use a workflow on list2 to calculate the date first.

Answer 2

You need to add the if statements in a sequential order, and if the IF statement is TRUE, you manipulate a variable.

Set variable to FALSE
IF Title is equal to ABC
  Set variable to "TR"
IF Date is less than Today
  Set variable to "variable + UE" (use Fx)
IF Variable is equal to "TRUE"
  Update List Item
Else
  Log to history list "Item was not updated!"