Cannot Patch person column to sharepoint list.

[RVoller]

Hi,

I have tried to PATCH to a SharePoint List, but have been unsuccessful.  Not sure what else I should be doing.

The data are captured via a combo box.

Items : 

If(!IsBlank(Trim(RecommendCombo.SearchText)), Office365Users.SearchUser({searchTerm: Trim(RecommendCombo.SearchText), top: 5}))

Error I am getting is - Invalid argument type. Expecting a Record value, but of a different schema.

Patch (

    'Asset Disposal/Transfer Requests-DEV',

    Defaults('Asset Disposal/Transfer Requests-DEV'),

   {Title: AssetDescTxt.Text},

    {'Disposal or Transfer?': {Value: (DisposalRadio.Selected.Value)}},

    {Justification: JustificationTxt.Text},

    {Department: DepartmentTxt.Text},

    {'Existing Capex': ExistCapexTxt.Text},

{

    'Recommended by': {

        '@odata.type': "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedUser",

        Claims: "i:0#.f|membership|" & User().Mail,

        Department: "",

        DisplayName: User().FullName,

        Email: User().Email,

        JobTitle: "",

        Picture: ""

    }

})

[Amik]

@RVoller - for the "Recommended by" section, replace with:

'Recommended by': {
            DisplayName: Office365Users.UserProfile(User().Email).DisplayName,
            Claims: "i:0#.f|membership|" & Lower(User().Email),
            Department: "",
            Email: Lower(User().Email),
            JobTitle: "",
            Picture: ""
        }

[RVoller]

Hi, 

I get the following error, but can't identify where the colon is.  

[RVoller]

I updated slightly, but still get the same error.

Patch (

    'Asset Disposal/Transfer Requests-DEV',

    Defaults('Asset Disposal/Transfer Requests-DEV'),

    {'Asset Disposal/Transfer Request Status': RequestStatusDropDown.SelectedText},

    {Title: AssetDescTxt.Text},

    {'Disposal or Transfer?': {Value: (DisposalRadio.Selected.Value)}},

    {Justification: JustificationTxt.Text},

    {Department: DepartmentTxt.Text},

    {'Existing Capex': ExistCapexTxt.Text},

    {

    'Recommended by': {

            DisplayName: Office365Users.MyProfile().DisplayName,

            Claims: "i:0#.f|membership|" & Lower(Office365Users.MyProfile().Mail),

            Department: "",

            Email: Lower(Office365Users.MyProfile().Mail),

            JobTitle: "",

            Picture: ""

        }

    })

[Amik]

@RVoller - I am not sure where you copied this from, but your syntax is all over the place.

Could you confirm what the data types are for every field you're trying to patch (single line text, single select Choice, Date, Number etc). I suspect the problem is not associated to your People field.

[RVoller]

Hi,

I have removed reference to all other fields,

The code is 

Patch (

    'Asset Disposal/Transfer Requests-DEV',

    Defaults('Asset Disposal/Transfer Requests-DEV'),

{

'Recommended by': {

            DisplayName: Office365Users.UserProfile(User().Email).DisplayName,

            Claims: "i:0#.f|membership|" & Lower(User().Email),

            Department: "",

            Email: Lower(User().Email),

            JobTitle: "",

            Picture: ""

        }})

The error I am getting is Invalid argument type. Expecting a record value, but of a different schema.

The field is of type : Person

[Amik]

@RVoller could you go into List Settings, select the Recommended by column, and take a screenshot of the Settings > Edit Column view.

[RVoller]

Hi @Amik ,

Thank you for your continued assistance.

[Amik]

@RVoller - looks fine to me.

Is there a reason you mentioned in your first post that you have populated the Items property of your Combo Box with the Office 365 users? Because there is nothing in your Patch makes use of that Combo Box. 

One final request - could you take a screenshot of error message, together with a screenshot of the tree view in your app.

[RVoller]

Hi,

The input to the 'Reserved By' field is a combo box.

The requirement is to patch this entry to the sharepoint list.  The combo box is RecommendCombo.  I have tried to to add RecommendCombo.SelectedItems but this did not work. 

The error looks like this:

The tree view looks like this.

Kind regards

Rene Voller