2

I am new to SharePoint and Power Automate. I have to put multiple conditions in SharePoint list validation settings.

Example:

=IF(ISBLANK([Unit Amount]),TRUE,[Unit Amount]=[PO Amount])

Which would validate Unit Amount against PO Amount if Unit Amount is not blank.

Similarly I need to validate few more columns before someone hits save.

Example:

=IF(ISBLANK([SP]),TRUE,[SP]=[MP])

How can I concatenate these conditions in the list settings - Validation settings.

Preferably, I required different messages for each validation but I figured that would not be possible.

2
  • Which version of SharePoint you are using? Dec 15, 2020 at 13:56
  • Sharepoint online with office 365
    – neha
    Dec 15, 2020 at 14:21

1 Answer 1

1

Just use AND function to concatenate multiple conditions. For example:

=AND(IF(ISBLANK([Unit Amount]),TRUE,[Unit Amount]=[PO Amount]),IF(ISBLANK([SP]),TRUE,[SP]=[MP]))

Besides, in list validation settings we can only have one message.

2
  • Thankyou. This worked.
    – neha
    Dec 16, 2020 at 8:54
  • If my anwer helps you, please accept it :) Dec 16, 2020 at 8:57

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.