cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Power Participant
Power Participant

Error messages if required fields not filled.

Hi

 

I have a powerapps form connected to a SharePoint list.

I have set OnFailure = ResetForm(SharePointForm1);Navigate(FailMessage, ScreenTransition.CoverRight)

 

I have a couple of issues.

1. I dont want it to take me to the Failure screen if a required field is not filled, then i just want a notification displaying what fields the user needs to fill out.

 

2. On my Failure Screen if i add a button on the OnSelect = Back() it will actually display the information from another item then the one i was filling out. It always displays the same item if i use Back().

 

I have strugled with both so currently i have temporar removed required fields but i would like that to work as inteended to. My Failure screen is only to be displayed if errors not releated to required fields basicly.

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Community Support
Community Support

Re: Error messages if required fields not filled.

Hi @JimmyWork ,

Based on the needs that you mentioned, I think the If function could achieve your needs.

 

Within your Edit form, you could consider control the Approval field data card's visible based on the Category field value. On your side, please set the Visible property of the Approval Field data card in your Edit form to following:

 

If(
   ThisItem.Category.Value = "Access Rights",    /* <-- Category represents the Choice type field in your SP list */
true,
false
)

Then modify the formula within the OnSave property of SharePointIntegration control to following:

If(
    IsBlank(DataCardValue1.Text),
    Notify("The Required Field Column1 could not Blank!", NotificationType.Error),
    IsBlank(DataCardValue2.Text),
    Notify("The Required Field Column2 could not Blank!", NotificationType.Error),
    IsBlank(DataCardValue3.Text),
    Notify("The Required Field Column3 could not Blank!", NotificationType.Error),
IsBlank(ApprovalFieldTextInputBox.Text) && ApprovalFieldDataCard.Visible = true, /* <-- Modify formula like this */
Notify("The Required Field Column3 could not Blank!", NotificationType.Error), ... ..., SubmitForm(SharePointForm1) )

 

Please take a try with above solution, then check if the issue is solved.

 

Best regards,

 

Community Support Team _ Kris Dai
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

6 REPLIES 6
Highlighted
Super User II
Super User II

Re: Error messages if required fields not filled.

If you want the back button to take you back to the form, so the user can correct the error and submit the form then you need to remove the "ResetForm(SharePointForm1);" from the OnFailure property. 

 

If you don't want the OnFailure to trigger on required fields then you would need to add a bunch of nested If() for the required fields around the SubmitForm().

 

If(IsBlank(txtSubject.text), Notify("Please fill in the Subject", NotificationType.Error), If(IsBlank(txtMatter.text), Notify("Please fill in Matter Name", NotificationType.Error), SubmitForm('SharePointForm1')))



--------------------------------------------------------------------------------
If this post helps answer your question, please click on “Accept as Solution” to help other members find it more quickly. If you thought this post was helpful, please give it a Thumbs Up.
Highlighted
Power Participant
Power Participant

Re: Error messages if required fields not filled.

Thank you @Jeff_Thorpe 

 

I want it to trigger a notify message if required fields are not filled in.

But i want it to move to the error screen i create if it fails in other things then i want it to move to the error screen i created.

Highlighted
Community Support
Community Support

Re: Error messages if required fields not filled.

Hi @JimmyWork ,

Do you want to display a notification message when some Required fields are not filled rather than navigate to FailMessage screen?

 

For your first question, if you just want to display a notification message when some Required fields are not filled rather than navigate to FailMessage screen, I think the If function could achieve your needs.

I have made a test on my side, please take a try with the following workaround:

Set the OnSave property of SharePointIntegration control to following:

If(
    IsBlank(DataCardValue1.Text),
    Notify("The Required Field Column1 could not Blank!", NotificationType.Error),
    IsBlank(DataCardValue2.Text),
    Notify("The Required Field Column2 could not Blank!", NotificationType.Error),
    IsBlank(DataCardValue3.Text),
    Notify("The Required Field Column3 could not Blank!", NotificationType.Error),
    ...
    ...,
    SubmitForm(SharePointForm1)
)

Note: The DataCardValue1, DataCardValue2, DataCardValue3, ... represents the Text Input box within the Required field data card.

 

For your second question, I think this issue is related to the ResetForm(SharePointForm1) formula you used in the OnFailure property of the SharePointForm1.

If the OnFailure property is fired, the ResetForm(...) function would be executed, then your SharePointForm1 would be reset. In default, the SharePointForm1 would display the first item in your SP list data source, because the Item property of the SharePointForm1 has been set to following:

If(
IsBlank(SharePointIntegration.Selected) || IsEmpty(SharePointIntegration.Selected),
First('YourListName'), /* <-- In default, display the first item in SP list data source */
SharePointIntegration.Selected
)

As an alternative solution, please consider remove the ResetForm(SharePointForm1) formula from the OnFailure property of the SharePointForm1, then when you click "Back" button, it would remain the previous filled data within the SharePointForm1.

 

Please take a try with above solution, then check if the issue is solved.

 

Best regards,

Community Support Team _ Kris Dai
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Highlighted
Power Participant
Power Participant

Re: Error messages if required fields not filled.

Thank you so much @v-xida-msft 

This seems to solve evrything.

 

Im struggling a little bit with how to solve the issue of me having some fields only visible for some categorys from a choic column, if i set a field that is hidden from some users to Notify if not filled in then this message will show even if that user does not have the column visible in its form.

 

For Example.
Field: Approver is only visible if Field Category = Access Rights.

If i set Approver to be required it will display the error notifcation message because its empy but the user does not see that field if he/she does not pick Category = Access Rights

 

Highlighted
Community Support
Community Support

Re: Error messages if required fields not filled.

Hi @JimmyWork ,

Based on the needs that you mentioned, I think the If function could achieve your needs.

 

Within your Edit form, you could consider control the Approval field data card's visible based on the Category field value. On your side, please set the Visible property of the Approval Field data card in your Edit form to following:

 

If(
   ThisItem.Category.Value = "Access Rights",    /* <-- Category represents the Choice type field in your SP list */
true,
false
)

Then modify the formula within the OnSave property of SharePointIntegration control to following:

If(
    IsBlank(DataCardValue1.Text),
    Notify("The Required Field Column1 could not Blank!", NotificationType.Error),
    IsBlank(DataCardValue2.Text),
    Notify("The Required Field Column2 could not Blank!", NotificationType.Error),
    IsBlank(DataCardValue3.Text),
    Notify("The Required Field Column3 could not Blank!", NotificationType.Error),
IsBlank(ApprovalFieldTextInputBox.Text) && ApprovalFieldDataCard.Visible = true, /* <-- Modify formula like this */
Notify("The Required Field Column3 could not Blank!", NotificationType.Error), ... ..., SubmitForm(SharePointForm1) )

 

Please take a try with above solution, then check if the issue is solved.

 

Best regards,

 

Community Support Team _ Kris Dai
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

Highlighted
Power Participant
Power Participant

Re: Error messages if required fields not filled.

Thank you so much @v-xida-msft it worked flawless

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Power Platform ISV Studio

Power Platform ISV Studio

ISV Studio is designed to become the go-to Power Platform destination for ISV’s to monitor & manage published applications.

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Tech Marathon

Maratón de Soluciones de Negocio Microsoft

Una semana de contenido con +100 sesiones educativas, consultorios, +10 workshops Premium, Hackaton, EXPO, Networking Hall y mucho más!

Top Solution Authors
Top Kudoed Authors
Users online (7,299)