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

Like (0) Share

Report

Posted on 19 May 2021 04:06:15 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!

I have the same question (0)

All responses (2)

Answers (1)

HydrogenUtility 152 on 19 May 2021 at 21:07:06

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

Was this reply helpful? Yes No
Verified answer

tom_riha 10,127 Most Valuable Professional on 19 May 2021 at 18:25:46

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.

Was this reply helpful? Yes No