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?
