I have a Department dropdown, whose default value depends on 2 other dropdowns Entity and Project, if Entity is Classic and a Project has been selected, then department related to Project should get assigned as default of Department dropdown, which is working just fine. The problem starts when I myself change the value of department dropdown and then select a different project then it kind of gets stuck to the value that i manually selected. When i try to see what is in Default, i see a changed value and when i try to print value of Department.Selected, I see the manually selected value. I have also observed that this is a on and off behavior. Am I wrong to think that whatever user selects, should get overwritten when user changes input to one or more dropdown on which the said dropdown depends on?
This is what i have set to default of Department dropdown:
If(
TeamRequestForm.Mode = FormMode.New And DVEntity.Selected.Value = "Classic" And CountRows(drProject.SelectedItems) > 0,
LookUp('Division Department',Organization.TermGuid = drProject.Selected.Organization.TermGuid).Title,ThisItem.'Team Division Department'
)
Thank you!!
Deepa Moorjmalani
