Hi @hong_yip ,
You can use the Patch() function, but you probably want to strip out all the SPO auto-generated or system columns from the source record first - you can do this by using ShowColumns() or DropColumns(), depending which involves the least number of columns you want to specfy. (ShowColumns if you have more you want to drop than show, DropColumns if you have more you want to show than drop).
The first question is which row of data do you want to copy - so this needs to be from some sort of selection or lookup.
ShowColumns() expects a table input, so instead of a lookup, we want to get our row into Table format. One way of doing this is using the Table() function - there's only one row in our result, but the data construct returned is a Table, so we can use ShowColumns() on it. We then use First() on that to get back to a record construct.
For example, let's say you have "FirstName", "Surname" and "Email" columns in a SPO list.
If you're displaying a gallery of all your SPO items, try adding a button to the page and set it's OnSelect: property to;
//Convert selected record into a table using Table() so we can then use ShowColumns() to strip everything that's unnecessary, then use First() to get back to a record
//Assumption is your Gallery Items: property is SPOList, otherwise instead of using Gallery.Selected, use a lookup on SPOList to find the correct record
With({
copyRecord: First(ShowColumns(Table(Gallery.Selected),
"FirstName",
"Surname",
"Email"))
},
Patch(SPOList, Defaults(SPOList), copyRecord)
)
Hope this helps,
RT
