You’re offline. This is a read only version of the page.
Hey all,
Im trying to run a script that finds the most recently modified file in a folder and returns the file path. The python script works perfectly in Atom but for some reason, import os & glob are not recognised.
Does anyone know of a way around this? Or point me in the right direction?
Junior engineer here looking to impress my boss by automating the payroll process
fraenk you are a legend. Thank you
When you use this:
https://docs.microsoft.com/en-us/power-automate/desktop-flows/actions-reference/folder#getfiles
it outputs "The retrieved files as a list of file objects"
Lists are described here: https://docs.microsoft.com/en-us/power-automate/desktop-flows/variable-data-types#advanced-data-types
To retrieve a specific item of a list, use the following notation: %VariableName[ItemNumber]%
Files object is described here:
https://docs.microsoft.com/en-us/power-automate/desktop-flows/datatype-properties#files
So file path of first file would be:
%VariableName[0].FullName%
Thank you for the response.
I did try this already. H
owever, I need a file path (file path of the latest modified file in the folder) as an input argument to launch excel. I do not know how to pick the first item from the sorting list by last modified. Do you know of a way to do this?
Did you add the lib folder of your Python installation under "Module folder paths"?
But you don't need Python fir this, just use the get files in folder action and set the sorting to last modified:
https://docs.microsoft.com/en-us/power-automate/desktop-flows/actions-reference/folder#getfiles
Share
Report
All responses (
Answers (
2,125