Power Platform Community Forum Thread Details

Hi,

I have folder that only images are in jpg format. each week every Monday image will be add in that folder. so i want only latest image file and newly added image in that folder.

i use get files in folder action, i sort there according to creation time and last modified, but it's not work

get files in folder action produce the variable like files, in that variable multiple files are present

i want latest file added in folder, i used files[0], i got the file but it's not latest file added in folder.

please guide me how to use this or any other action present in power automate desktop

Categories:

Power Automate Desktop

Hey @ Bhairav_Gotam

Please find the solutions.

1. Native get files in folder method.

Please copy the below code to you flow and change the path.

Code:

Folder.GetFiles Folder: $'''C:\\Users\\Downloads''' FileFilter: $'''*''' IncludeSubfolders: False FailOnAccessDenied: True SortBy1: Folder.SortBy.CreationTime SortDescending1: True SortBy2: Folder.SortBy.CreationTime SortDescending2: True SortBy3: Folder.SortBy.CreationTime SortDescending3: True Files=> Downloaded_Files
Display.ShowMessageDialog.ShowMessage Message: Downloaded_Files[0].FullName Icon: Display.Icon.None Buttons: Display.Buttons.OK DefaultButton: Display.DefaultButton.Button1 IsTopMost: False ButtonPressed=> ButtonPressed4

2. Use Powershell script to get all the files path that are created on Current Day.

Please copy the below code to you flow and change the path.

Code:

@@copilotGeneratedAction: 'True'
Scripting.RunPowershellScript.RunPowershellScript Script: $'''# Powershell script to get latest files only i mean today created files from the C:\\Users\\Downloads folder
$downloadsPath = \"C:\\Users\\Downloads\"
$today = (Get-Date).Date
$latestFiles = Get-ChildItem $downloadsPath -Recurse | Where-Object { $_.CreationTime -ge $today }
foreach ($file in $latestFiles) {
    Write-Host \"File: $($file.FullName) - Created: $($file.CreationTime)\"
}''' ScriptOutput=> PowershellOutput ScriptError=> ScriptError

(Note:- if you got your solution you can mark as solution and gives kudos)

Thanks & Regards
Vishnu Reddy