4

In SharePoint Online, I have created a simple power app on a custom List. I want to add a validation on Title Column (Start with "Project -") on Form Submission. That is, user should not be able to submit the Form if Title column value doesn't start with "Project -". User should see an error and then they should modify the Title value and save again.

I found Validate function in PowerApps link but unable to understand how to apply this to the form for my custom validation.

Please let me know how to add custom validations on list fields in Power App Form?

Thanks in advance

3
  • I found this article, meybe help you to achieve it May 24, 2017 at 11:41
  • I guess you are trying to save the record with name concatenate with "Project" keyword !
    – cjs
    May 24, 2017 at 12:13
  • unfortunately the article mentioned above does not help, because the question is about a List Form, not a normal Powerapp with SharePoint as a data source. Jun 13, 2018 at 10:56

1 Answer 1

4

You can use the OnSave event of the SharePointIntegration control for this. You can extend this event with a formula that checks if one or more conditions are fulfilled.

The steps are:

1) Select the SharePoint Integration Control

enter image description here

2) Go to the Advanced properties of the control:

enter image description here

3) change the OnSave formula (this is just an example, you can add your own formula):

enter image description here

1
  • thanks @Robert Wagenaar, you saved a lot of headaches with your well explained solution !
    – Gaelle
    May 22, 2019 at 14:14

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Not the answer you're looking for? Browse other questions tagged or ask your own question.