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
Solved! Go to Solution.
@dmoorjmalani Use Reset(Departmentdropdown) in the OnChange() of the other 2 drop downs. This will trigger the formula you have written in the Default property. Hope this helps!
@dmoorjmalani Use Reset(Departmentdropdown) in the OnChange() of the other 2 drop downs. This will trigger the formula you have written in the Default property. Hope this helps!
@CNT I thought it would be something to do with Reset(), I didn't google well;) thank you! This worked!
@dmoorjmalani Glad to help!
Please remember to give a 👍 and accept the solution as it will help others in the future.
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.
User | Count |
---|---|
202 | |
100 | |
61 | |
59 | |
57 |
User | Count |
---|---|
254 | |
163 | |
90 | |
79 | |
70 |