I'm new here and I have a simple question. I have a list with a column "StoreNr" (type = text) und another column "Store" (type = lookup). The list has over 4000 elements and I need a Nintex workflow, which copies "StoreNr" (text) to "Store" (lookup) --> see picture:
All values in "StoreNr" exists as elements in the lookup list.
I tried "Update multiple items" workflow task to solve the problem ...... without success. If the destination is a text field, the copy succeeds. If the destination ist a lookup field, the copy fails ... destination keeps empty.
Is there a simple solution for this issue?
Thanks for help ...
Solved! Go to Solution.
It sounds simple, but it takes one interesting Update Item action. To do this, build a site workflow (can be a list workflow, but you could accidentally run this a lot of times, which can be bad.) In the workflow create two variables, a collection variables to store IDs in, call it colIDs maybe. A number variable, currentID. Add three actions, Query list, For Each, and in the For Each, add Update Item.
So what this trying to do is loop through all the items in your list to update, and fetch the ID values of the lookup item to update each item one at a time. You have to loop in this way to get the unique values of each storenr per. The lookup back to the lookup list is to get the ID of the item, which is necessary value to put in the lookup Store field. Run the Site Workflow once and the items should update.
It is kinda crazy, but let me know if it doesn't make sense.
it makes really sense .... thank you very much for your quick answer. Here is the result:
You solved my problem. Thanks for your time and know how.
Useful Stuff. Thank You. My problem is advance! what if i want to query multiple libraries and update value in each library from StoreNr" (text) to "Store" here in this example.
I have created master list which stores all lib names and GUID's. Query- GUID Coll and stored in varGUIDunique. for each GUID (Lib) i want the fld Store to upadate with StoreNr value.
Thank you for help in advance!