Skip to main content
Community site session details

Community site session details

Session Id : l3gup7osaixFG98McUSDn4
Power Apps - Building Power Apps
Answered

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

Like (0) ShareShare
ReportReport
Posted on 20 Jun 2024 10:03:15 by 93

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.

NicolleAbraham_0-1718877769653.png

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
  • Verified answer
    anandm08 Profile Picture
    1,936 Super User 2024 Season 2 on 20 Jun 2024 at 10:11:31
    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
     }
     )
     }
    )

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Announcing our 2025 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for…

Paul Stork – Community Spotlight

We are honored to recognize Paul Stork as our July 2025 Community…

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Loading complete