Easy Workflow - Setting a field value from an existing field for multiple items

[MikeCrawford]

I need to set a text value based on another field for approximately 2000 documents in a library which all have folders on folders on folders.

I don't know what is better - make a Site Workflow to update multiple items? Make a Library Workflow and try to trigger it on a schedule? Unfortunately I can't use quick edit to copy paste because of all the folders.

Basically, I need to take ColumnA -> txtColumnA for all 2000 documents. This SHOULD be easy, but I'm stuck! Any help would be appreciated.

[praios81 · Accepted solution]

Hey Mike!

I'd go with a site workflow, that queries all items from your library (which will include all files in all folders) iterate them by ID and update the item with your column information.

Best regards

Enrico

[MikeCrawford]

Thank you, Enrico!

Looks to be a good solution. I haven't been able to get it to work right, but I'll keep at it. Thank you!

[cassymfreeman]

you might have issues because of the number of items you have.  you could

• have a list with the old value in one column and the new value in another column
• have a site workflow that gets all old values into a collection
• for each
  • look up new value
  • utilise update multiple items action

[MikeCrawford]

Yes! I had to winnow out the workflow variables - trick was two different collection types. Thank you!