This is for a governance tracking list.
I have two tables: Roadmap and Roadmap Status
In Roadmap, there are two fields of interest that are lookup fields to Roadmap Status:Title they are Status and OldStatus
When an item is entered in Roadmap, I want to force the initial Status to "Submit" from Roadmap Status. I don't see any way in my workflow to to lookup that item in Roadmap Status and place the pointer (I'm assuming it is a GUID) into the field. The value
is also stored in OldStatus to catch changes as I'm trying to force order of status in a few cases but not all.
I'm doing it with a Lookup instead of Choice because the business tends to change the terminology they like and this way I don't change it in several places plus it allows them to change it in the list instead of someone changing the list field values.
I've seen several places on the forum where people have a similar problem and Lambert Qin has given an answer but it never fits this scenario exactly. Do I have to go back to Choice columns? I only have Designer and would rather not have to learn another
tool for a simple SharePoint implementation.
Thanks for any help!
View Complete Post