So I'm having quite a big problem here. I'm trying to create one form for one user to fill out, as soon as the form is finished, copy that data to a second form, email the user specified in the first form and allow them to continue editing the second form. Basically an on-boarding system for our employees.
The problem I'm having is that the system keeps adding formatting whenever I copy something over. I'm trying to make the form idiot proof, so I created a drop down and filtered it to all the emails in the company. However, when it copied the email over to the second list it would add some data at the beginning, for example. "JohnDoe@mycompany.com" became "12;#JohnDoe@mycompany.com" or something along those lines which, of course, fails in sending the email properly.
I tried changing this to a name lookup that would then become an email lookup based upon that name, but it's the same problem, it adds a number, semi-colon, and ampersand to the name when I copy it from a drop down, which, again, fails in creating a proper lookup for the email address.
I've tried doing an extract substring from text, but that relies on knowing exactly where to extract and the number can be one digit or two making that useless.
How can I go about using a drop down that looks to a lookup on our Sharepoint site and have that copy over without it pulling over more data that messes up the workflow.