Copy and Patch SP People

(0) Share

Report

Posted on by Stuart74

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;

I then use

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.

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:

Building Power Apps

I have the same question (0)

All responses (1)

Answers (0)

iAm_ManCat 18,256 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
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

Was this reply helpful? Yes No