Hi
@WarrenBelz,
this solved the problem I mentioned but I have another problem that is very similar but slightly different.
In the same formula I also want to choose the Superior of the selected Person.
I use the same items formula but a slightly different one for DefaultSelectedItems, I tried just "copying" what you suggested and now I have:
If( Are team and Department still the same aka. has nothing been changed
TeamField.Selected.Value = ThisItem.Team.Value && DepartmentField.Selected.Value = ThisItem.Department.Value,
[
{
DisplayName: ThisItem.Superior.DisplayName,
Mail: ThisItem.Superior.Email,
UserPrincipalName: ThisItem.Superior.Email,
Claims: "i:0#.f|membership|" & Lower(ThisItem.Superior.Email)
}
],
// If a specific Team is selected the Person currently being adjusted should be their own superior
TeamField.Selected.Value = "[One specific Team]",
[SelectedPerson],
// Has a team been chosen and does a suggested Superior exist, just a QOL thing
!IsBlank(TeamField.Selected.Value) && !IsBlank(RecommendedSuperior),
[RecommendedSuperior],
[]
)
SelectedPerson the entry selected as the form is in another screen.
In the monitor there is a Bad Create Row request with
"Superior": {
"Claims": "i:0#.f|membership|",
"Department": "",
"DisplayName": "[Superior name]",
"Email": null,
"JobTitle": "",
"Picture": ""
}
It only happens when I try to add an entry with the form but not when I try to edit an existing one.
