How to create a PDF using Power Automate from a SharePoint List Item

Поділитися
Вставка
  • Опубліковано 11 гру 2024

КОМЕНТАРІ • 45

  • @euniceseifert4276
    @euniceseifert4276 Рік тому +8

    This was great! !!! Thank you so much. My only wish is that you could do store the info within the SharePoint rather than to OneDrive in the same manner.

  • @usurper762
    @usurper762 2 роки тому

    Hi Steve,
    Thanks for the video. I had a colleague ask for something similar recently. I’ll be happy to tell him we can now accommodate him. Cheers!

  • @Joe-kj8bw
    @Joe-kj8bw Рік тому

    Wow, Thank you Mr. Knutson! I've been looking for a way to do this without a third-party connector or software and this solution was fantastic and worked perfectly. I just need to fine tune the layout, I am not well versed in HTML. Also would like to name the file using a value from the list, like room location or something.

    • @SteveKnutsonNZ
      @SteveKnutsonNZ  Рік тому +1

      I’m glad it helped 😀 You can use dynamic content in the Flow to name files.

  • @naziahurrymun1617
    @naziahurrymun1617 Рік тому +2

    Hi Steve, great video. Are we able to create the pdf file in Landscape, rather than portait?

  • @sebasy6915
    @sebasy6915 Рік тому

    what a great Video!! Thank you very much!!!

  • @abuena73
    @abuena73 2 роки тому +1

    how about if my SharePoint list has an image item, how could i call it to html/PDF?

    • @felix_kunx
      @felix_kunx 2 роки тому

      I have the same question. I cannot bring over images using the dynamic url objects provided. I tried but it does not translate to PDF

  • @rameshbabuc5981
    @rameshbabuc5981 2 роки тому

    Thanks Steve you for this video.

  • @deepikaradhakrishnan01
    @deepikaradhakrishnan01 Рік тому

    Hi Steve, If it is possible to generate pdf from multiple sharepoint lists

  • @ARONCASSELL
    @ARONCASSELL 2 роки тому

    would there be a way to add all attached items on the sharepoint list to the pdf such as .jpg files

  • @ryanhewitt3370
    @ryanhewitt3370 Рік тому

    thanks for the video :) Is their anyway to ignore blank columns when generating PDF's? sometimes not all columns are used and i dont want that on the final pdf if possible. I know something can be acheived using an expression somehow.

    • @SteveKnutsonNZ
      @SteveKnutsonNZ  Рік тому

      You could use use variables to create each line of HTML e.g. label{column value} and then concatenate the variables to create the HTML format, checking to see if each column is not blank.

  • @susanamartinezdeunanue28
    @susanamartinezdeunanue28 6 місяців тому

    Hi There!
    thanks for the information. What would be the flow to do the same but pulling the file from Sharepoint.
    I am working in a project but it looks like we do not have the action convert html to pdf from Sharepoint :(
    any advice is greatly appreciated.

    • @SteveKnutsonNZ
      @SteveKnutsonNZ  6 місяців тому

      To do this you will still need to convert the file using OneDrive as I show in the video. You can "Get File Content" action to get the content of the file in SharePoint and then create a file in OneDrive using the Content from the first action, next use the OneDrive Convert File action to create a PDF file and then use the SharePoint Create File action using the content from the Converted file action.

  • @paulkelly5947
    @paulkelly5947 6 місяців тому

    Hi Steve.
    Thanks for the video.
    I have been asked to export an employee handbook from Sharepoint to allow someone to review it.
    The handbook is a series of webpages with a table of contents page.
    Do I have to do each page indivdually or is there some way I can supply a 'root' page and have the routine work through each page?

    • @SteveKnutsonNZ
      @SteveKnutsonNZ  6 місяців тому

      Hi Paul, I think this might help. I am not sure it will work with images in the page however, but it would be worth a try. sharepointstuff.com/2022/06/15/convert-sharepoint-pages-into-pdf/comment-page-1/

  • @ginoginetto9389
    @ginoginetto9389 2 роки тому

    Hi Steve great video just a question a want save the pdf file with the "title" value in sharepoint, in the "create file 2" on the field "File Name" ex. SHAREPOINT_TABLE.TITLE.PDF but i don't know which command and syntax to use. tks in adv

  • @nicoletonietto1921
    @nicoletonietto1921 Рік тому

    Hello, great video thanks!
    I am trying to create an action to send the PDF in a e-mail with the "send mail" action. When I try to fill the "Attachments contents" part I don't have an option "File content" in the "Create File 2". Do you what I could do to send the PDF in the mail ?
    Thanks in advance

  • @AliOGUL
    @AliOGUL 2 роки тому

    I keep getting error 400 , file id is not valid error on the covert file stage. any suggestion?

    • @AliOGUL
      @AliOGUL 2 роки тому

      okay, found solution. instead of Path on the "convert" you should put ID

    • @SteveKnutsonNZ
      @SteveKnutsonNZ  2 роки тому

      Hi Ali, it sounds like the ID being used isn't the source file.

  • @hugosoto
    @hugosoto 2 роки тому +1

    Hey Steve, Great video
    By any chance do you know if it is possible to add a professional header (or images) to this process?
    I'd love to generate some official company documents for which that would be necessary
    Thanks a lot

    • @SteveKnutsonNZ
      @SteveKnutsonNZ  2 роки тому

      Hi Hugo, you can add images to the HTML template to style the output. It uses standard HTML tags.If you have a paid Power Automate license then you can use Microsoft Word documents as a template.

  • @muzammil4589
    @muzammil4589 2 роки тому

    Hi Steve video helped me a lot, but i want my pdf in tabular form please help me again

    • @SteveKnutsonNZ
      @SteveKnutsonNZ  2 роки тому

      It will depend a bit on your data. If it is a single List item then, you can create an HTML Table. If it is multiple List items then you need to do a For Each loop and append a new Table Row. This is the reference for the HTML you need to create. www.w3schools.com/html/html_tables.asp

  • @yuetnhinhin
    @yuetnhinhin 2 роки тому

    Thanks Steve, I am using this method to create PDF file where chinese character in the html content. The output pdf could not show the chinese character correctly. Those characters became a block. Do you have any ideas on this? I guess it doesn't support UTF-8. Is it true. Thanks

    • @SteveKnutsonNZ
      @SteveKnutsonNZ  2 роки тому +1

      Hi Joanne, I know it is possible with some of the email actions, but I am not sure if the HTML content supports UTF-8. You may be able to get some help on the Power Automate forum powerusers.microsoft.com/t5/Microsoft-Power-Automate/ct-p/MPACommunity

    • @jett27
      @jett27 4 місяці тому

      Hello! Were you able to fix this? I have the same problem

  • @Ehsanahmad99
    @Ehsanahmad99 Рік тому

    Thanks a million ❤

  • @BEautiful0710
    @BEautiful0710 2 роки тому

    Hey Steve - how do you take that converted pdf and attach to outlook email?

    • @SteveKnutsonNZ
      @SteveKnutsonNZ  2 роки тому

      Hi Siretha, this blog explains how to attach PDF files using Power Automate medium.com/@woophily/power-automate-send-email-with-attachments-when-adding-new-item-in-sharepoint-a52bfb90fbd4

  • @nikitachakh1266
    @nikitachakh1266 2 роки тому

    Hi Steve, thanks for this video. Is there any way to convert an Excel file located in a Sharepoint to a PDF file, without using your One Drive account and without using any third party Flows? Thanks

    • @SteveKnutsonNZ
      @SteveKnutsonNZ  2 роки тому

      Hi Nikita, sorry I didn't see your message. The only choices are OneDrive or third-party tools.

  • @djdoooie
    @djdoooie 7 місяців тому

    Impressive!

  • @AMindGame
    @AMindGame Місяць тому

    Seems very hard to post sample code :}

  • @abbasthegreat5
    @abbasthegreat5 2 роки тому

    Thanks.

  • @kathrynhall2019
    @kathrynhall2019 2 роки тому

    Thank you so much for this, it’s exactly the answer I was looking for. However I’m having an issue with dynamic content that contains more than one response.
    I’m using this to create a pdf document based on an entry in a SharePoint list. The responses are for an incident report that it is completed through a Power Apps form.
    Some of the responses allow for multiple answers. I have a text field for a list of witnesses, separated by commas, as well as a list of injury types and locations where the staff member can select all that apply to them.
    How can I get the items in these fields separated into bullet points?
    I can bullet the line, but not separate the contents to provide multiple bullets.
    Also, for the fields where more than one option can be selected, I’m not getting the responses at all, more of an error code.
    [{“@odata.type”:”#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference”,”Id”:10,”Value”:”Sprain/strain”},{“@odata.type”:”#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference”,”Id”:13,”Value”:”Other”},{“@odata.type”:”#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference”,”Id”:-1,”Value”:”possiblybroken- awaiting xray”}]
    Any help would be greatly appreciated, I’m incredibly new to this and it’s my first journey into the world of HTML code.

    • @careless644
      @careless644 2 роки тому

      Same here, did you solve it?

  • @nightcatbooks
    @nightcatbooks 2 роки тому

    Not sure what's up with my flow, but after I do a Get Item, I try to add HTML but the only thing close I get is Create HTML Table.

    • @SteveKnutsonNZ
      @SteveKnutsonNZ  2 роки тому

      Hi Jennifer, I am using a 'Compose' action to build the HTML table. There are some more details on my blog that should help steveknutson.blog/2022/01/25/create-a-pdf-from-a-sharepoint-list-item-with-power-automate/