Hi @Teresa24486 ,
I am assuming that Manager is a Person or Group type of column(I am assuming SP is your data source here) and Department is a choice column.
Set the default selected Item property of the Manager Combo box to the below.
{
DisplayName: LookUp(
Department,
Department = Dropdown1.Selected.Value
).Manager.DisplayName,
Claims: "i:0#.f|membership|" & LookUp(
Department,
Department = Dropdown1.Selected.Value
).Manager.Email,
Department: "",
Email: LookUp(
Department,
Department = Dropdown1.Selected.Value
).Manager.Email,
JobTitle: "",
Picture: ""
}
For Department the formula is similar. Now it depends what type of column is Department in your list. For text you can use the below in the default property of your text control.
LookUp(
Department,
Department = Dropdown1.Selected.Value
).Department
If Its choice then you can use below formula in your default selected Items property of your combo box
{
Value: LookUp(
Department,
Department = Dropdown1.Selected.Value
).Department
}
Hope this helps!
