Delete sharepoint list item if URL column contains X

(0) Share

Report

Posted on by CU21081508-5

Hello, I need help to create a flow that will run through a sharepoint list once (one time only) and delete any list items where the column URL contains a keyword.

Thankyou

All responses (1)

Answers (0)

Mira Ghaly 11,409 Super User 2025 Season 1 on at

Like (1)

Report

Re: Delete sharepoint list item if URL column contains X

Hi @AndrewSmith84

Use the GetItems with a filter query column_x0020_url eq '' or you can use Get Items and apply_for_each loop and a condition
Column URL begins with / Contains your value -> Delete Item-- Filter Query does not include contains operator so you have to use the condition as below

Please check the below article for using filter Queries
https://sharepains.com/2018/11/12/sharepoint-get-items-odata-filter-query/

If this post helps you with your problem, please mark your as Accepted solution.
If you like my response, please give it a Thumbs Up.
MG (Naturally Curious)