web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / How to reset/clear or ...
Power Apps
Unanswered

How to reset/clear or delete records in data table on a single button click?

(0) ShareShare
ReportReport
Posted on by 503

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.

 

Categories:
I have the same question (0)
  • Verified answer
    eka24 Profile Picture
    20,923 on at

    Insert a Button with:

    ClearCollect(colTable,CDSTableName);

    Clear(colTable)

     

    Then put the Collection: colTable on the items property of theDataTable

    If you want to show the Data on the DataTable, insert a Button with:

    ClearCollect(colTable,CDSTableName);

    ------------

    If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

  • misco007 Profile Picture
    5 on at

    Is not solved yet.  Message: Invalid argument type (control). A value was expected instead

     

     

    misco007_0-1692294865443.png

     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 717 Most Valuable Professional

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 329 Super User 2025 Season 2

#3
Power Platform 1919 Profile Picture

Power Platform 1919 268

Last 30 days Overall leaderboard