Skip to main content

Notifications

Power Apps - Building Power Apps
Answered

Patching multiple people picker from one list to another another list in SharePoint

(0) ShareShare
ReportReport
Posted on by 29

I'm patching records from a gallery(TempFacilitiesCol) to a list in SharePoint, but I need to populate a multiple people field (SupportTeams) where the values are in another table (UserGroups).

This table has a Title field and a multi people field (UserList). I need to find the record in the title field that matches my field in the gallery (lblSupportTeamGroup.text) get the users from the UserList and populate the same users in my patch list (NewHire Requests) in the SupportTeams field. See attached the NewHire Requests, I manually populated the SupportTeam but need to automate it with the patch function at the same time I'm creating the record.

I think I need to do another forall statement to get the users but then do I need a Lookup to find the group users, or a filter?

Thanks

 

Here is my patch

 

ForAll(TempFacilitiesCol,
Patch('NewHire Requests',Defaults('NewHire Requests'),
{
Title:ThisRecord.Title,
NewHireID:VarNewHireSandboxID,
RequestStatus:{Value:"Pending"},
SupportTeamsGroup:lblSupportTeamGroup.Text,
SupportTeams: ?????????????

}
))

  • Verified answer
    RandyHayes Profile Picture
    RandyHayes 76,287 on at
    Re: Patching multiple people picker from one list to another another list in SharePoint

    @isantos 

    To start, your formula has the ForAll backward. You are trying to use it like a ForLoop in some development language - which PowerApps is not.  It is a function that returns a table of records based on your iteration table and record schema.

    It is more efficient to use the function as intended and will provide better performance.

     

    Based on what you have said about your other list, then your formula should be the following:

    Patch('NewHire Requests'
     ForAll(TempFacilitiesCol,
     {
     Title: Title,
     NewHireID: VarNewHireSandboxID,
     RequestStatus: {Value:"Pending"},
     SupportTeamsGroup:lblSupportTeamGroup.Text,
     SupportTeams: LookUp(UserGroups, Title=lblSupprtTeamGroup.Text, SupportTeams)
     }
     )
    )

     

    I hope this is helpful for you.

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

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

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

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,343

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,703

Leaderboard