Forum Discussion
[Power Query] Using Windows environment variable to seek for folder
Hello, I've done office sript for several people for reporting 3D printing. I've managed to make excel to look for latest "*.gcode" file in temp folder and then extract content into table (via power...
Unfortunately you can't get an Environment variable via Power Query. Same goes with Excel functions, VBA is required
I quickly searched but didn't find info. saying this would be doable with Office Script (double-check in case I missed it)
Obviously doable with Power Automate: