web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Copy and Patch SP People
Power Apps
Unanswered

Copy and Patch SP People

(0) ShareShare
ReportReport
Posted on by 118

Hello

 

I have a canvas app where when a new user is created, (uses a name column that is a SP People list column) it also copies 51 rows from another table, tags the username and patches a second list.  The items to be patched are added to a collect first.  This works, code for the collection is;

 

Stuart74_1-1685021519790.png

I then use 

Stuart74_3-1685021788072.png

 

 

On the second list the UWName column is text.

 

What I am trying to do is to alter the code so as I want to change the second SP list UWName to "people" like it is in the first list. 

 

This is where I need your help.  I have read many posts and have the below code, but cant see what I am missing.

 

Stuart74_2-1685021680481.png

 

I have tried this with and without the office365 connection (I don't think I need this as the SP lists are managing this).

 

Am I missing something simple?

 

Thank you

 

Stuart

 

Categories:
I have the same question (0)
  • iAm_ManCat Profile Picture
    18,256 Most Valuable Professional on at

    Your syntax for AddColumns is incorrect here,

     

     

    AddColumns( TableName, "Column Name", Formula)

     

     

    So in your case that would be something like (excuse me for not adding your whole UWName bit, will just put it as pseudo code):

     

    ClearCollect(
    colTwo,
     AddColumns(
     colOne,
     "UWName",
     {
     The whole thing you had for the person column
     }
     )
    )

     

     

    Cheers,

    Sancho

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Congratulations to the March Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
11manish Profile Picture

11manish 534

#2
WarrenBelz Profile Picture

WarrenBelz 416 Most Valuable Professional

#3
Valantis Profile Picture

Valantis 306

Last 30 days Overall leaderboard