Unanswered

Delete a record from a dataverse table based on gallery or form and save it to another table

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hie,

I am trying to figure out a way to delete a record from a dataverse table. My app is setup as follows: I select a user from a gallery which takes me to another page where the info about the user is displayed on a form. However, I am having trouble figuring out how to setup the Onselect properties for the delete icon or finding any functions that can delete rows from the table. Also, I need this record saved to an archive table.

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (0)

Drrickryp Super User 2024 Season 1 on at

Like (1)

Report
Copy link

Link copied!

@Anonymous

In the OnSelect property of the icon inside the gallery:

Collect(Archivetable, ThisItem): Remove(dataversetable, ThisItem)

From a button on the form chosen from say Gallery1:

Collect(Archivetable, Gallery1.Selected); Remove(dataversetable, Gallery1.Selected)

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Thank you, is there anyway I can do this on another screen?

Was this reply helpful? Yes No
Drrickryp Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

@Anonymous

Using the second formula, you can place such a button anywhere in the app and it will remove the record selected in the gallery.

Was this reply helpful? Yes No