"App: copy this row and edit the copy" column emptying before action

[Pointer]

I copy and save similar records using app: copy this row and edit the copy action. However, I want some columns to be empty before copying (cannot be the value of the copied record).
Is this possible, how can I do it?

[Joseph_Seddik]

Yes it is possible. Have a grouped action launching two actions:

1. Add a new row to another table using values from this row.
2. Launch an action on a set of rows --> Edit.

[Pointer]

Step 1 is ok, what should be the reference row expression in step 2, to edit the added row.

[Joseph_Seddik]

The value of the Key column in the newly-created row, that you either provide or extract from the table using MAXROW() or SELECT() with MAX() for example.

[Pointer]

I couldn't do it, can you write a sample formula? 

[Joseph_Seddik]

Open the doc.

[Pointer]

"The expression is valid but its result type 'Ref' is not one of the expected types: List"

I get this error, but the below expression worked.

SELECT(Mytable[ID], [_Rownumber] = MAX(Mytable[_Rownumber]))

[SkrOYC · Accepted solution]

I do it differently and I think it's more straighfoward.

1. Create an action of "App: go to another view within this app"
2. Add a LINKTOFORM() on the Target field
   1. On your LINKTOFORM(), add values just to the columns you want to be copied, you can ignore the ones you need to be blank/initial value
3. Place it wherever you wanted the "Copy this row" one

Your LINKTOFORM() should look something like this:

LINKTOFORM(
  "TableName_Form",
  "Field1", [Field1],
  "Field2", [Field2],
  "Field3", [Field3]
)

[Joseph_Seddik]

Even better!