I have a SharePoint list which have two columns named Province and Hospital, Province is a single text column and Hospital is a lookup column.
The request: When Hospital is empty, Province must has value.
For now, I tried to create another single text column Hide_Hospital and using the Json formatting with below Json to get the value of Hospital.
And then use formula in validation settings with below formula:
But when I create a new item in the list, the validation was did before getting the value of Hospital, is there any suggestion here?