Using Filtered Lookup values in a Designer workflow

Jul 15, 2015 at 1:31 AM
Edited Jul 15, 2015 at 1:33 AM
This might be immediately obvious to some but it took me awhile to figure out so I'm posting it here for posterity.

I really like the Filtered Lookup but was having a problem getting it to match the apparent values in the filtered column source because each item in the filtered lookup list has the item's ID and ;# prepended to the apparent column value (but hidden from view). This results in no match when trying to retrieve another value from the source list based on the selected filtered lookup value. (eg: X was chosen, now we need to retrieve X's associated weight)

My solution was to create an additional hidden column in the source list; a calculated field consisting of the formula [ID]&";#'&[<SourceFilteredColumn>]
Marked as answer by Jess_Wundring on 7/14/2015 at 5:32 PM