acondition in valid_if

[AL_Shaikh_Real_]

I Want to Have condition in the in the field[Square] valid_if to check if the Field [Province]="Salalah" then do dependent dropdown list else show the field[Square] to the user for data entry

I have tried to use IFS() but not of my tries worked

First attempt
IFS(
[Province]="Salalah",Cities[Square],
AND([Province] <>"Salalah", [Square]="")
)

Second try
IFS(
[Province]= "Salalah",Cities[Square],
[Province]<>"Salalah", [Square]="",
)

[AL_Shaikh_Real_]

IFS(
Province]<>"Salalah",[Square],
Province]="Salalah",Cities[Square]
)

Error

Column Name 'Square' in Schema 'Properties_Schema' of Column Type 'Text' has an invalid data validation constraint '=IFS( Province]<>"Salalah",[Square], Province]="Salalah",Cities[Square] )'.

[Steve]

You cannot mix dependent dropdowns with other conditions. Since you have another condition, you will need to implement the dependent dropdown behavior for this column yourself.

Please provide the Valid If expressions of all columns involved in the dependent dropdown.

[AL_Shaikh_Real_]

I have two tables as shown below
In DATA of the Table [ Properties] i need to do dependent dropdown in Valid_if  in Following  Fileds

Cities[Province]

Cities[State]

Cities[Village] I need to order the Villages from (A-Z)

Cities[Square] IF Cities[Square] is not blank for that Village than do a dependent dropdown list of Cities[Square] else allow the user the enter date the Square Field 

[Cities]

ID	Province	State	Village	Square
1	Dhofar	Salalah	Adhan Valley	c
2	Dhofar	Salalah	Brisut Industrial Zone	B
3	Dhofar	Salalah	Awqad South	B
4	Dhofar	Salalah	Awqad Al Sharqiah	B
5	Dhofar	Salalah	Adhan Valley	B
6	Dhofar	Salalah	Brisut Industrial Zone	a
7	Dhofar	Salalah	ambi	a
8	Dhofar	Salalah	Al Shati neighborhood	a
9	Dhofar	Salalah	Awqad South	a
10	Dhofar	Salalah	Awqad Al Sharqiah	a
11	Dhofar	Salalah	Awqad Western	a
12	Dhofar	Salalah	Awqad Al Wusta	a
13	Dhofar	Salalah	Ain Arzat	a
14	Dhofar	Salalah	Ain Jerzeez	a
15	Dhofar	Salalah	Ain Hamran	a
16	Dhofar	Salalah	Ain Sehnout	a
17	Dhofar	Salalah	Adhan Valley	a
18	Dhofar	Salalah	Atheno
19	Dhofar	Salalah	asnot
20	Dhofar	Salalah	Aiboot 1
21	Dhofar	Salalah	Aiboot 2
22	Dhofar	Salalah	Adoration
23	Buraimi	Buraimi	Abu Nakhila
24	Buraimi	Buraimi	Al Ghurayfa
25	Buraimi	Buraimi	acceptor
26	Buraimi	Buraimi	Agran valley
27	Buraimi	Al-Sanaina	black
28	Buraimi	Al-Sanaina	Buhaisah
29	Buraimi	Al-Sanaina	Al-Sanaina
30	Buraimi	Al-Sanaina	Al Ghubaira
31	Buraimi	Al-Sanaina	cheek
32	Buraimi	Al-Sanaina	Ain El Helweh

[ Properties]

ID

User_email

User_name

To advertise

Date

Province

State

Village

Square

Plot no

property type

Area

Total income

Rent value

Details

Price

OmanReal Link

Google Link

Property Photo

[Steve · Accepted solution]

If you'd like to sort the list of provinces, set the Valid If for Province of the Properties table to:

SORT(
  SELECT(
    Cities[Province],
    TRUE,
    TRUE
  )
)

Similarly, for State:

SORT(
  SELECT(
    Cities[State],
    ([_THISROW].[Province] = [Province]),
    TRUE
  )
)

 And for Village:

SORT(
  SELECT(
    Cities[Village],
    AND(
      ([_THISROW].[Province] = [Province]),
      ([_THISROW].[State] = [State])
    ),
    TRUE
  )
)

For Square, use Suggested values instead of Valid If:

SORT(
  SELECT(
    Cities[Square],
    AND(
      ([_THISROW].[Province] = [Province]),
      ([_THISROW].[State] = [State]),
      ([_THISROW].[Village] = [Village])
    ),
    TRUE
  )
  - LIST("")
)

[AL_Shaikh_Real_]

Thanks You are the best 👍

[AL_Shaikh_Real_]

I hope that there is an  option to sort data as a check mark within the program 
For people like me who are not good at coding