Delete ALL records in a sql sever table from Powerapps

[DAVIDPOWELL]

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

[GarethPrisk · Accepted solution]

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.

[DAVIDPOWELL · Accepted solution]

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

[eka24]

If it worked then mark your answer as a solution