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

Categories:

Using flows

All responses (10)

Answers (1)

Sort by

Yelams 16 on at

Like
a
(0)

Report
Copy link

Link copied!

@eric-cheng
@ScottShearer
Hardesh15 7,087 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@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
a
(0)

Report
Copy link

Link copied!

i have removed it.
Still i am facing issue.
Yelams 16 on at

Like
a
(0)

Report
Copy link

Link copied!

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
a
(0)

Report
Copy link

Link copied!

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
Verified answer

Hardesh15 7,087 Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!

@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
a
(0)

Report
Copy link

Link copied!
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
Yelams 16 on at

Like
a
(0)

Report
Copy link

Link copied!

@Hardesh15
Yelams 16 on at

Like
a
(0)

Report
Copy link

Link copied!

Please find the libraries of

Expired date is not showing in filter query how to get from all document libraries
Hardesh15 7,087 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@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