You’re offline. This is a read only version of the page.
65
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!
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!
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)
#1
mmbr1606
22
Super User 2025 Season 1
#2
stampcoin
19
#3
Michael E. Gernaey
15
Super User 2025 Season 1
Share
Report
All responses (
Answers (
