Skip to main content

Notifications

Power Automate - Building Flows
Unanswered

Need Help taking Excel worksheets and making them their own pdfs

Like (0) ShareShare
ReportReport
Posted on 14 Jan 2025 14:27:05 by
I have a workbook which takes forms submissions for equipment inspections and displays them as a daily checklist log for the month. I have designed these checklists in a specific way to resemble my company's paper format. I am trying to build an automated flow which takes each sheet and exports it with the sheet name as the file name and saves it as a pdf in a single folder. I cant find any help on this which doesnt require reformatting of the checklist. The checklist I built is not a table on excel because I couldn't get the formatting the way I wanted when it was a table because you can't merge cells on a table in excel.
I can currently get each worksheet to save to a destination, but the worksheets are always corrupted. 
This is my current flow:
The Convert File step always ends up as "Bad Request".
I am lost if anyone can help. 
  • AlexEncodian Profile Picture
    AlexEncodian 4,255 on 14 Jan 2025 at 16:59:12
    Need Help taking Excel worksheets and making them their own pdfs
    You can convert specific worksheets to PDF using Excel - Convert – Encodian Customer Help
     
    If you don't know the worksheet names, you could convert the entire workbook to a PDF setting One Page Per Sheet property to 'Yes' and subsequently split the PDF into individual pages (i.e. worksheets) using PDF - Split – Encodian Customer Help

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

End of Year Newsletter…

End of Year Community Newsletter…

Tuesday Tip #12 Start your Super User…

Welcome to a brand new series, Tuesday Tips…

Tuesday Tip #11 New Opportunities…

Welcome to a brand new series, Tuesday Tips…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 144,609

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,420

Leaderboard
Loading complete