I'm facing problem in copying multiple fields value from one list to another list using SharePoint designer workflow.
There are multiple fields that I want to update in another list.
This is what I want to achieve:
List A acts as a change request form to change fields of list B after approval.
List B acts as the database.
I have these fields in list A - lookupID, description, level, status (text), changed expected date(date only column), dependency (text), reason/comments(text).
I have these fields in list B - ItemID, status (text), expected date(date only column), dependency (text), reason/comments(text)
I'm able to promote only any one field from list A to list B. And, if I write another condition to update another field the workflow fails.
Before promoting each field I want to make a check that if list A item is approved and, say, status column is not blank then only update status field of list B.