cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Anonymous
Not applicable

Export worksheet as pdf and email

We have a workbook with a large number of sheets - one for each staff member. Each sheet records some 'preferred to be private' information and we email this out as a pdf per staff member each week.

We're trying to setup a flow that will;

 

  • Get a workbook
  • Export each worksheet as a pdf
  • Email that pdf to a user

I've found some assistance here: https://powerusers.microsoft.com/t5/Building-Flows/Flow-Help-Excel-to-PDF-then-e-mail-PDF-to-distrib...

But my flow is getting stuck getting the data from the sheets to do anything.

 

Flow

 

I've tried with or without attempting to create the sheet as a new workbook file first; but the hangup seems to be that there is no 'content' output from the Get worksheets action, so I either can't create a new file with the worksheet content, or I can't convert a worksheet directly to a pdf because the Convert file action only accepts a file as input.

Any workarounds or obvious things I've missed?

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Anonymous
Not applicable

3 REPLIES 3
Highlighted
Community Support
Community Support

Hi @Anonymous,

 

I have made a test on my side and I afraid that there is no any way to achieve your needs to convert each sheets in a excel to a pdf file.

 

As you said, there is no 'content' output from the Get worksheets action,so you either can't create a new file with the worksheet content, or convert a worksheet directly to a pdf because the Convert file action only accepts a file as input.

 

If you want the 'content' output from the Get worksheets action could be supported in microsoft flow,

please submit an idea to Flow Ideas Forum:

https://powerusers.microsoft.com/t5/Flow-Ideas/idb-p/FlowIdeas

 

Best regards,

Alice

 

 

 

Best regards,

Alice

Highlighted
Administrator
Administrator

Hello, @Anonymous!

 

If you have already posted your idea to the Flow Community Ideas Forum then you need to post the URL to your idea’s thread as a reply to this thread and then "Accept as Solution" on that reply so other users may vote for your Flow Idea and identify the information easily.

 

Thank You!

 

-Gabriel
Flow Community Manager

- Gabriel
Community Manager
Power Automate | Power Virtual Agents
Super User Program Manager
Power Platform Communities
Highlighted
Anonymous
Not applicable

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Power Platform ISV Studio

Power Platform ISV Studio

ISV Studio is designed to become the go-to Power Platform destination for ISV’s to monitor & manage published applications.

Top Solution Authors
Top Kudoed Authors
Users online (9,790)