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? – Ganesh Sanap Dec 15 '20 at 13:56
  • Sharepoint online with office 365 – neha Dec 15 '20 at 14:21
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 '20 at 8:54
  • If my anwer helps you, please accept it :) – Michael Han_MSFT Dec 16 '20 at 8:57

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.