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.