I have a list "A" with many columns. One column is "Departments" that is a lookup column and allow multiple values. After save the item, I want to copy each value of "Departments" to another list "B" with 2 columns 'BID' and 'Dept'. Can I do it in SharePoint Designer Workflow?
Departments: Math; Bio; Engineering
I was thinking to extract 'Departments' first, then do a loop to save each one in the list B. I'm not very familiar with SharePoint Designer Workflow. How to extract lookup column? How to do a loop to save the data to list B?
Appreciate for any suggestion!