Good afternoon,
I wonder if anyone could please help. I have an InfoPath list form and a text box which using the User Profile Service returns the staff's full phone number. I have used Value[Name = "WorkPhone"] which is returning the right result, but what I'd like to do is only return the last four digits which would be the extension number. Would someone be able to help with the formula.
Many thanks