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 / Required dataverse fie...
Power Apps
Suggested Answer

Required dataverse fields in Dynamics free to be blank, but required in power apps form

(1) ShareShare
ReportReport
Posted on by 25
Hey,
 
I'm running into a problem of designing a simple power app that helps create price list items (default Dynamics 365 table). The Dynamics 365 sales environment is not great for this and it was requested to have a separate power app for adding existing products to a price list (which is a price list item). 
 
Not very special if you look at the Dynamics form so I started out rebuilding it, but I ran into problems with required fields. I understand them, but I don't understand why some fields are not required in Dynamics, but are in Powerapps while it's the same required dataverse field. I'm specifically referring to the 'rounding policy, option percentage' fields. They are locked and not required on the Dynamics default form as shown below: 
 
 
I thought they might be automatically populated by some backend script, but if I look at the dataverse table they seem really empty: 
 
However, in my powerapps form it fails to submit without these fields / a value. I tried using 'blank()', but that does not work either. We do not use any of these options and my powerapps form now becomes I mess because I have to add all these fields, set some kind of default value and hide them. Is there another way to deal with this? Am I overlooking something? 
 
Thank you very much!
I have the same question (0)
  • Suggested answer
    Michael E. Gernaey Profile Picture
    53,969 Moderator on at
     
    My guess is they are in fact required but since they are locked they are auto populated.
     
    If you do not plan on them populating them in the App, Remove them, or click on them, select the Properties window on the Right, Click Advanced, Unlock them and populate them.
     
    I would also, for yourself, go to the Table itself in the Solution or just under Tables on the main screen in Power Apps.com and see for yourself that they maybe locked, but are probably business required.
     
    How are they populated?
     

    If these suggestions help resolve your issue, Please consider Marking the answer as such and also maybe a like.

    Thank you!
    Sincerely, Michael Gernaey
  • JollyDodo Profile Picture
    25 on at
     
    Thank you for your reply. They are not auto populated as shown in the second image. this image shows a screenshot of 5 records from the ootb price list item entity where the 'rounding' fields are empty. 
     
    I found out that Dynamics unified apps apparently allow for this when you lock the field. Seems a weird choice to me to allow for this, but to also make these ootb managed fields required.
     
    Manually patching or changing the display mode to view/disabled to simulate the unified interface trick doesn't seem to work either. I don't want to create a custom entity since the sales app / field service app are heavily reliant on the default pricing implementation. 
  • Ram Prakash Duraisamy Profile Picture
    5,714 Super User 2026 Season 1 on at
     
    2. Choose your Environment
    3. Select Apps
    4. Select Tables
    5. Look for your Tables
    6. Open the Tables
    7. Select Columns
    8. Open it and Make sure it is not Business Required.
     
    Please mark as answer if my suggestion helps.
    Subscribe here for More Useful videos : https://www.youtube.com/@rampprakash3991
  • Suggested answer
    Michael E. Gernaey Profile Picture
    53,969 Moderator on at
     
    So these columns are required, they just happen to also be locked on the default form.
     
    You cannot leave them blank. The issue you are running into is because in your Sales system is in fact running a rule/business rule/work flow/plugin.
     
    However, this is only triggered when you do this in your Model Driven App, as this is not happening or triggered from your Canvas App. I had to look at the Table you were talking about. 
     
    By default these are read only unless certain value types are selected.
     
    Please read this
     
     
     
  • Michael E. Gernaey Profile Picture
    53,969 Moderator on at
     
    Any response to my answer? If it resolves your issue please mark as such.

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Congratulations to the March Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
11manish Profile Picture

11manish 530

#2
WarrenBelz Profile Picture

WarrenBelz 459 Most Valuable Professional

#3
Haque Profile Picture

Haque 314

Last 30 days Overall leaderboard