cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
DAVIDPOWELL
Impactful Individual
Impactful Individual

Delete ALL records in a sql sever table from Powerapps

I need to 

Delete ALL records in a sql sever table from PowerApps.

I CAN NOT use  Flow at this time.

table name is  "t_sst_BrandMasterTest"

 

However, I could use where "Supplier_Name" is not null ?

 

Thanks

Dave

 

2 ACCEPTED SOLUTIONS

Accepted Solutions
GarethPrisk
Resident Rockstar
Resident Rockstar

Depending on the record volume in the table, I would recommend that you offload this bulk deletion to the SQL server.
The PowerApp cannot invoke a stored procedure (SPROC) directly, but you can create a Power Automate flow and call that from your canvas PowerApp.

https://docs.microsoft.com/en-us/connectors/sql/

Otherwise, any code you write in the app will require deleting row-by-row, which will inevitably be a long running process and/or have delegation issues.

View solution in original post

as I stated, I cant use Flow.

 

I used this:

Remove('[dbo].[t_sst_BrandMasterTest]',Filter('[dbo].[t_sst_BrandMasterTest]',Supplier_Name <> Blank()));

 

worked good.

 

dave

View solution in original post

3 REPLIES 3
GarethPrisk
Resident Rockstar
Resident Rockstar

Depending on the record volume in the table, I would recommend that you offload this bulk deletion to the SQL server.
The PowerApp cannot invoke a stored procedure (SPROC) directly, but you can create a Power Automate flow and call that from your canvas PowerApp.

https://docs.microsoft.com/en-us/connectors/sql/

Otherwise, any code you write in the app will require deleting row-by-row, which will inevitably be a long running process and/or have delegation issues.

as I stated, I cant use Flow.

 

I used this:

Remove('[dbo].[t_sst_BrandMasterTest]',Filter('[dbo].[t_sst_BrandMasterTest]',Supplier_Name <> Blank()));

 

worked good.

 

dave

If it worked then mark your answer as a solution

Helpful resources

Announcements
Power Apps News & Annoucements carousel

Power Apps News & Announcements

Keep up to date with current events and community announcements in the Power Apps community.

Community Call Conversations

Introducing the Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Apps Community Blog Carousel

Power Apps Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Top Kudoed Authors
Users online (3,938)