In case you missed the announcement: Alteryx One is here, and so is the Spring Release! Learn more about these new and exciting releases here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Deleting specific rows from a sharepoint list

rajat_del
7 - Meteor

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?

 

2 REPLIES 2
DanielG
12 - Quasar

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
11 - Bolide

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. 

Labels
Top Solution Authors