Unanswered

Get latest .xls, convert to .xlsx and upload to Sharepoint

(1) Share

Report

Posted on by H040150

Hi all,

I am new to Power Automate Desktop. I am looking for a way to get the latest .xls file in a folder, where the name starts with 'Test*'. Afterwards I want to convert to .xlsx and upload this file to Sharepoint.

I have asked ChatGPT and others but they all give me steps that are non existant in my version (which is the latest). PS: my settings are in Dutch which makes it even harder :)

Current flow looks like this:

2024-09-26 16_59_05-Power Automate _ Sentinet to Sharepoint.png

Categories:

Power Automate Desktop

I have the same question (0)

All responses (2)

Answers (0)

Sort by

LamBec 7 on at

Like (1)

Report
Copy link

Link copied!

Looks like you have the input as =Files[0] instead of %Files[0]%.

Same with some of your other variables on the actions in the loop.

Was this reply helpful? Yes No
MichaelAnnis 5,727 Moderator on at

Like (0)

Report
Copy link

Link copied!

I can't read your actions, but ensure Get Files is sorted in the "Advanced" area and you are sorting be date last modified descending. Then it will be %Files[0]%. All your variables need to be %Variable%.

Good luck!

Was this reply helpful? Yes No