Delete the libraries which are modified more than 42 days

(0) Share

Report

Posted on by Yelams

I want to perform this below task where how come we filter the output to get only libraries

Get all Lists/Libraries from the site (There is an action to get all lists/libraries)
Filter the out put to get only Libraries
Loop through each library and get the expired documents
delete these documents.

Kindly advise me.

@eric-cheng

All responses (10)

Answers (1)

Hardesh15 7,087 Super User 2024 Season 1 on at

Like (0)

Report

Re: Delete the libraries which are expired more than 42 days

@Yelams Please run your flow and share your dates format. Please make sure that date formates match.

Please 'Thumbs Up' the posts that helped you and 'Mark as Solution' if my post answered your question.

@Hardesh /Gopenly.in
Yelams 16 on at

Like (0)

Report

Re: Delete the libraries which are expired more than 42 days

Please find the libraries of

Expired date is not showing in filter query how to get from all document libraries
Yelams 16 on at

Like (0)

Report

Re: Delete the libraries which are expired more than 42 days

@Hardesh15
Yelams 16 on at

Like (0)

Report
Re: Delete the libraries which are expired more than 42 days

Get all Lists/Libraries from the site (There is an action to get all lists/libraries)
Filter the out put to get only Libraries
Loop through each library and get the expired documents
delete these documents.

I want to use filter query i need to get the documents from all libraries which are expired.

Kindly advise me

@eric-cheng
Verified answer

Hardesh15 7,087 Super User 2024 Season 1 on at

Like (1)

Report

Re: Delete the libraries which are modified more than 42 days

@Yelams i think this is wrong- expression 'item()['body.(created)']'

Do one thing add one compose just above condition 2 and pass created from dynamic content and then copy whole input in a notepad then remove these-{,@,} once you do that then use item(.....).

Please 'Thumbs Up' the posts that helped you and 'Mark as Solution' if my post answered your question.

@Hardesh /Gopenly.in
Yelams 16 on at

Like (0)

Report

Re: Delete the libraries which are modified more than 42 days

Unable to process template language expressions for action 'Condition_2' at line '1' and column '15206': 'The template language expression 'item()['body.(created)']' cannot be evaluated because property 'body.(created)' doesn't exist, available properties are '@odata.etag, ItemInternalId, ID, Modified, Editor, Editor#Claims, Created, Author, Author#Claims, OData__DisplayName, {Identifier}, {IsFolder}, {Thumbnail}, {Link}, {Name}, {FilenameWithExtension}, {Path}, {FullPath}, {IsCheckedOut}, {VersionNumber}'. Please see https://aka.ms/logicexpressions for usage details.'.

Please find the screenshot and help me
@Hardesh15
Yelams 16 on at

Like (0)

Report

Re: Delete the libraries which are modified more than 42 days

I created filter array and fetching the document libraries.

found the below raw output.

{
"body": [
{
"Name": "0cce2ca3-baad-43ca-86c7-c119e8a6728a",
"DisplayName": "Document Library 1",
"Type": "101"
},
{
"Name": "8c1bd727-a9ce-4186-8e04-71eee65e4acf",
"DisplayName": "Document Library 2",
"Type": "101"
},
{
"Name": "997623e6-1a0e-4eb6-bbc9-a582e772eaa1",
"DisplayName": "Documents",
"Type": "101"
},
{
"Name": "4887f97f-b673-4b63-880f-0cb66c7a6322",
"DisplayName": "ExpireDocumentLibrary",
"Type": "101"
}
]
}

now i need to fetch all the files inside all document library.
Kindly advise me
Yelams 16 on at

Like (0)

Report

Re: Delete the libraries which are modified more than 42 days

i have removed it.
Still i am facing issue.
Hardesh15 7,087 Super User 2024 Season 1 on at

Like (0)

Report

Re: Delete the libraries which are modified more than 42 days

@Yelams Please remove first value text from filter.

Please 'Thumbs Up' the posts that helped you and 'Mark as Solution' if my post answered your question.

@Hardesh /Gopenly.in
Yelams 16 on at

Like (0)

Report

Re: Delete the libraries which are modified more than 42 days

@eric-cheng
@ScottShearer