Accessing "Modified" time from SharePoint action "Get files (properties only)". No clear way to access to the output.

(0) Share

Report

Posted on by HydrogenUtility

152

I can successfully query a folder in SharePoint and view output using the Get files (properties only) action. The output in JSON is like this:

{
 "@odata.etag": "\"2\"",
 "ItemInternalId": "942",
 "ID": 942,
 "Modified": "2021-05-18T23:54:53Z",
 "Editor": 
 {
 "@odata.type": "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedUser",
 "Claims": "i:0#.f|membership|office.admin@hydrogenutility.com",
 "DisplayName": "Office Admin",
 "Email": etc,
 "Picture": etc,
 "Department": "",
 "JobTitle": ""
 }
etc etc etc
}

...and so on as nested JSON elements for each file in the folder.

What I need to do is grab the 'Modified' elements for each file and find the newest, get it's ID and then perform actions on that file.

So how do I succinctly access the "Modified" element (key and value) for each file and work with them recursively?

Example output:

Screen Shot 2021-05-19 at 2.02.21 pm.png

Thanks in advance!

All responses (2)

Answers (1)

HydrogenUtility 152 on at

Like (0)

Report

Re: Accessing "Modified" time from SharePoint action "Get files (properties only)". No clear way to access to the output.

Thanks again @tom_riha .
Simple, elegant and effective.
This is what I will do.
Regards,
Lachlan
Verified answer

tom_riha 10,127 Most Valuable Professional on at

Like (1)

Report
Re: Accessing "Modified" time from SharePoint action "Get files (properties only)". No clear way to access to the output.

Hello @HydrogenUtility ,

you can use 'Order By' field in 'Get files...' and set it to:

Modified desc

and at the same time limit the number of returned files to 1. That way 'Get files...' will return only the single file with the latest modified date and you can work with it.