Power Platform Community Forum Thread Details

Hi, hope some can help me:)

I have a form set up from an excel table in PowerApps, when some one hit the delete button from the DetailScreen it delete the selected items in detailScreen, I wanna powerapps to delete the columns in the tabel as it is default, but i also wanna move the values for some columns to another table in the same workbook. So i can track what as been deleted in another table.

Please help:) thx.

Categories:

Building Power Apps

@Armie
Hello there. I’ll give a general example since no specific information about your tables were given.

To insert a new record in your target table you can use the PATCH function. Change the column names and values to whatever suits your own situation. Put some code in your delete button similar to what I’ve shown below. Make sure this code executives before the record is deleted.

Patch(
your_target_name,
Defaults(your_target_name),
{
yourColumn1: DataCardValue1.Text,
yourColumn3: DataCardValue3.Text,
yourColumn7: DataCardValue7.Text
}
);

—
Please Accept as Solution if this post answered your question so others can find it more quickly. If you found this post helpful consider giving it a Thumbs Up.