cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
jean9681blr
Level: Powered On

SharePoint List Item to PDF

I have a requirement to create a new PDF file every time when there is an item created in the SharePoint list. This list is used for creating Purchase Order,

 

using Flow I tried to create HTML table and then save the file as PDF
the problem is that.

 

1. The output does not look like a Form
2. It gets data from all the items and not the newly created item.
3. Every time the flow runs it updates the PDF file instead of creating a new file.

 

Expectation is to

 

Get only the newly created item to be included in the PDF file
To Get a new file created every time
And output look more like a form

 

Any suggestions will be helpful.

Thanks in advance 🙂 

PDF OutPut.JPGPDF OUTPUT- with all items from the listFlow.JPGFlow

5 REPLIES 5
Community Support Team
Community Support Team

Re: SharePoint List Item to PDF

Hi @jean9681blr,

 

Some suggestions hope to help you.

Get only the newly created item to be included in the PDF file:

You need to change Get items action to Get item, and then configure the ID of the Trigger output to configure this action, so that Flow will get the newly created item after each trigger.

48.PNG

output look more like a form

If you want to output like a form, you could first adjust the format in Compose, like:

49.PNG

To Get a new file created every time:

You could configure Dynamic content in the file name field of the Create file action, or Dynamic content combination to form the file name. If the File name is a fixed name, the next Flow execution will overwrite the previous file.

50.PNG

More unsatisfactory is that Flow currently has no action to create a form, although Compose can probably design the format of the form, but the effect is not very good.

51.PNG

 

Anyway, you could adjust through some of the above suggestions. hope it can help you.

Full flow configuration:

52.PNG

Please take a try.

 

Best Regards,

Barry

 

Community Support Team _ Barry
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
jean9681blr
Level: Powered On

Re: SharePoint List Item to PDF

Hello Barry, 
Sorry for the late reply and Thank you so much for taking the time to send me the screenshots on how to get SharePoint items to a PDF file.

Following your instruction I was able to get the file created and saved as PDF, however, when I try to open the file I get the following error: File does not begin with '%PDF' 
Will try to figure out on how to fix this problem. 

 

Is there any way to add an image or table to this PDF page so that it looks more like a form.

 

 

teqs
Level: Powered On

Re: SharePoint List Item to PDF

I think the suggested solution is no valid solution. Because creating a file with simply naming it *pdf is not creating a real PDF with PDF format.

 

Somebody knows a solution to export an email as PDF without external custom connectors?

If only with external custom conectors, which works best and are for free?

Re: SharePoint List Item to PDF

Perhaps a solution such as the following one I blogged about would work for you:

Bookings & Campaign Mailer Demo

Highlighted

Re: SharePoint List Item to PDF


@Office365Master wrote:

Perhaps a solution such as the following one I blogged about would work for you:

Bookings & Campaign Mailer Demo


My bad, the link I meant to share is:

PowerApps: Booking form with automated conversion to PDF

https://masteroffice365.com/booking-form-leveraging-powerapps-microsoft-word/

Helpful resources

Announcements
thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

firstImage

Incoming: New and improved badges!

We've given our badges an overhaul and also added some brand new ones!

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

sixthImage

Power Platform World Tour

Find out where you can attend!

seventhimage

Webinars & Video Gallery

Watch & learn from the Power Automate Community Video Gallery!

Top Kudoed Authors
Users Online
Currently online: 330 members 7,210 guests
Recent signins:
Please welcome our newest community members: