Unanswered

Using SharePoint Power app, How to add custom validation on List Form

(0) Share

Report

Posted on by Vivek

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

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (0)

Community Power Pla... on at

Like (0)

Report
Hi @Vivek,

There are several ways to implement that. Take a look at the following example:

Create a EditForm:

When you connect to the SharePoint list and add the fields they create 4 controls in the data card:
DataCardKey for the label, DataCardValue for the input, ErrorMessage for displaying error messages, StarVisible for * icon if it is required.

You can use the ErrorMessage control to display your custom error.

First unlock the datacard so that you can edit its properties

Now in the ErrorMessage under its Text property enter a function like this:
If(Left(DataCardValue3.Text,9) = "Project -","","Project must start with Project -")
It will check if left 9 characters are equal to Project - if they are then no error messages if they are not then error message.

You have to also put a function on the Submit button to not submit if the string does not contain Project -.
Under button OnSelect property put the following function:
If(Left(DataCardValue3.Text, 9) = "Project -",SubmitForm(Form1))

This will allow to submit only if the user input contains Project - at the start.

However this will always display the error message even before the user starts to enter an input. If you want to display an error message only after the user clicks the Submit button replace the ErrorMessage Text function to the following:
If(Left(DataCardValue3.Text,9) = "Project -","",ErrorMessageVariable)

And the Submit button OnSelect function to:
If(Left(DataCardValue3.Text, 9) = "Project -",SubmitForm(Form1),UpdateContext({ErrorMessageVariable:"Project Name has to start with Project -"}))

This way the error message will be only displayed after user entered the input and clicked submit, the form will not submit if it does not contain Project - and will display the error next to the field.

When you launch the app and enter some random text:

After clicking the button, the form will not be submited but the error message will display:

Hope it helps!

Was this reply helpful? Yes No
v-micsh-msft on at

Like (0)

Report
Hi @Vivek,

We could write formula to check the Title field, if the Text Inputed is not start with "Project-", show the error message and have the Save Button disabled.

Formula and the corresponding property should be set:

1. For save Button, change its Disabled property with the formula below (DatacardValue8 is the textinput box for the Title field):

If( StartsWith(DataCardValue8.Text,"Project-"), false, true)

2. UnLock the Title field DataCard through Advanced tab under the right pane, then insert a Label control, put it besides the Ttile DataCard key, configuring the following property:

Text property: "Please start with 'Project-'"

Color property: RGBA(255,41,43,1)

Visible Property: If(StartsWith(DataCardValue8.Text,"Project-"),false,true)

Doing it in this way would remind the user to enter the Title to stat with "Project-", if not, the Label with the red remindings would not be hidden, and the Save Button would be disabled.

Only when the Text is start with "Project-', remindings would be hidden, and the save button would become available.

Function reference:

StartsWith function in PowerApps

For Validate function, it uses the restriction from the data source side, if you have configured the restriction from the SharePoint side (For the title field to start with "Project-"), then this function should be OK to replace Startswith function.

Regards,

Michael

Was this reply helpful? Yes No