Skip to main content
Nintex Community Menu Bar

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

  • January 10, 2020
  • 4 replies
  • 22 views
MikeCrawford
Forum|alt.badge.img+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

    Nintex Partner
    Forum|alt.badge.img+12
    • praios81Nintex Partner
    • Nintex Partner
    • January 13, 2020

    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

    MikeCrawford
    Forum|alt.badge.img+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!

    Forum|alt.badge.img+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
    MikeCrawford
    Forum|alt.badge.img+3
    Yes! I had to winnow out the workflow variables - trick was two different collection types. Thank you!
    Sidebar Buttons
    Nintex Community Home Contact Nintex Support Email Nintex Community Check Nintex Status
    Terms & ConditionsAccessibility statement