SHAREPOINT LIST - DELETE ITEM - FILTER BY COLUMN OTHER THAN ID

0

Hi,

The error probably occurs because you did not return all columns in the CAML query. In my example, I have a list with two columns (screen - list.jpg) and I specify both columns in the CAML query (screen - config.jpg). In this case, executing the action correctly deletes the selected row. If I specify only one column in the query, the action would return an error.

Regards.

Hi Patryk,

the easiest option would be to create your CAML using the query builder:
https://www.spguides.com/caml-query-builder/

This way you could test at least the query. Another question I have is, whether you are working with folders. This may also make a difference.

@Przemysław
I'm quite sure your CAML is not valid. It's has been a few years when I needed to create a CAML but as far as I remember, if you have two conditions they have to be wrapped into and <and></and> or <or></or>.

Best regards,
Daniel

Thank You ,that's helpful, it works in a sense that it deletes the item. So good here.
But each time I'm getting an error, despite the fact that it gets deleted, and once I have an error next steps are not executed.


Error in On document save action Delete a list element.
Address of a Sharepoint list: /Lists/MDM Project listy
Caml query returns 1 items.

Hi, I have the same problem. When I use "Remove list item" action there is error message which shows how many rows were found and after clicking "close" all rows are deleted. I don't mind what is the point of this message.

I use the following query:

<Query>
<OrderBy>
<FieldRef Name='ID' />
</OrderBy>
</Query>

Anyway, I have also other problem with adding list items. Despite my SQL query gives many rows from 'wfelementdetails', only the first one is added to sharepoint list all the time. The only way is to use loop through the list which is pretty inefficient as takes quite a lot of time for longer lists.