BC Friday Tips #27 Replace Blank Values using Transformation Rules

It’s #BCFridayTips for #msdyn365bc consultants.

💡Did you know there’s a simple way to replace blank values using Transformation Rules?

Here’s how:

➡️ Set Transformation Type to Replace by using Regular Expressions

➡️ Set Find Value to ^$

How it works:

➡️ ^ marks the start of a string.

➡️ $ marks the end of a string.

➡️ Together, ^$ identifies an empty string.

Why use it?

✅ Work out of the box. No development needed.

Share to help others ♻️ and follow Teddy Herryanto for more tips! 🚀