Unanswered

Can not get first file in folder (sort by create time)

(0) Share

Report

Posted on by jamizztran

Hi,

I create a flow to download file from website to folder Download and then attach to email. The problem is the folder Download have many files and I only want to email only the just-downloaded file not others. I have searched google and they said that I can sort files by create time and use the phase "%Files[0]%" to get the newest file.

But there is error happened: Parameter 'Attachment(s)': Unexpected characters. Characters are used in the formula in an unexpected way.

(Power Automate Desktop)

Help please!

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (0)

Expiscornovus 33,195 Most Valuable Professional on at

Like (0)

Report
Hi @jamizztran,

Can you share a screenshot of which actions/steps you are using in your desktop flow setup?

With that expression you would return all the properties of a single file. Maybe you want to refer to a specific property of that last file, for example the FullName?

%Files[0].FullName%

Was this reply helpful? Yes No
jamizztran 2 on at

Like (0)

Report

Thank Expiscornovus!
I have tried but not succeed. I snapshot the error here. Please help to review.

Was this reply helpful? Yes No