I need to copy Sharepoint item list to the same list, without making any change (exept itemID ofcourse). I'm using Nintex Workflow 2013.
I have followin Sharepoint Library with following columns:
ItemID, ItemName, ItemType (drop-down menu), ItemRecivingDate (Date), CostumersName (LookUp filed with multiple selection), RelatedSellers (LookUp filed with multiple selection), Price (number),ItemDescription (Text).
I made workflow:
Create New Item
every field in new Item = field in selected item
Then, I'm running manually this workflow on the item I want to copy and getting this error:
The workflow could not copy the item. Make sure the source and destination lists have the same columns and column settings.
It's wrong, because I'm working on the same list, so all columns and column settings are the same. I've checked this issue and find out - when I'm removing CostumersName and RelatedSellers columns from the Workflow - everything working fine, so, as I understand, the problem is in LookUp field.
I'd like to get advises how to fix this problem, so I'll be able to copy item.
Thanks in advance,
Solved! Go to Solution.
By any chance, do the CostumersName and RelatedSellers get their values from another list? I'm wondering if that may have something to do with the problem. Another possible work around is to create the item without those fields and then come back in a later action and fill those 2 columns. I'm pretty new to all of this so these are just ideas to investigate.
Of course they get values from another lists, that's the point of LookUp field. But all list on the same site.
Few more things:
Values of СustomersName and RelatedSellers - I have two more SharePoint list, Customers and Sellers.
In Customer list I have next fields: CustomerFirstName (Text), CustomerSecondName (Text), CustomerWork (Text), and CustomersName (Calculated field - "&[CustomerFirstName]&" "&[CustomerSecondName]&" "&[CustomerWork]&").
Same thing about RalatedSellers - I have Sellers list with fields: SellerName (Text), SellerLocation (Text) and RelatedSellers (Calculated field - "&[SellerName]&" "&[SellerLocation]&").
May be there is a problem because of lookup on calculated fields?
Thanks in advance,
Does your calculated value return result , is it the formula you are using
=&[CustomerFirstName]&" "&[CustomerSecondName]&" "&[CustomerWork]&
It should be
=[CustomerFirstName]&" "&[CustomerSecondName]&" "&[CustomerWork]