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

  • 10 January 2020
  • 4 replies
  • 3 views

Badge +3

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.


4 replies

Userlevel 4
Badge +12

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.

6119i3413FBA621AC075B.png

Best regards

Enrico

Badge +3

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!

Badge +16

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
Badge +3
Yes! I had to winnow out the workflow variables - trick was two different collection types. Thank you!

Reply