Hi. I am trying to implement some logic based on the value of a column [Data Capture Type]. If the value of this column is “By Dependent Dropdown” it brings the user through a collection of drop down lists in order to set the value of the [Product Code]. If the value of the [Data Capture Type] column is “By Product Code” the [Product Code] column is populated with the entire list of Product Codes from the Product_Master_File table and based on the users selection it automatically sets the values of the dependent drop downs mention above.
I have the UX setup to compliment the above navigation but I cannot seem to get the logic to work.
I have the following Valid If expression in the [Product Code] column
IFS([Data Capture Type]=“By Product Code”,
SELECT(Product_Master_File[Product Code],TRUE,TRUE),
[Data Capture Type]=“By Dependent Drop Down”,
SELECT(Product_Master_File[Product Code],AND([Product Range]=[_THISROW].[Product Range],[Treatment]=[_THISROW].[Treatment],[Style / Length]=[_THISROW].[Style / Length],[Product Description]=[_THISROW].[Product Description]))
)
and I have the following Valid If expression in the [Product Range] Column i.e. one of the dependent drop downs.
IFS(
[Data Capture Type]=“By Product Code”,
ANY(SELECT(Product_Master_File[Product Range],[Product Code]=[_THISROW].[Product Code])),
[Data Capture Type]=“By Dependent Dropdown”,
SELECT(Product_Master_File[Product Range],TRUE,TRUE),
)
but I am getting the following error
Column Name ‘Product Range’ in Schema ‘Works_Orders_Master_Schema’ of Column Type ‘Enum’ has an invalid data validation constraint ’
Could anyone advise me on the best way to achieve my requirements?
Many thanks.
LinkedIn
Twitter
