I have several .xls files in a folder on my c:\users\desktop\test drive. I want to get the latest .xls file in this folder and convert this to .xlsx to upload it to Sharepoint. My first step is get files in folder but the second step to filter the newest file[0] is not working. Could you please send me the steps?
I think that Files[0] is for regular Power Automate Desktop flow not for Power Fx flows. Also just to get the first Files item is not enough since that just gives you a list of properties. You need to give file path to the "Convert file to binary data". So use FullName -property.
Since you have Power Fx enabled you can use =First(Files).FullName
Was this reply helpful?YesNo
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.