New answers tagged workflow-variable
@Chaholl's answer is correct but if you need, as was our case, the url value from a field in the lookup item, this won't be sufficient as it is not exposable under "additional fields", as are some other field types. In this case you would need what you are suggesting yourself, a workflow: that runs whenever an item is created or updated that copies you ...
One way to do this would be to have your multi-column lookup list stored as a separate list in SharePoint (Maybe you already have that I'm not clear). When you then add a lookup column to your 'main' list that refers to this lookup values list you can select which additional fields to include. You could, for example, include Name and Age. When including ...
I'm assuming CASAMT2 is a workflow variable. Make sure it is type 'number'. When you are setting the variable, what are you selecting for the 'Return Field As' option? You should select 'Double' or 'Currency' if either of those are available.
Top 50 recent answers are included