Skip to content

CRM 2013/2015 Workflow uses nbsp instead than space while concatenating fields

January 13, 2015

I thought I share, since this took some time to investigate.

  • I have a “Full Name”, “Last Name” and “First Name” fields
  • I have a workflow that is triggered on Last and First name changes
  • The workflow updates “Full Name” by concatenating First and Last with a space between
  • In the Quick Find View, I am including “First Name” and “Full Name” as search field.

All works, until you try to search. If you have “John Smith” and you search “John” or “Smith” you get a hit, but when you search for “John S” you get nothing. This drove me CRAZY for a week, until, by exporting to Excel, I was able to see that the space that was inserted by the workflow was not a space at all but a nbsp, and that does not match “space”.

There are many solutions to this problem, but they all have drawbacks. I should also note that this behaviour only appeared in CRM 2013/2015 and in the olden times it was possible to concatenate fields in workflows with spaces in between. I suspect that this is a side effect of a bug that was reported in this very forum (workflow was stripping all spaces).

Forewarned is forearmed.

No comments yet

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s

%d bloggers like this: