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

[HydrogenUtility]

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:

Thanks in advance!

 

 

[tom_riha · Accepted solution]

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.

[HydrogenUtility]

Thanks again @tom_riha .

Simple, elegant and effective.

This is what I will do.

Regards,

Lachlan