I have a series of Drop Down lists linked to another SharePoint List. The select of the "2. Select Sub-Program" is then required to hide or display other panels. The issue I have is that the actual returned value e.g. 6;#Communication (Stakeholder) is not what is displayed in the list. I tried by using substring BUT becuase the prefix value is comes 1 chr (6;#) and then in other cases "14;#" I cannot return the value I need.
Is there any formula similar to substring after that will allow me to return the values after the #/
Solved! Go to Solution.
When refering to the pull-down control in a Calculated Value control use the parseLookup function - which will remove the ID No, semi-colon and hash-mark.This will give you a value to use as a filter, and/or to save out into SharePoint.
Hi Michael Campbell,
Returns the text component of the list item in the lookup control if condition evaluates to TRUE. If FALSE, returns the ID of the list item in the lookup control.