Answered

Where does the Data Validation Reside in Dataverse

(0) Share

Report

Posted on by JasonSealy

Hello I am having trouble understanding how Dataverse deals with Data Validation. I want to standardize my data but found it is there is very limiting ways to validate data input directly into a Dataverse Table. So I found that it is typically better practice to use model-driven apps (forms) and canvas apps to populate the tables. But I find this confusing on why you couldn't centralize the data validation for the specific table rather than having to use validation formulas for each application that will add data to a table. My summarized questions are below:

1. How does data validation in Dataverse work to standardize the data?

2. Does this have anything to do with Data independence (physical data independence, logical data independence). Data independence is a topic I have researched but have not understood?

Thanks in advance!

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Verified answer

Guido Preite 1,488 Super User 2024 Season 1 on at

Like (1)

Report

Data validation in Dataverse can be centralized using plugins (so no matter if the data entry is done by a model-driven app, a canvas app or API) . Plugins are server-side code (usually written in C# but recently you can create them using Power Fx).

Example: let's say you want the phone number always formatted with a dash every 3 digits, so if a user enters 12345 6789 0123 the result after save the record will be 123-456-789-012-3

Plugins are triggered after the record is saved, so if you want real-time validation meanwhile the user enters the data, you will need the validation you already found (javascript for model-driven apps and formulas for canvas apps)

Was this reply helpful? Yes No
JasonSealy 65 on at

Like (0)

Report

Thanks, I will look into using these plugins. I am still confused on why a database would be configured this way. I have very limited knowledge on databases but wouldn't it make more sense to have validation tied to the tables? I am wondering if there is a reason why dataverse is designed without built-in table validation.

Thanks again!

Was this reply helpful? Yes No
steeevid 323 Super User 2024 Season 1 on at

Like (0)

Report

Because dataverse is a 10 years old work in progress product and it's not starnge that it lack of basic functionality. The dev just don't care

Was this reply helpful? Yes No