Hello!
I am trying to figure out how to set a default value of a dropdown field based on the value selected from another dropdown field. My data is coming from a SharePoint list, one choice column is called 'Employee Type' (Selectable Options: Direct Employee or Contractor) and another choice column is called 'Job Level' (Selectable Options" 1, 2, 3, 4, 5, 6, Undefined).
What I was envisioning is that when someone selects 'Contractor' in the Employee Type field, the default value on the Job Level field would be 'Undefined', if they were to select Direct Employee, then they will be able to choose from all the options in the Job Level field.
I have been trying with a IF formula: If(DataCardValue262.Selected.Value= "Contractor" , "Undefined", Parent.Default)
But getting an error message: Invalid argument type (Record). Expecting a Text value instead.
Any thoughts?

Report
All responses (
Answers (