Help needed for Patching Multi-People Picker fields

[Anonymous]

I have two forms and am using 1 for new items and a completely different app for editing the items later. This was done because of many data sources.

New form works great and populates the list without issues. For my Patch code i use a collection and a ForAll to retrieve all my values and then use the collection name in my Patch to update.

ForAll(
    cb_TreatmentOwners3.SelectedItems,
    Collect(
        colRiskOwnersToPatch,
        {
            '@odata.type': "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedUser",
            Claims: "i:0#.f|membership|" & ThisRecord.Mail,
            Department: "",
            DisplayName: ThisRecord.DisplayName,
            Email: ThisRecord.Mail,
            JobTitle: "",
            Picture: ""
        }
    )
);

For my edit form I am pulling the item ID out of the URL as a parameter and then loading all the values into the form. This is working. When i go to save with a patch function nearly identical to my New form i run into issues with my multi-people picker combo boxes. The patch doesn't update anything and i don't get errors. If i remove the multi-people picker fields from the patch everything works. Using the same code as above its not working. I ran some tests on the collection and its definitely got items inside of it. The only difference from my new form is that it has something in its DefaultSelectedItems section like this:

ForAll(
    dc_RiskOwners.SelectedItems,
    {
        Claims:"i:0#.f|membership|" & Lower(LookUp(Office365Users.SearchUserV2({searchTerm:ThisRecord.DisplayName}).value, DisplayName = ThisRecord.DisplayName).Mail),
        Department:"",
        DisplayName: ThisRecord.DisplayName,
        Email: "",
        JobTitle:"",
        Picture:""
    }
)

I have a hidden form on the page where i'm pulling from to populate these fields. Do i need to change my approach now for some reason? I want to capture the items found with any additional items added by the current user updating the form.

The Items section has this code:

Office365Users.SearchUser({searchTerm: Self.SearchText,top:10})

There are 4 multi-people fields:

Risk Owner(s), Treatment Owner(s) 1, Treatment Owner(s) 2, Treatment Owner(s) 3

Please help!

In case you need to see my patch:

