Skip to main content

Our environment uses SP2016 on premise - we have one team time off workflow that has been working just fine for a very long time. Just recently a new employee was hired by the organization and he has the same name as one of the users of this particular workflow. Since then the "Employee1" immediately gets an error message -"The workflow could not update the item, possibly because one or more columns for the item require a different type of information"- as he tries to submit a time off request. Not sure where the issue is, since the workflow is heavily used and works perfectly for everyone except for "Employee1" since "Same-Name-Employee2" joined.

24659iB1F3FD8FC99B78E4.png24660iF6D1C6D1B4A404C9.png

 

any ideas please?

It could be any number of things, but typically with the error you're seeing either the data being fed to a column is empty or is of a type that it cannot convert into the type that it wants for the column in question. 



 



Without more details it's difficult to say how to solve it, but I would start by creating a little test workflow that sends an email to yourself. Specifically I would create (2) Single Line Text Variables to hold the name values we get from User Profile Lookup:





 



Then just make two Query User Profile Actions, and configure them to get the "Name" property:





(Note: you will need to select the property "Name" first, and then click the Add button to enable it)



 





Afterwards select a variable from the dropdown, then save.



 



After you've done that, make the Send Email action to send to yourself and pull the variable data in via reference:







 



The final workflow would look something like this: 





 



 



Once you run the workflow you should be able to at least see that both users are returning *something* back to you. If they aren't, then it would be time to check AD stuff (or to run the jobs for your User Profile Service to pull in fresh data from the AD server). No matter, you should be able to use this workflow to at least check whether or not your changes elsewhere are affecting how sharepoint is able to pull in these user's names. 



 


I've ran multiple variations of your suggestions with no issues. It puzzles me that the workflow pulls all correct originator information except when updating the Title of the msg to the manager.





The fact that the issue started after same-name-employee2 joined the org makes me think this issue is related to AD stuff. I wanted to check other's perspective  and see if I have missed something before engaging the AD team


Reply