Required Field Validation Discrepancy in Power Apps/SharePoint Integration

[lorumIpsum2024]

I have developed an application for tracking inventory of motors. It consists of three main screens: a search screen, an add screen, and an update screen.

On the add and update screens, there are forms linked to a SharePoint list containing all the motor information. Each form includes a submit button, allowing users to either add a new motor to the list or submit changes to an existing motor entry. I've configured the submit buttons with a DisplayMode property set to "If(frmXXXMotor.Valid, DisplayMode.Edit, DisplayMode.Disabled)". This setting is supposed to prevent users from submitting changes or adding a motor to the list if there are still empty required fields in the form.

While this functionality works flawlessly during the preview in Power Apps, embedding the application on our SharePoint site presents a different situation. In this environment, the app fails to check for required fields in the Edit motor form, allowing users to submit changes even when required fields are empty.

I've taken several troubleshooting steps, including ensuring that the embedded app is the most recently published version and testing it across multiple browsers. However, the issue persists, indicating a potential discrepancy in how the app behaves within the SharePoint environment compared to its behavior during preview in Power Apps.

[MissingLink]

Hi @lorumIpsum2024 

Just looking at your screenshots, each of them seem to have different compulsory field requirements.  (See the red asterisks)

This indicates to me that either you have added the fields manually and then linked to a field or perhaps they are pointing to a collection (where the field are not compulsory ?   Its hard to say exactly.

To get around the problem, I'd suggest that on the Submit button, you put some code to ensure that the compulsory fields are not blank.   Something like: 

If(IsBlank(DataCardValue54.Text) Or IsBlank(DataCardValue55.Text) Or IsBlank(DataCardValue56.Text), Notify("A Field is Blank",NotificationType.Warning), Notify("Success", SubmitForm(FormNameHere)))