Get last modified file name from a directory

Question

Replies

Views

MaleeshaW

Member since 2019

Evonsys

Solved

Hi,

I have a requirement to obtain the last modified file from a set of files in a specific folder. The folder path is passed as a parameter.

I need to obtain the latest modified file and read its content via an activity or a DT.

Is there any way to obtain this without incorporating Java?

TIA

Accepted Solution

MaleeshaW

Evonsys

replied to MaleeshaW

This was resolved by implementing an activity with the following steps.

Set the folder path to a parameter
Copy the list files in the target directory using D_SPOnlineGetFiles data page to a single page property.
Sort the results in the single page property using the last modified date property in descending order
Get the first result in the sorted list