Problem: When applying a!toJson on a record type, record fields of type user will be converted to JSON objects. When casting the JSON back to record type, it fails to convert the user object (dictionary) to User type with error: CastInvalidCould not cast from Dictionary to User.
Example
Changing the record field type from user to text would eliminate issues in JSON conversion, but it takes away the ability to use record security rules by user fields. Another workaround is to flatten out all record fields that are of type user and convert it to the username string. Does Appian have a solution for this? Peter Lewis
Discussion posts and replies are publicly visible
Like Stefan said, this is expected behavior, but can make this scenario a bit more complicated. Like Stefan said, at this point I'd recommend either having the column as text or just having some additional expression manipulation to handle this scenario.