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

I have the same question (0)

All responses (10)

Answers (1)

Yelams 16 on at

Like (0)

Report

@eric-cheng
@ScottShearer

Was this reply helpful? Yes No
Hardesh15 7,087 Super User 2024 Season 1 on at

Like (0)

Report

@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

Was this reply helpful? Yes No
Yelams 16 on at

Like (0)

Report

i have removed it.
Still i am facing issue.

Was this reply helpful? Yes No
Yelams 16 on at

Like (0)

Report

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

Was this reply helpful? Yes No
Yelams 16 on at

Like (0)

Report

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

Was this reply helpful? Yes No
Verified answer

Hardesh15 7,087 Super User 2024 Season 1 on at

Like (1)

Report

@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

Was this reply helpful? Yes No
Yelams 16 on at

Like (0)

Report
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

Was this reply helpful? Yes No
Yelams 16 on at

Like (0)

Report

@Hardesh15

Was this reply helpful? Yes No
Yelams 16 on at

Like (0)

Report

Please find the libraries of

Expired date is not showing in filter query how to get from all document libraries

Was this reply helpful? Yes No
Hardesh15 7,087 Super User 2024 Season 1 on at

Like (0)

Report

@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

Was this reply helpful? Yes No