Copy values from 'Lookup' Custom field to 'Text' Custom Field (new) RRS feed

  • Question

  • Hi,

    We had a been using a custom field with lookup, there are around 2000+ PWA projects that use that field.
    However we have a requirement to change this filed to a text field. In this process we will need data from old Lookup type custom filed to be copied in new 'Text type' custom field.

    It is very tedious to do this one project after another. Is there any faster way? 

    Wednesday, October 25, 2017 12:34 PM

All replies

  • My suggestion is to write a PowerShell script to loop thru all the projects and tasks to perform the copy to new field.

    Also check with FluentPro software,  they have built quite a few tools for various situations.  If they dont have it, they may build it, if they think there is some demand for it.

    Michael Wharton, MVP, MBA, PMP, MCT, MCTS, MCSD, MCSE+I, MCDBA
    Blog contains my field notes and SQL queries

    Friday, November 10, 2017 4:20 AM