Тёмный

[New in PowerApps] The new PDF() function is a gamechanger 

R2Power - Learning Power Apps
Подписаться 6 тыс.
Просмотров 32 тыс.
50% 1

Explaining the ins and out of the new experimental PowerApps PDF()-function.
- enable the new function
- calculate the right page size
- create multiple page PDFs
- mail or save the PDF
Get the demo app from my github github.com/PowerRobin/LernPow...
Get the demo app from the pnp repo github.com/pnp/powerapps-samp...
Hiros blog post about the function mofumofupower.hatenablog.com/...
My svg playlist • [Fun with SVGs] EP6: C...
Other english PowerApps videos • Recreate a design in P...
0:00 Intro
1:00 Agenda
1:36 Enable the experimental PDF-function
2:15 PDF() function and parameters
6:26 Calculating the right size
11:03 Decrease DPI to fit your screen
12:18 Generate an invoice with a signature
14:39 Generating multiple page PDFs with galleries
18:18 Create multi page layouts with a vertical container
21:45 Send your PDF as Email attachment
24:41 Upload PDF to OneDrive via Power Automate
27:59 summary
music from musicfox.com

Опубликовано:

 

21 июл 2024

Поделиться:

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист
Посмотреть позже
Комментарии : 88   
@elkinalexisariaszapata1785
@elkinalexisariaszapata1785 Год назад
Wow, thank you so much, just what I needed, greetings from Colombia ✌🏼
@R2Power
@R2Power Год назад
Glad I could help!
@laszlokovacs7411
@laszlokovacs7411 Год назад
YES YES YES! AMAZING FINALLY I HAVE A WAY TO PRINT MULTIPLE PAGES FROM POWERAPPS!!! AMAZING!!
@abhishekgawde3812
@abhishekgawde3812 Год назад
You rock! great tutorial :)
@R2Power
@R2Power Год назад
Thank you so much!
@timo8250
@timo8250 Год назад
Thank you Robin for this Video! The PDF Function makes it now so much easier, Powerplattform is really improving :-) Any timeline when you will post your first Videos about your great Component libary? Thank you for all of your great work!
@R2Power
@R2Power Год назад
I think we have a spot to present this at the 22nd of December on the pnp-call. So expect it to be released before christmas (still not 100% done 😅)
@timo8250
@timo8250 Год назад
@@R2Power Thank you Robin! Really looking forward to seeing your result. 😊
@benjaminwelzel9401
@benjaminwelzel9401 Год назад
Liebe deine Tutorial. Weiter so.
@R2Power
@R2Power Год назад
Danke dir, ich versuche es!
@olivergrobs349
@olivergrobs349 Год назад
Exactly, what I needed !
@R2Power
@R2Power Год назад
EVERYONE asks for PDFs all the time and it seems like Microsoft finally listened 😅😅
@SimmsLive
@SimmsLive 8 месяцев назад
Lifesaver, thank you!
@R2Power
@R2Power 8 месяцев назад
Thanks!
@alcaesc80
@alcaesc80 Год назад
master of masters.. thank you
@R2Power
@R2Power Год назад
Thank YOU for that comment!
@Angell-Technolgy
@Angell-Technolgy Год назад
echt stark Robin!
@R2Power
@R2Power Год назад
Danke Peter!
@bzqp2
@bzqp2 Год назад
Bold texts inside of HTML blocks seem to work fine. :)
@R2Power
@R2Power Год назад
Nice! Guess they reworked some parts
@stuandrews1618
@stuandrews1618 Год назад
Thank you for this Robin, I can see this function getting a lot of use, I've had a play around and it seems you can use a negative margin, it may help if you are trying to pixel perfect a page. Anyway it is so much better than the converted html in onedrive technique. I have a gantt style chart made from 2 overlapping pixel perfect galleries, and I tried to recreate it in html, but the html in the onedrive conversion is pretty limited so I could only create a basic looking chart. Now the chart looks really professional in the pdf page. I did a few tests with the bold problem and I couldn't get it to work either. I tried using labels and tried html text, using also tried creating a with no luck. The same happens with italic or tags, and also underlined, all is stripped from the text. Hopefully an update with fix this. The documentation states it doesn't work with galleries inside galleries, but I did find that using the creators kit details list component within a blank variable height gallery worked with tabular data. Passing a table grouped using groupby to the gallery, and accessing the grouped column in the details list printed out in the pdf ok. Thanks for your video on this, it's been very helpful!
@R2Power
@R2Power Год назад
Yeah, figuring out what works in the OneDrive html->pdf is exhausting and pretty limited in the end... Also tried all possible ways to get a bold text in the PDF and didn't succeed :(
@moomoo7946
@moomoo7946 Год назад
@@R2Power one thing that works for me is to use heavier font (i.e. Lato Black) for bold text and a lighter font (i.e. Lato Light) for normal paragraph. That results in a better representation in the PDF 🙂
@R2Power
@R2Power Год назад
@@moomoo7946 thanks for the Idea. That should work perfectly.
@craig.galbraith
@craig.galbraith 8 месяцев назад
Great information! This helps a lot! Is it possible to set up a container so that when you use the PDF function against it while the App is being used on a mobile device, that the container still fills the resultant PDF file? Thanks!
@R2Power
@R2Power 7 месяцев назад
Should work with a container, that is larger than the screen, but I didn't try it myself
@jray1429
@jray1429 11 месяцев назад
Great work! Thanks for taking the time to make this video. Is there a way to directly download the file instead of emailing it? Thanks
@R2Power
@R2Power 11 месяцев назад
You can save it somewhere on SharePoint, pass the link back to PowerApps and directly use the Launch()-function to call the link
@pedrohenriquefontesleitao9750
@pedrohenriquefontesleitao9750 10 дней назад
Nice video!! If your Invoice page (page 1) had many items so one page is not enough?
@PeterHeffner
@PeterHeffner Год назад
Super Video, Robin! Viele Dank fürs Teilen. Hast du bei Galleries die über mehrere Seiten auch den Effekt, dass sich der untere Teil einer Zelle mit jeder Seite weiter nach unten verschiebt und sozusagen auf der nächsten Seite oben kommt? Hab auch mal die Gallery in einen Container gepackt, aber das ändert nichts.
@R2Power
@R2Power Год назад
sorry, habe noch nicht in das speziell Thema reingeschaut. Idee wäre vielleicht eine verschachtelte Galerie und dann immer x Elemente pro Seite. Damit könnte man dann auch wiederkehrende Header etc. umsetzen
@PeterHeffner
@PeterHeffner Год назад
@@R2Power Nee, nested Galleries werden nicht unterstützt :( Ich versuche gerade so eine Art Projektübersicht zu bauen, in dem in der Gallery einige Daten und ein Bild gezeigt werden soll. Das Deckblatt in einem Container und eine Legende im 2. Container klappt super. Nur bei der Gallery im 3. Container verschieben sich die Pixel.
@abdulrahmansalama8318
@abdulrahmansalama8318 Год назад
You are amazing dear (Hide controls ) is this will hide the pdf button only or all the controls in the screen?
@R2Power
@R2Power Год назад
every control where you set the "Visible" property to the variable you set to "false" (and afterwards to "true" again)
@vicentedelgado3001
@vicentedelgado3001 Год назад
This video is great! got a question: how can the container be sized beyond the limits of the screen? I can't stretch the container outside the screen limits.
@R2Power
@R2Power Год назад
Type in values into the X/Y/Width/Height-properties But strange things can happen when you do that (screen jumps to that control when you focus it)
@bzqp2
@bzqp2 Год назад
In my case if I forced the block inside of the container to autosize to the content (HTML text) the container automatically would resize beyond the screen to fit the HTML block. You can also use some other container-type control that is scrollable, like a gallery.
@vicentedelgado3001
@vicentedelgado3001 Год назад
@@R2Power I tried didn't work. Had resize the screen itself. Thanks!
@angeliquemascarinas6279
@angeliquemascarinas6279 2 месяца назад
Salamat.
@R2Power
@R2Power 2 месяца назад
walang anuman
@malte2271996
@malte2271996 Год назад
Hi Robin, vielen Dank erst mal für deinen Content. Immer eine große Hilfe. Die Einfache PDF Seite funktioniert soweit fehlerfrei in meiner App. Denkst du das mögliche Szenario: Wenn ich mehrere dynamische Positionen habe, die ich immer auflisten will wenn etwas hinzugefügt wird, dass sich die Seiten automatisch anpassen können? Also folgender Use Case: Wenn Inhalt eingetippt in Bemerkungsfeld/ also Feld genutzt --> Dann PDF verlängern. Glaubst du das ist irgendwie realisierbar oder ist das realitätsfern? -Wenn nicht dann Inhalt bis zum eingetippten am besten schrumpfen Vielen Dank schon mal. Liebe Grüße
@R2Power
@R2Power Год назад
Mit einem vertikalen Container verschieben sich automatisch die Inhalte. Also einfach alles untereinander und den entsprechenden Abschnitt auf Visible (oder nicht) setzen. Das drunter verschiebt sich dann automatisch hoch/runter.
@malte2271996
@malte2271996 Год назад
@@R2Power Super Danke dir! Werde ich mal testen :D
@vaibhavshukla8967
@vaibhavshukla8967 Год назад
It was a really great Video, just I want to ask one doubt i.e., in the part for creating file in One drive, I'm getting an error in the Power Automate running part which is "Missing column. Your formula is missing a column 'contentBytes' with a type of 'Blob'" Kindly help me out I have used same formula which is shown at 27:42 in the video.
@R2Power
@R2Power Год назад
file property for the flow needs to look like this: file:{name: "randomstring", contentBytes: varPDF}
@R2Power
@R2Power Год назад
but it's exactly as shown in your timestamp
@vibhor5121
@vibhor5121 Год назад
Thanks for this very informative video. I was able to successfully use your code and trigger an email, but somehow the email is missing attachment. Any help would be highly appreciated. Thanks.
@R2Power
@R2Power Год назад
did you actually define the attachment for the email properly? Check the code I show at 22:15
@nehasahotra
@nehasahotra Год назад
hi I have question during edit mode of canvas application i can download 6 pages of pdf but when we publish the code and from publish app we get on one page in pdf ? i had tried many approaches as well yours's too since i didn't get any alternate solution
@R2Power
@R2Power Год назад
Sorry, don't understand the question
@siegmundpanitz4991
@siegmundpanitz4991 Год назад
Hallo Robin, ich möchte gerne Objekte wie z.B. PenInput per Button_Click ein- bzw. ausblenden lassen, leider komme ich auf keine Lösung. Kannst Du mir evtl. einen Tipp geben? VG Siegmund
@R2Power
@R2Power Год назад
Hi Siegmund, ich habe dazu schon ein Video gemacht. Hoffe das hilft: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-bcIM8MrRf2o.html
@Abhishja
@Abhishja 11 дней назад
How about Page size Letter wide like 11.00x8.50?
@videobewerker111
@videobewerker111 5 месяцев назад
Question, can '2 certificate sign fields' be added to the pdf?
@R2Power
@R2Power 4 месяца назад
Sorry, don't exactly know what you mean by that
@dr.mohammedmohammed7633
@dr.mohammedmohammed7633 11 месяцев назад
Dear I used to have an old version of my apps it was working perfectly so I didn't touch the formula or anything ,,, it expand the gallery perfectly without any errors put so on so far ,,, I think when I update the apps for different modifications not related to this pdf function, the capability is gone ,,,, the last publishing was one year from now ,,, when I update this august the capability gone .... something related to platform update happens by MS them self
@R2Power
@R2Power 11 месяцев назад
This is still an experimental function, so I wouldn't use this in production apps
@dr.mohammedmohammed7633
@dr.mohammedmohammed7633 11 месяцев назад
@@R2Power i think MS stop this function for business wise
@bzqp2
@bzqp2 Год назад
I can't get the "ExpandContainers: true" parameter working correctly. It does expand the size of the document to the size of the data, but anything that doesn't fit the screen is just blank. So I end up with 4 empty pages and half of the 1st page filled with the data visible on the screen... What am I doing wrong?
@bzqp2
@bzqp2 Год назад
Oh, I fixed it. Turns out the AutoHeight parameter in my HTML block that I put into a container was set to "false" so its size conformed to the size of the parent container. By changing it to "true" the multi-page PDF displays quite well (sometimes cuts the text in the middle of the line, but it's ok I guess...)
@R2Power
@R2Power Год назад
Perfect, thanks for sharing!
@ripped4life162
@ripped4life162 Год назад
how do you get your workspace to be so big? my apps are only 768px height, am I missing anything? 🤔
@R2Power
@R2Power Год назад
Setting -> Display -> Size -> Custom
@AlbertIsac
@AlbertIsac Год назад
When I add Expand containers its showing an error the option Expandcontainers is not recognized
@R2Power
@R2Power Год назад
sorry, don't know, "ExpandContainers" still works for me as shown in the video (probably the capital C)
@solitronics
@solitronics 7 месяцев назад
Nice video but don't seem to get why my PDF is not being created. I followed the formula and I have no errors but when I click on the create button, it stalls as if the PDF is being created and then nothing happens.
@R2Power
@R2Power 6 месяцев назад
Sorry, hard to say anything without seeing the error. Always keep in mind that it's still experimental!
@marvmaster2639
@marvmaster2639 Год назад
danke bro
@R2Power
@R2Power Год назад
Gerne Marv
@cristobalandrescerongaldam6186
how did you hide controls?... (Set;varPrintmode;true) and (Set;varPrintmode;false) and then using in the "Visible" property of the controls '!varPrintmode" is not working .... did i miss something?
@R2Power
@R2Power Год назад
This should work: Set(varPrintmode; true);; PDF(parameters);; Set(varPrintmode; false);;
@g8dl1ke
@g8dl1ke 4 месяца назад
Hi Robin - ich versuche einen PenInput als Image direkt im Container zu verwenden. Angezeigt wird der input dann in einer Image Control richtig, aber am PDF ist er nicht drauf :(
@R2Power
@R2Power 4 месяца назад
Leider immer noch experimentell die Funktion, da funktioniert wohl noch nicht alles
@Thiago_Tavares
@Thiago_Tavares 4 месяца назад
Hello, I'm from Brazil and I follow your channel. You could create a video on: How to generate all gallery items in PDF, but that gallery item would take up 1 full page of the PDF. Example: 1st page PDF gallery item 1 Gallery item 2, PDF page 2, and so on. Items can be images.
@R2Power
@R2Power 3 месяца назад
This exact scenario is covered in this video...
@tserenbyambaganbat4486
@tserenbyambaganbat4486 Год назад
how to add signature (by photo) on pdf file
@R2Power
@R2Power Год назад
I think you need to get the base64 value of the pic. You can use the JSON() trick to get it from an image control
@ersinyalcin7671
@ersinyalcin7671 Год назад
Hallo Robin, Ich möchte unsere Werkzeugliste digitalisieren. Es sind ca. 20st. Werkzeuge welche ich in Sharepoint erfasst habe und in PowerApp in Gallery anzeige. In der Gallery sehe ich das Bild von dem jeweiligem Werkzeug, Die Artikelnummer, Bezeichnung, Menge und und Auswahl: Vorhanden oder Nicht vorhanden.. Die Idee ist, dass wenn wir ein neue Mitarbeiter erhalten, dass der Teamleiter mit dem Powerapp die Liste durch geht und an gibt ob die Werkzeuge vorhanden sind oder nicht. Wenn er das gemacht hat. Soll man wie du hier im Video gezeigt hast in PDF angezeigt werden. Das Blatt muss auch von beiden Parteien unterschrieben werden, in diesem Video hast du es auch verwendet finde ich cool. Dann sollte das PDF per Email weiter gesendet werden. Es wäre sehr schön wenn du ein Video darüber machen könntest. Gruss Ersin
@R2Power
@R2Power Год назад
Das ist ja alles in der Demo App drin. Einfach runterladen und durchstarten!
@ersinyalcin7671
@ersinyalcin7671 Год назад
@@R2Power Hallo Robin, wie kann ich programmieren das zwei Leute Unterschreiben können? Gruss Ersin
@R2Power
@R2Power Год назад
@@ersinyalcin7671 sorry, den transfer musst du hinkriegen. Das lässt sich nicht in einem RU-vid Kommentar beantworten
@moomoo7946
@moomoo7946 Год назад
The next big hurdle is PDFing flexible height galleries 😕
@R2Power
@R2Power Год назад
Already posted how to calculate the total height of a flexible height gallery on twitter once. That should also work here. I'll give it a try and probably do a short video. Alternatively you could try html-tables.
@siegmundpanitz4991
@siegmundpanitz4991 Год назад
Kommt es noch auf deutsch?
@R2Power
@R2Power Год назад
Dieses Video eher nicht
@siegmundpanitz4991
@siegmundpanitz4991 Год назад
@@R2Power Schade, trotzdem sehr hilfreich.
@johnbrennan8442
@johnbrennan8442 Год назад
It’s an experimental feature so be cautious
@R2Power
@R2Power Год назад
absolutely right, think I also said this in the video
Далее
Print Screen in Power Apps - Print Form & Gallery
12:40
How ChatGPT Built My App in Minutes 🤯
8:28
Просмотров 2,1 млн
FABIANO SACRIFICES 2 ROOKS AND WINS IN 9 MOVES!
6:07
Просмотров 389 тыс.
Power Hour: Power Apps PDF Function
49:19
Просмотров 12 тыс.