Get modified date of lists and libraries

[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?

[tom_riha · Accepted solution]

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']

[shanemeisnerdhg]

@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: