2

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

  • I found this article, meybe help you to achieve it – Melad Francis May 24 '17 at 11:41
  • I guess you are trying to save the record with name concatenate with "Project" keyword ! – cjs May 24 '17 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. – Robert Wagenaar Jun 13 '18 at 10:56
1

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

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

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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