I want to achieve the following: we have a lot of report files which i want to publish with sharepoint for the users concerned. The files have a fixed filename pattern
So i made a workflow to extract year, month, type and the name to fill the respecting columns with data. All the names are already in Active Directory and if i set the column name through the workflow returning my variable as display name it works. Unfortunately it only works sometimes with files for the same user -> same name. For instance if i upload 5 files for the same user from different months only the workflow from one of the files terminates properly for the other files i would get an error saying that at least one column expects another type of value.
I have already narrowed it down to the error being thrown by the column containing the name (column type person). But the workflow works on other files following the exact same name pattern where also the resolution of displayname from AD works because i see the initials and email set in AD. I already made another workflow to log the values of each field and they seem fine even a check if the user is a valid sharepoint user returns true if i pass the name as displayname.
I'm clueless where to look next, Your help is greatly appreciated!