Delete alle the rows of Sharepoint list where a column called UID has more than 5 characters.

[PeKi72]

Hi, 

Is it possible to delete alle the rows of a SP-list where a column called UID has more than 5 characters?

Gr. P

[Rhiassuring · Accepted solution]

Hi there, 

Totally!

1) Use the SharePoint action called Get Items

2) Use the Filter Array action, in the "Choose a value" field, use an expression to say

length(string(item()?['UID'])) is greater than 5

3) We're going to run this once and copy the output from the Filter Array action, and paste it into the Parse JSON action. Point the Content at your Filter Array body, and then use the Generate Schema - you can paste the output from the Filter Array there.

4) Then you can use the Delete Item, and point it at the Parse JSON output of "ID". It'll only bring the ones from the Filter Array earlier, so you know they'll be the ones with more than 5 characters. It will automatically become an Apply to Each.