web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Automate how to open first file...

Power Automate

Unanswered

how to open first file in a list

(1) Share

Report

Report

Posted on by mjlangone

26

i wat to open a file who's name changes on every download.

it's the first file in my download folder. i tried something like get files in folder, then referencing with %files[0]% or %files%[0] but get parsing errors.

i've tried

C:\Users\mjlangone\Downloads\%Files[0].Name%

%Files[0]%

%Files[0].FullName%

Categories:

Power Automate Desktop

All responses Img

All responses (2)

Answers Img

Answers (0)

Sort by

MichaelAnnis 5,727 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

So, get files in folder is working, cuz it's getting past that step.

Sort by Last Modified-Descending and then pulling %Files[0]% is correct, so I think you are good there.

Have you tried different settings on Encoding? There is a system default setting.
VishnuReddy1997 2,666 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @mjlangone ,

Please find the solution.

Code:
Please copy the below code to your flow and just change the path.

Folder.GetFiles Folder: $'''C:\\Users\\Downloads''' FileFilter: $'''*''' IncludeSubfolders: False FailOnAccessDenied: True SortBy1: Folder.SortBy.LastModified SortDescending1: True SortBy2: Folder.SortBy.LastModified SortDescending2: True SortBy3: Folder.SortBy.LastModified SortDescending3: True Files=> Files File.ReadFromCSVFile.ReadCSV CSVFile: Files[0].FullName Encoding: File.CSVEncoding.UTF8 TrimFields: True FirstLineContainsColumnNames: False ColumnsSeparator: File.CSVColumnsSeparator.SystemDefault CSVTable=> CSVTable

If you face the problem in Read text from csv file just change the encoding methods as shown in below image.

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

Thanks & Regards
Vishnu Reddy

Join the conversation