Hi all
I have a data table in powerapps that is reading a table in the dataverse/cds.
I want to take the records out of the data table in powerapps, but still keep them in the cds as records. So basically I want the user to have the option of being able to delete the records in the data table in powerapps, but also still have the option to go into the cds and view them later if needed. Is kind of thing possible? If so, what would be the formula to put on the button so that all the records go to another table in the cds on a single click?
If it's not possible then how can I delete the records in the data table and cds table on a single button click within powerapps? I already have the filter for the data table set-up, just need the formula to delete all records with single click. Right now my button is only deleting 1 record at a time in the data table and cds. I need it to delete all the records on a single click.
If the above 2 scenarios are not possible within PowerApps, would using power automate flows help me achieve the first scenario?
Thank you in advance.