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

Рет қаралды 33,403

R2Power - Learning Power Apps

Күн бұрын

Пікірлер: 89

@laszlokovacs7411 Жыл бұрын

YES YES YES! AMAZING FINALLY I HAVE A WAY TO PRINT MULTIPLE PAGES FROM POWERAPPS!!! AMAZING!!

@Angell-Technolgy Жыл бұрын

echt stark Robin!

@R2Power Жыл бұрын

Danke Peter!

@elkinalexisariaszapata1785 Жыл бұрын

Wow, thank you so much, just what I needed, greetings from Colombia ✌🏼

@R2Power Жыл бұрын

Glad I could help!

@alcaesc80 Жыл бұрын

master of masters.. thank you

@R2Power Жыл бұрын

Thank YOU for that comment!

@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 Жыл бұрын

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 Жыл бұрын

@@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 Жыл бұрын

@@moomoo7946 thanks for the Idea. That should work perfectly.

@SimmsLive 9 ай бұрын

Lifesaver, thank you!

@R2Power 9 ай бұрын

Thanks!

@olivergrobs349 Жыл бұрын

Exactly, what I needed !

@R2Power Жыл бұрын

EVERYONE asks for PDFs all the time and it seems like Microsoft finally listened 😅😅

@bzqp2 Жыл бұрын

Bold texts inside of HTML blocks seem to work fine. :)

@R2Power Жыл бұрын

Nice! Guess they reworked some parts

@benjaminwelzel9401 Жыл бұрын

Liebe deine Tutorial. Weiter so.

@R2Power Жыл бұрын

Danke dir, ich versuche es!

@abhishekgawde3812 Жыл бұрын

You rock! great tutorial :)

@R2Power Жыл бұрын

Thank you so much!

@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 Жыл бұрын

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 Жыл бұрын

@@R2Power Thank you Robin! Really looking forward to seeing your result. 😊

@abdulrahmansalama8318 Жыл бұрын

You are amazing dear (Hide controls ) is this will hide the pdf button only or all the controls in the screen?

@R2Power Жыл бұрын

every control where you set the "Visible" property to the variable you set to "false" (and afterwards to "true" again)

@pedrohenriquefontesleitao9750 Ай бұрын

Nice video!! If your Invoice page (page 1) had many items so one page is not enough?

@craig.galbraith 9 ай бұрын

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 8 ай бұрын

Should work with a container, that is larger than the screen, but I didn't try it myself

@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 Жыл бұрын

Hi Siegmund, ich habe dazu schon ein Video gemacht. Hoffe das hilft: kzfaq.info/get/bejne/mMl5gJt-17jKYqM.html

@angeliquemascarinas6279 3 ай бұрын

Salamat.

@R2Power 3 ай бұрын

walang anuman

@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 Жыл бұрын

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 Жыл бұрын

@@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.

@jray1429 Жыл бұрын

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 Жыл бұрын

You can save it somewhere on SharePoint, pass the link back to PowerApps and directly use the Launch()-function to call the link

@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 Жыл бұрын

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 Жыл бұрын

@@R2Power Super Danke dir! Werde ich mal testen :D

@moomoo7946 Жыл бұрын

The next big hurdle is PDFing flexible height galleries 😕

@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.

@Thiago_Tavares 5 ай бұрын

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 4 ай бұрын

This exact scenario is covered in this video...

@marvmaster2639 Жыл бұрын

danke bro

@R2Power Жыл бұрын

Gerne Marv

@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 Жыл бұрын

file property for the flow needs to look like this: file:{name: "randomstring", contentBytes: varPDF}

@R2Power Жыл бұрын

but it's exactly as shown in your timestamp

@solitronics 8 ай бұрын

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 7 ай бұрын

Sorry, hard to say anything without seeing the error. Always keep in mind that it's still experimental!

@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 Жыл бұрын

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 Жыл бұрын

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 Жыл бұрын

@@R2Power I tried didn't work. Had resize the screen itself. Thanks!

@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 Жыл бұрын

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 Жыл бұрын

Perfect, thanks for sharing!

@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 Жыл бұрын

This should work: Set(varPrintmode; true);; PDF(parameters);; Set(varPrintmode; false);;

@g8dl1ke 5 ай бұрын

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 5 ай бұрын

Leider immer noch experimentell die Funktion, da funktioniert wohl noch nicht alles

@dr.mohammedmohammed7633 Жыл бұрын

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 Жыл бұрын

This is still an experimental function, so I wouldn't use this in production apps

@dr.mohammedmohammed7633 Жыл бұрын

@@R2Power i think MS stop this function for business wise

@Abhishja 29 күн бұрын

While we click Button PDF function in first screen, PDF is created in second screen to send the email with Attachment. (not to go navigation second screen) ?

@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 Жыл бұрын

did you actually define the attachment for the email properly? Check the code I show at 22:15

@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 Жыл бұрын

Sorry, don't understand the question

@AlbertIsac Жыл бұрын

When I add Expand containers its showing an error the option Expandcontainers is not recognized

@R2Power Жыл бұрын

sorry, don't know, "ExpandContainers" still works for me as shown in the video (probably the capital C)

@ripped4life162 Жыл бұрын

how do you get your workspace to be so big? my apps are only 768px height, am I missing anything? 🤔

@R2Power Жыл бұрын

Setting -> Display -> Size -> Custom

@videobewerker111 6 ай бұрын

Question, can '2 certificate sign fields' be added to the pdf?

@R2Power 5 ай бұрын

Sorry, don't exactly know what you mean by that

@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 Жыл бұрын

Das ist ja alles in der Demo App drin. Einfach runterladen und durchstarten!

@ersinyalcin7671 Жыл бұрын

@@R2Power Hallo Robin, wie kann ich programmieren das zwei Leute Unterschreiben können? Gruss Ersin

@R2Power Жыл бұрын

@@ersinyalcin7671 sorry, den transfer musst du hinkriegen. Das lässt sich nicht in einem KZfaq Kommentar beantworten