Answered

Dataverse Cleaning Data

(0) Share

Report

Posted on by takolota1

4,978 Moderator

Is there any good way to ensure automatic clean data in Dataverse?

For example, I want to ensure there are no spaces in an email column or no spaces/dashes/parentheses in a phone colomn so I can reference emails or phone numbers in a flow's filter query without user errors in email addresses or phone numbers messing up the query. I don't immediately see a good input mask option.

A simple work-around would be to have a calculated column that trims or replaces spaces in the email column. But of course, Dataverse is completely lacking there too.
How does Dataverse not have the most basic functions like TRIM() or SUBSTITUTE() in calculated columns?

Does anyone know a better way to automatically maintain a clean set of data for things like this?

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Verified answer

takolota1 4,978 Moderator on at

Like (0)

Report
Copy link

Link copied!

Looks like email columns automatically have leading and trailing spaces removed. And there is a way to create a work-around input mask by writing a conditional for each symbol or key you don't want in your input and triggering an error message if the field contains any of those keys. However, the conditionals do not allow spaces, so you have to create a calculated column with its action set to " " and check if the field contains that space column in the business rule conditional.

This is another instance where I can create a workaround for something in Dataverse, but it always seems to take 3-4 more steps then should be necessary.

Note: Looks like you also have to make sure any columns used in any business rule conditional are also on the form. So if you use a Space column that's set to " " by default, then you have to include it on the form and hide it for the business rules to work.

Was this reply helpful? Yes No
takolota1 4,978 Moderator on at

Like (0)

Report
Copy link

Link copied!

Oh nevermind. Now the business rules suddenly stopped working.

Why is Dataverse & Dynamics so bad?

Was this reply helpful? Yes No
takolota1 4,978 Moderator on at

Like (0)

Report
Copy link

Link copied!

Looks like you also have to make sure any columns used in any business rule conditional are also on the form. So if you use a Space column that's set to " " by default, then you have to include it on the form and hide it for the business rules to work.

Was this reply helpful? Yes No