Two Conditional Statements in a valid_if

[AL_Shaikh_Real_]

On the same column I need to have

1- a dependent drop down list

2- check for duplicates

1- Property Type[Offer type]

2-
     ISBLANK(
          FILTER(
              "Properties",
                        AND(
                            ISNOTBLANK([Province]), ([Province] = [_THISROW].[Province]),
                            ISNOTBLANK([State]), ([State] = [_THISROW].[State]),
                            ISNOTBLANK([Village]), ([Village] = [_THISROW].[Village]),
                            NOT([_ROWNUMBER] = [_THISROW].[_ROWNUMBER])
                    )
                 )
            )

Can Some Help How to do it

[WillowMobileSys]

Place your dropdown list expression in the Suggested Values property under the Auto Compute section of the column. 

Place your validation code as you would normally in the Valid_If.

[AL_Shaikh_Real_]

Did not work 

[AL_Shaikh_Real_]

The validation worked fine from the browser

but from the mobile it did not, I was able to duplicate the record

[WillowMobileSys]

---

@AL_Shaikh_Real_ wrote:

but from the mobile it did not, I was able to duplicate the record

---

If this is what you meant by "Did not work", then I suspect the validation was not catching the use case properly to identify it as a duplicate. 

Please provide the details of the use case that "did not work" and we can help you sort it out.

[AL_Shaikh_Real_]

Yes, you're right . I found the problem in the mobile, the way to write the numbers is different, so it is not recognized in the validation.

That made the validation not to work 

Thanks for Helping