We would like to have the ability to specify conditions in a Power Apps table and have it set in detail, such as an error if a column or record that does not meet those conditions tries to be registered.

This should also work when importing from Excel as well.

Example

Let's say you have a store called A and a store representative table called B.

Table B has A in column C.

Each of A and B has a column that controls whether the data is valid.

Each of A and B has a column that controls whether the data is valid in statecode.

We would like to add a function to create a validation item based on the above conditions, and to generate an error in the following cases.

The error message is displayed when there are more than two store managers in one store.

Error is displayed if the store is not a valid store or if the person in charge is not a valid person.