Unanswered

Delete all list items where list name begins with certain prefix

(0) Share

Report

Posted on by Iantaylor2050

531

I have a sharepoint site collection where i have 21 lists, where each list is prefixed with SST_List1, SST_List2, SST_List3,.... and so on.

I need to write a power automate to delete sharepoint list items that are created prior to 01 Jan 2025 in all 21 lists automatically. Any idea how to achieve this dynamically?

I don't want to write 21 Get items action and delete items action. I want to achieve this in 1 or 2 action. Any idea how to achieve this dynamically?

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (1)

Verified answer

sannavajjala87 166 on at

Like (1)

Report
Delete all list items where list name begins with certain prefix

Hi,

You won’t be able to delete across 21 lists with a single Get items action because the SharePoint connector is list-specific, but you can absolutely do this dynamically with just a couple of actions in loops.

If you don’t want to maintain the list names at all and all your lists are consistently named (SST_List…), you can:

Get all matching lists

Send an HTTP request to SharePoint:

Method: GET

Uri: _api/web/lists?$select=Title,Id&$filter=startswith(Title,'SST_List')

Parse the response

Use Parse JSON on body('Send_an_HTTP_request_to_SharePoint')?['d']['results'].

Apply to each list

Loop over results, and inside:

Another HTTP GET to /_api/web/lists(guid'<ListId>')/items?$filter=Created lt datetime'2025-01-01T00:00:00Z'

Loop over those items and call HTTP DELETE on each:

_api/web/lists(guid'<ListId>')/items(<ItemId>)

with headers:

IF-MATCH: *

X-HTTP-Method: DELETE (or plain DELETE depending on approach)

You can also batch deletes, but that’s an extra step.

Was this reply helpful? Yes No
Iantaylor2050 531 on at

Like (0)

Report

Delete all list items where list name begins with certain prefix

Hi @sannavajjala87

I am able to implement the power automate as you mentioned. Upto below steps i am able to retrieve all the necessary lists and power automate ran successfully.

However i am stuck at the last step where actual delete operation is being performed. How do i get the list id and items id for that step?

DELETE STEP

Was this reply helpful? Yes No
Suggested answer

S-Venkadesh 888 Moderator on at

Like (0)

Report

Delete all list items where list name begins with certain prefix

Hi @Iantaylor2050,

In your case, ‘Send an HTTP request to SharePoint 2’ returns an array of List items to delete

You can loop through that array (each entry contains the Item ID) and delete each item using the built-in Delete item action.

I hope this information helps! If it does, please consider giving a 👍.
Best regards,
S-Venkadesh

Was this reply helpful? Yes No