
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
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