Patch people column LookUp Invalid agrument type (Table). Expecting a record value instead.

(0) Share

Report

Posted on by NicolleAbraham

Hi everyone I am trying to update a people column (that allows multiple) in a SharePoint list. I patch from a combobox but the following happens.

My code is

Patch('Look-up Roles', LookUp('Look-up Roles',Title = "Project Manager Snr" & Entity = cb_LegalEntity.Selected.Title,People) ,{People: ForAll( pp_CE_ProjectManagerSnr.SelectedItems As aPatch, { Claims: "1:0#.|membership|" & Lower(aPatch.Mail),

Department: "",

DisplayName:"",

Email: "",

JobTitle: "",

Picture: ""

}

)

})

TIA

Categories:

Connectors

General Questions

Connecting to Data

I have the same question (0)

All responses (1)

Answers (1)

Verified answer

anandm08 1,936 Super User 2024 Season 2 on at

Like (0)

Report
Re: Patch people column LookUp Invalid agrument type (Table). Expecting a record value instead.

hi @NicolleAbraham ,
try this:
Patch( 'Look-up Roles', LookUp( 'Look-up Roles', Title = "Project Manager Snr" && Entity = cb_LegalEntity.Selected.Title ), { People: ForAll( pp_CE_ProjectManagerSnr.SelectedItems, { Claims: "i:0#.f|membership|" & Lower(ThisRecord.Mail), Department: ThisRecord.Department, // assuming ThisRecord has Department DisplayName: ThisRecord.DisplayName, // assuming ThisRecord has DisplayName Email: ThisRecord.Mail, JobTitle: ThisRecord.JobTitle, // assuming ThisRecord has JobTitle Picture: ThisRecord.Picture // assuming ThisRecord has Picture } ) } )

Was this reply helpful? Yes No