cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
vsslasd
Level 8

RemoveIf not deleting rows in SQL Server

We are trying to delete all rows in a SQL Table where ToDelete=true. There are about 8 rows that meet this criteria.

 

The following code does not remove any rows from SQL Server:

 

 RemoveIf('[dbo].[Material]',ToDeleted = true)

 


Is there something wrong with the syntax ? 

Thank you

1 ACCEPTED SOLUTION

Accepted Solutions
vsslasd
Level 8

Re: RemoveIf not deleting rows in SQL Server

The RemoveIf doesn't work on tables. 

The correct syntax is: 

 

Remove('[dbo].[Material]',Filter('[dbo].[Material]',IsDeleted = true));

View solution in original post

1 REPLY 1
vsslasd
Level 8

Re: RemoveIf not deleting rows in SQL Server

The RemoveIf doesn't work on tables. 

The correct syntax is: 

 

Remove('[dbo].[Material]',Filter('[dbo].[Material]',IsDeleted = true));

View solution in original post

Helpful resources

Announcements
thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Power Platform World Tour

Find out where you can attend!

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

Top Kudoed Authors
Users Online
Currently online: 336 members 6,285 guests
Recent signins:
Please welcome our newest community members: