web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Where does the Data Va...
Power Apps
Answered

Where does the Data Validation Reside in Dataverse

(0) ShareShare
ReportReport
Posted on by 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!

I have the same question (0)
  • Verified answer
    Guido Preite Profile Picture
    1,490 Super User 2024 Season 1 on at

    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)

  • JasonSealy Profile Picture
    65 on at

    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!

  • steeevid Profile Picture
    333 Super User 2024 Season 1 on at

    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

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Season of Sharing Community Challenge Launch!

Jump in, show your community spirit, and win prizes!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Congratulations to the April Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
Vish WR Profile Picture

Vish WR 414

#2
Valantis Profile Picture

Valantis 408

#3
timl Profile Picture

timl 339 Super User 2026 Season 1

Last 30 days Overall leaderboard