Print all excel files in a folder

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hi everyone,

How can I print all excel files in a folder? Action "Print document" requires exactly link to an excel file

Thanks for your support.

Categories:

Power Automate Desktop

I have the same question (0)

All responses (6)

Answers (1)

Sort by

DamoBird365 8,942 Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!

Hi @Anonymous

Could you use cmd prompt? If you run dir /b *.xlsx from your folder you can get the file names. Drop the first few rows and then iterate through the next lot to print off your files?

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Cheers,
Damien

P.S. take a look at my new blog here

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

Like
a
(0)

Report
Copy link

Link copied!

@DamoBird365 Thanks for your help. I have run with CMD and could get the all xlsx files in my folder. but what should I do for the next steps with print action from 5th line in the picture? I'm a newbie. ^^

Was this reply helpful? Yes No
Verified answer

abdndamo 34 on at

Like
a
(2)

Report
Copy link

Link copied!

Hi @Anonymous

I am replying on behalf of myself @DamoBird365 as I am currently locked out.

I have probably just made it a bit more complicated for you - sorry. I have just realised that you can use the get files in folder step and then a for each item in the list.

Hopefully this helps and the real me can return tomorrow 🙂

Cheers

Damien

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

Like
a
(1)

Report
Copy link

Link copied!

That's great,
Thank you so much!!!

Was this reply helpful? Yes No
NercyCrab 10 on at

Like
a
(0)

Report
Copy link

Link copied!

Let's say we are printing the files via the above loop, this time to PDF printer. 2 issues appear:
1. we have to manually enter the filename for each output file
2. multiple windows will open up at the same time

How can we automatically assign the filenames for the output files?

Was this reply helpful? Yes No
DamoBird365 8,942 Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

@NercyCrab for pdf I am assuming that an adobe confirmation box loads up? You woud need to grab the UI elements for the app windows and insert a wait until element is visible and then select the button to print.

Was this reply helpful? Yes No