I have a form that creates
.docx files from a form / word template.
- Firstname = Joe
- Lastname = Dirt
Then a file is created "Joe Dirt - New Hire.docx"
I like to find a way to get the first letter of the file "J" to then be able to move it to one-drive folder based on the Letter. So move J files to J folder.
I have my SharePoint document viewer all setup to file the Directory Tree "A-Z" Just cant get them in it.
I tried the variable sub string but couldn't get it right.
Anything helps. Thank you.