//Update the risk inside MAJOR PROJECTS by Risk ID
	If(!NewRecord,
        Patch(
            'Major Projects',
            LookUp(
                'Major Projects', ID = recID
            ),
            {
                Title: txt_TitleRiskIDdescription.Text,
                BusinessUnit: dd_BusinessUnit.Selected.Result,
                COIMSEntityFunction: dd_Function.Selected.Function,
                SubFunction: dd_SubFunction.Selected.Result,
                'Operational Area': dd_OperationalArea.Selected.Result,
                'Date Identified': date_DateIdentified.SelectedDate,
                'Risk Event': txt_RiskEvent.Text,
                'Causes/Threats': txt_CausesThreats.Text,
                Consequences: txt_Consequences.Text,
                'Current Controls and Mitigations': txt_CurrentControls.Text,
                'H&S': txt_InitialHnS.Text,
                'E&R': txt_InitialEnR.Text,
                'Productive Assets': txt_ProductiveAssets.Text,
                Financial: txt_Financial.Text,
                Reputational: txt_Reputation.Text,
                'H&S_Current': txt_HnS.Text,
                'E&R_Current': txt_EnR.Text,
                'Productive Assets_Current': txt_ProductiveAssets.Text,
                Financial_Current: txt_Financial.Text,
                Reputational_Current: txt_Reputation.Text,
                'Proposed Risk Treatment Strategy (1)': txt_ProposedRiskTreatmentStrategy1.Text,
                'Proposed Risk Treatment Strategy (2)': txt_ProposedRiskTreatmentStrategy2.Text,
                'Proposed Risk Treatment Strategy (3)': txt_ProposedRiskTreatmentStrategy3.Text,
                'Expected Implementation Date (1)': date_ExpectedImplementationDate1.SelectedDate,
                'Expected Implementation Date (2)': date_ExpectedImplementationDate2.SelectedDate,
                'Expected Implementation Date (3)': date_ExpectedImplementationDate3.SelectedDate,
                'Treatment Progress (1)': txt_TreatmentProgress1.Text,
                'Treatment Progress (2)': txt_TreatmentProgress2.Text,
                'Treatment Progress (3)': txt_TreatmentProgress3.Text,
                'H&S_Future': txt_FutureHnS.Text,
                'E&R_Future': txt_FutureEnR.Text,
                'Risk Owner(s)': colRiskOwnersToPatch,
                'Treatment Owner(s) (1)': colTreatmentOwnersToPatch1,
                'Treatment Owner(s) (2)': colTreatmentOwnersToPatch2,
                'Treatment Owner(s) (3)': colTreatmentOwnersToPatch3,
                'Productive Assets_Future': txt_FutureProductiveAssets.Text,
                Financial_Future: txt_FutureFinancial.Text,
                Reputational_Future: txt_FutureReputation.Text,
                Comments: txt_Comments.Text,
                'Next Review Date': date_NextReviewDate.SelectedDate,
                'Hazard ID': txt_HazardID.Text,
                MAH: dd_MAH.SelectedText,
                'Source (Name and Tag #)': txt_Source.Text,
                'Top Event': txt_TopEvent.Text,
                Barriers: txt_Barriers.Text,
                'Closure Date': date_ClosureDate.SelectedDate,
                'Risk Classification Category': dd_RiskClassCategory.Selected.Result,
                'Risk Classification Subcategory': dd_RiskClassSubcategory.Selected.Result,
                'Initial (Baseline) Risk Rating': txt_InitialRiskRating.Text,
                'Current Residual Risk Rating_Current': txt_CurrentRiskRating.Text,
                'Primary Risk Category_Current': txt_PrimaryRiskCategory.Text,
                'Future Residual Risk Rating': txt_FutureRisk.Text,
                'Primary Risk Category_Future': txt_FuturePrimaryRiskCategory.Text,
                Status: dd_Status.SelectedText,
                'BU Category': dd_RiskType.SelectedText,
                'Required Closure Date': date_RequiredClosureDate.SelectedDate,
                'Last Modified By': {
                    '@odata.type': "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedUser",
                    Claims: "i:0#.f|membership|" & currentUser.Mail,
                    Department: "",
                    DisplayName: currentUser.DisplayName,
                    Email: currentUser.Mail,
                    JobTitle: "",
                    Picture: ""
                }
            }
        );
    );

[Anonymous]

I just tried a manual posting by doing everything hardcoded instead of the ForAll and it worked. It required me to add a "Table(  )" reference. Could that be what's missing? I didn't have to do that on my original "New" form. Should i save the collection as a Table instead or concatenate it somehow?

[Anonymous]

I was able to view my collection and there is no email addresses in it. Only the display name is working. Please help me alter my query to get the right result. Lookup Office365Users.SearchUserV2 by displayname to get email. This is the current query i'm using:

ForAll(
    dc_RiskOwners.SelectedItems,   
    {
        Claims:"i:0#.f|membership|" & LookUp(Office365Users.SearchUserV2({searchTerm:ThisRecord.DisplayName}).value, DisplayName = ThisRecord.DisplayName).Mail,
        Department:"",
        DisplayName: ThisRecord.DisplayName,
        Email: "",
        JobTitle:"",
        Picture:""
    }            
)

[v-jefferni · Accepted solution]

Hi @Anonymous ,

The hidden Form in unnecessary. Please try and edit DefaultSelectedItems:

ForAll(
    ThisItem.'Risk Owner(s)',
    {
        Claims:"i:0#.f|membership|" & Lower(LookUp(Office365Users.SearchUserV2({searchTerm:ThisRecord.DisplayName}).value, DisplayName = ThisRecord.DisplayName).Mail),
        Department:"",
        DisplayName: ThisRecord.DisplayName,
        Email: LookUp(Office365Users.SearchUserV2({searchTerm:ThisRecord.DisplayName}).value, DisplayName = ThisRecord.DisplayName).Mail,
        JobTitle:"",
        Picture:""
    }
)

Then you can use the method for New form to Patch and update.

Best regards,