Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Power Automate - Building Flows
Unanswered

Need Help taking Excel worksheets and making them their own pdfs

(0) ShareShare
ReportReport
Posted on 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,381 Super User 2025 Season 1 on at
    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

Thomas Rice – Community Spotlight

We are honored to recognize Thomas Rice as our March 2025 Community…

Kudos to the February Top 10 Community Stars!

Thanks for all your good work in the Community

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 146,398 Most Valuable Professional

#2
RandyHayes Profile Picture

RandyHayes 76,287 Super User 2024 Season 1

#3
Pstork1 Profile Picture

Pstork1 65,274 Most Valuable Professional

Leaderboard