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

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Deleting all rows from...
Power Apps
Answered

Deleting all rows from a dataverse table via API?

(0) ShareShare
ReportReport
Posted on by 35

Hi all, I am using C# and the Dataverse API to dynamically create tables based on the columns in an Excel spreadsheet. I'd like to be able to clear out all data in the table NOT using the Bulk Delete in the Admin site. Is there a way to do this?

I have the same question (0)
  • Drew Poggemann Profile Picture
    9,287 Most Valuable Professional on at

    Hi @ebonnett ,

     

    Looking to use something like this or are you trying to do a delete all?  https://learn.microsoft.com/en-us/power-apps/developer/data-platform/webapi/update-delete-entities-using-web-api 

  • ebonnett Profile Picture
    35 on at

    Trying to delete all so I don't want to address one row at a time. Basically DELETE FROM <tablename>. 

  • Verified answer
    Richard_S Profile Picture
    34 on at

    Hi @ebonnett,

     

    you could call the bulkDelete action via the WebAPI I guess.

    https://learn.microsoft.com/en-us/power-apps/developer/data-platform/webapi/reference/bulkdelete?view=dataverse-latest

    As per my understanding this is basically nothing else than what the bulk delete in the admin site does. Also I would think you need to pass it a query string of the records to be deleted.

    Never used myself, but maybe that's what your looking for.

  • ebonnett Profile Picture
    35 on at

    Leksie, thanks for the tip. I did not know that was an option. I'll check it out and report back, maybe I'll post a code snippet once I get it working so others may benefit.

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Congratulations to the April Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
Vish WR Profile Picture

Vish WR 915

#2
Valantis Profile Picture

Valantis 571

#3
11manish Profile Picture

11manish 457

Last 30 days Overall leaderboard