Answered

Python - Does not import os and import glob

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

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

Categories:

Process mining

I have the same question (0)

All responses (4)

Answers (1)

Sort by

fraenK 2,125 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

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?

Was this reply helpful? Yes No
Verified answer

fraenK 2,125 on at

Like (0)

Report
Copy link

Link copied!

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%

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

fraenk you are a legend. Thank you

Was this reply helpful? Yes No