Hi @MrChrisApps ,
Could you please share a bit more about the data structure of your Working List and Assignment?
Do you set up the relationship between the Employee and Area within your Assignment List?
Do you want to auto-fill the "Editor" field in your Work item when a specific Area is selected?
I assume that there are two LookUp columns (Employee && Area) in your Assignment, which reference values from the Employees List and Areas List separately. And I assume that there is a Choice type column (Area) in your Working List to list all available Area options, is it right?
Based on the needs that you mentioned, I think you want to auto-fill the "Editor" field in your created Work item when a specific Area is selected, it it true?
I have made a test on my side, please consider take a try with the following workaround:
Go to your Edit form, unblock the "Editor" field data card. Set the DefaultSelectedItems property of the "Editor" person field ComboBox to following:
If(
EditForm1.Mode = FormMode.New,
{
Claims: "i:0#.f|membership|" & Lower(LookUp(Office365Users.SearchUser(), DisplayName = LookUp(Assignment, Area.Value = AreaComboBox.Selected.Value).Employee.Value).Mail),
DisplayName: LookUp(Assignment, Area.Value = AreaComboBox.Selected.Value).Employee.Value,
Email: LookUp(Office365Users.SearchUser(), DisplayName = LookUp(Assignment, Area.Value = AreaComboBox.Selected.Value).Employee.Value).Mail,
Department: "",
JobTitle: "",
Picture: ""
},
Parent.Default
)
Note: The AreaComboBox represents the ComboBox within the Area field data card in your Edit form, where you choose the Area option for your current work item, please replace it with actual control name.
If one area could match multiple employees, and you have enabled "Allow Multiple selections" option for the "Editor" field in your Working list, please consider modify above formula as below:
If(
EditForm1.Mode = FormMode.New,
ForAll(
Split(Concat(Filter(Assignment, Area.Value = AreaComboBox.Selected.Value), Employee.Value & ";"), ";"),
{
Claims: "i:0#.f|membership|" & Lower(LookUp(Office365Users.SearchUser(), DisplayName = Result).Mail),
DisplayName: Result,
Email: LookUp(Office365Users.SearchUser(), DisplayName = Result).Mail,
Department: "",
JobTitle: "",
Picture: ""
}
),
Parent.Default
)
More details about the ForAll function, please check the following article:
ForAll function
Best regards,
