Showing results for 
Search instead for 
Did you mean: 
Advocate II
Advocate II

Bug Report: Powerapps not enforcing required fields.

I've noticed something annoying with my edit forms. Even though I have a data card's requred property set to true, the form still allows the submition of blank information in that card's upload property, and then blank fields end up in my data source.


This is happenig on several different edit forms, and when using both exel tables and share point lists as data sources.


They just need to be required on Sharepoint.

Thanks Felix @FelixCuadrilla


If I wanted a Text input to be required, but only if another Text input had info in it, I would need to define that condition within powerapps. I have such a scenario and have added the releveant code.


Therefore, if it must be required at the SP list end, I would run into trouble because in reality I would only want it to be required based on a condition found with powerapps. Sharepoint would think it was always required. On the flip side, powerapps needs sharepoint to to be set at required for it accept the requirement.


Bit of a Catch-22


It is only possible then to make a field either required or not then?


What if your field was initially not required in SharePoint and now is required in SharePoint? Even if you refresh the connection this does not appear to update.

Anyone find an update to this?


I have also found that powerapps doesn't pick up required fields after they have been made required. So far, not impressed with PowerApps...I guess you get what you pay for when these tools come for basically free with O365. I feel sorry for someone who is paying for P1 or P3 when money could be spent on better forms technology.

As of yesterday there is still at least one bug related to this still in the system.

I was able to save a form with a blank required CDS field yesterday. I can't recreate it today.

Also, and this is my bigger problem, the required field setting for a field (in CDS) is not respected when doing an import.

I imported some data from an Excel file which mistakenly had blanks in some of the required fields. The import process blithely created records for each line from the Excel file, even those with blanks in the required fields.

These empty required fields created some serious issues in our downstream processes.

Since the required field flag is a property of a CDS field, not of a form, it should be respected (and fail the insert attempt) whether the data is coming through a UI form, an import, or anywhere else, its 'required'.

This is a bug.

Helpful resources

PA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

This training provides practical hands-on experience in creating Power Apps solutions in a full-day of instructor-led App creation workshop.

Microsoft Build 768x460.png

Microsoft Build is May 24-26. Have you registered yet?

Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.

May UG Leader Call Carousel 768x460.png

What difference can a User Group make for you?

At the monthly call, connect with other leaders and find out how community makes your experience even better.

Top Solution Authors
Top Kudoed Authors
Users online (3,439)