Deleting specific rows from a sharepoint list

[rajat_del]

Hi,

I have a list and i want to delete only specific records which match a particular condition on a field in my sharepoint list.

Unfortunately, the list is entirely deleted and i have to always append the records back which give rise to new ID's which restrict my ability to do analytics as i need a unique identifier.

Is there any way to delete those specific records maybe using a script or something so that the list is not entirely deleted but just those specific records?

[DanielG]

Following, as this is something I deal with too and would love to know a solution.  Unfortunately though, I don't think there is.  😞

[aehrenwo]

I am thinking you will need to do something with a tool like PowerAutomate from Microsoft to detect the change on the Sharepoint list item and then remove the row if it meets a certain condition.