I have a list in which it is possible for one item to be related to another list item in the same list. I am trying make a column in the list which would contain a hyperlink to the related list item. The primary column is called Bill Number,
and the secondary column is Companion Bill Number . The Companion Bill Number is the one I want to be a hyperlink to the list time in which that number is the primary Bill Number. (hope that made sense!).
I thought I could create a hypertext link out of the Companion Bill Number dynamically in a workflow action that runs on item creation. I tried this by using the string builder to create a string for the hypertext link that I set to a workflow variable.
It looks like this <a href="listURL.aspx?ID=[%Bill:CompanionBill%]">[%Bill:CompanionBill%]. Then in another action in the same workflow I tried to set the CompanionBill column to the variable value.
What I ended up with was, instead of the number as a hyperlink, the text in the column reads as [%Bill:CompanionBill%]. I'm thinking this is failing because of the workflow process doesn't have the value of CompanionBill at the time I am asking it
to set the variable value.
Any ideas on how I might make this dynamic link creation work?
View Complete Post