Multiple sharepoint list column validation in list settings

Question

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.

Michael Han · Accepted Answer · 2020-12-16 03:15:35Z

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.

answered Dec 16, 2020 at 3:15

Michael Han

5,2411 gold badge9 silver badges12 bronze badges

1 Answer 1