Get modified date of lists and libraries

(0) Share

Report

Posted on by shanemeisnerdhg

I am trying to get the Modified date of a library, but failing miserably..

The issue is, we want to "archive" any library that has a modified date older the 1/1/2021..

Once I can figure out how to retrieve the Modified Date of the library, the the rest of the flow should go easy..
Setup a very basic flow to start, and this does get all the lists and Libraries:

But no matter if I use Value, Body or Item to set the variable, it always returns the same data:

any thoughts?

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

tom_riha 10,185 Most Valuable Professional on at

Like (1)

Report
Hello @shanemeisnerdhg ,

I think you'll need an HTTP request to SharePoint to get more information about a list.

Method: GET Uri: _api/web/lists/getByTitle('ListName')

you can then extract the information from the list by navigating the JSON output, e.g. the date of the last modified item:

body('Send_an_HTTP_request_to_SharePoint')?['d']?['LastItemModifiedDate']

Was this reply helpful? Yes No
shanemeisnerdhg 49 on at

Like (0)

Report

@tom_riha Thank you.. That worked!!
Only thing I had to change was use "LastItemUserModifiedDate", as for whatever reason the LastItemModifiedDate had yesterday's date..

"LastItemModifiedDate": "2022-04-27T13:34:01Z",
"LastItemUserModifiedDate": "2022-02-21T15:40:57Z",
As I just wanted to run this against the libraries, I added a Filter Array:

Was this reply helpful? Yes No