I have two SharePoint list - One is funnel and other is decision register. If certain condition is met in Funnel for that item, it will be moved to other list Decision Register.
I have following conditions to check in Funnel list -
- If Approval Status = CPO Approved and Decision Effective date is not blank then move to Decision Register list.
- If Approval Status = CPO Rejected then move to Decision Register List.
For first condition it is mandatory to have Decision effective date whereas for second when Rejected Decision Effective date is not applicable.
I tried with following code in SD 2013 but it is not working as desired. For first condition when date is empty and Approval Status is CPO approved, it is still moving to Decision Register.
Stage:Stage 1
Step: 1
Set Variable: Decisiondate to Current Item:Decision Effective Date
If Variable: Decisiondate is not empty value
and Current Item:Approval Status equals CPO Approved
Create item in M-Milestone Decision Register (Output to Variable: create3 )
Delete item in Current Item
If Current Item:Approval Status equals CPO Rejected
Create item in M-Milestone Decision Register (Output to Variable: create3 )
Delete item in Current Item
Transition to stage Go to End of Workflow