Remove () help!!! or maybe lookup or ClearCollect()? Not sure what to use

[asdeev]

Hi Guys,

I have a form and in the gallery I have a remove icon which basically triggers a flow which executes a stored procedure and the item is deleted and the deleted item is saved in my Table.

I want this item to be deleted for the user but it should still be present in the managers record

Managers record is a button which stores all the items they have approved or rejected so far. 

When i tested as a user and removed an item from gallery, it also gets removed from the managers record too. (I know its happening because the coloum is removed from the table)

Can anyone help me understand if there is a way to make this work ?

I have deleted history table, history log and just application table.

[LanceDelano]

Could be happening automatically at the server.  What data source are you using?

[asdeev]

SQL server is my datasource.