You're the MAN Shane! I took your advice and watched this. Then I got on chat GPT 4 and uploaded an existing PDF template, asked it to make it into HTML, and a few cleanup prompts later I had a working HTML template complete with place holders for my dynamic client data. AMAZING! now I just need to make the flow to convert and save it. The easy part.
Thanks Shane. I just completed it and had a beer. Cheers to you for making all this possible. What a great hack on that html control. Makes getting the document set correctly a breeze@@ShanesCows
So, this is the 5th PowerApps911 video that I have watched today. I am focusing on components and making pdfs. They all have been extremely helpful and have saved me time. Thanks!
Good job pretty much anticipating all of the questions I was going to ask: first off if there's a way to do it without One Drive for Business and instead creating the html file in a Sharepoint Library and then converting it to PDF. Second was the landscape question since I want to ultimately create a shipping label for our Logistics Department. It's been a year since this video so maybe there's a more updated solution, but thanks for the video!
Thanks Shane Another one of those common asks. Glad you covered the limits at the end to. As that trips up a lot of people. Some times I wonder if one day things like thos would be easier and that certain features supported the same html rules. I can only dream I guess.
@@ShanesCows email clients is flying of html in email is just as bad. Outlook desktop being one of the worst as it strips out certain tags. Yet the web version doesn't. 😜 Hopefully on the road to getting that fixed.
Hi Shane, if you connect this with a form you can also pull all the attachments through and attach to the email if you pass through the List ID to flow from PowerApps. Also I create the new file in SharePoint add metadata to the file and then attach a copy of the file to the list item tying it all together with a GUID()
Thank You Shane for the lovely video - I have a use case where the image in a certificate template which has 3 to 4 items that I would like to populate in the blank spaces. Since this is an image and I need 3 to 4 text boxes on the top of it, how can I make that happen. Any help is much appreciated.
I don't have the exact answer, you are going to have to fiddle with the HTML until you find a pattern that gets you the output you need. Maybe ask ChatGPT for ideas?
Hi Shane, thanks again for your great video! Just wondering if part of a SharePoint page can be converted to PDF or Picture using Power Automate please?
Hi there, great content. I am new to powerapps. I am looking to create a power app from a Sharepoint List that uses a flow to create a pdf sent by email. Do you have any videos on that? Cheers
I don't have anything exact. If I was you I would do things in this order. 1 - Build a POwer Apps app using SharePOint that collects and interacts with the info you want. Once it works 2 - Build a flow that makes a PDF from your data by pressing a button in the app. Get it looking the way you want. Once it works. 3 - Add to the flow the ability to attach that file to an email. Solve small problems and you got this! 🤩
Hi Shane. Thanks for another awesome video! I've watched a couple of your tutorials on this now and almost everything works, except the 'Convert File' or 'Convert file using path' steps are outputting a generic file instead of a PDF. The files are named filename.pdf using a dynamic input from PowerApps through a compose step to create the name. Do you have any idea why I can't generate a .pdf output please? After extensive searching all I can find is a suggestion that the Microsoft converter is unreliable, but can you suggest anything else please and thank you?
You should have 3 steps. Create file in OneDrive - This should be an HTML file with an HTML extension Convert file - This should use the ID of the file you created in the previous step Create file in OneDrive - This should be the output of the Convert file plus a name like Buddy.PDF Confirm the HTML file is correct. Remove anything dynamic and try with hard coded names and such. The process should work 100% of the time in this simple scenario, get that to work then troubleshoot.
@ShanesCows Thanks Shane. It turned out to be a connections issue in the end. After deleting and adding the connections again, removing and re-adding the Flow to PowerApps, everything seems to be working and I'm creating a PDF. 🤷♂️
Great video, Shane! I have followed this step by step and having issues with the images coming through on the PDF. The text and all come through just fine from PowerApps into HTML, and then into PDF....all except the images. I was super excited to try this short cut. Any troubleshooting ideas? BTW, I can see the images when I open the HTML file.
Hi Shane, Nice video clears basic concept. But would you have or can you make a video similar to this but instead of using HTML codes to create pdf file it should call a flow which fills up my predesigned word or pdf file.
Maverick it is on my far out list of videos. I have never had a project where I have had to populate a project so I don't have any first hand experience. My team has done it but I haven't. 😐
Hey Shane. Great video! You do a great job of breaking it down and being entertaining. Is it possible to select multiple Gallery fields? In your example, could you select you and Chewy?
Hola! Muchas gracias por sus videos!!! Le saludo desde Guatemala! Con una consulta, cómo se puede adjuntar varios archivos con html? Desde ya muchas gracias
In this video I talk about sending emails including attachments. Does that help? ruclips.net/video/vpYkOccwn4Y/видео.html If you are trying to attach files to the PDF then I do not know how to do that. Sorry.
Hello Shane, if you have a child/repeating table ... can I save the html data in a parent field to be used later in a created pdf or re-opening in power apps? I saw a example of a Nintex Form saving the repeating table info as XML in a sharepoint parent list 'more lines field'.
This is a great video. How would you dynamically compute the file name and also how would you pull other information from the gallery over so you can use it it in the rest of the flow, such as email addresses that you have within the gallery. thanks.
Hi Shane, I really appreciate you putting this content out on RUclips, I've used many of your videos for inspiration. I've looked high and low and cannot find out how to control the page size of the PDF when going thru this process, no matter what I do in the HTML. Is there documentation out there? Is that something you address in any other video?
The only luck I have had is inserting Page Breaks. ruclips.net/video/YkSNg7B_rps/видео.html All of the other page manipulation stuff doesn't seem to work unless you use one of the 3rd party tools.
As always, you have the answers! One question, can you share how we can bring the name of the doc generated in Powerapps over as the filename (that will obviously be dynamic). I've tried a gazillion different ways and am reaching the crazy side of efforts...
In this really old video I show how to respond from flow. Different topic but same concept. I will put responding to Power Apps on my to do list. :) ruclips.net/video/ovLIwnj6QjU/видео.html
Hi Shane, great video, say you wanted to select 3 of the Employees from the Gallery and print their details in an ordered or unordered list how do you do that? add them to a collection then put the collection info into the HTML code for HTMLtext box? I can't seem to get the syntax right!!
thank you for your help that is exactly what I'm looking for ..but I have a question how do you link the icon of the pdf in the items to the html page that you want to generate.. so what I meant is how it generate the exact item data I need!!
Hi shane! Using this same methodology can we build pdf using data from different SharePoint lists which are connected using referal ID. Actually my requirement is to build a payslip of the employees but i also want to display their leaves taken and leaves balance which is stored in another list. Could you please suggest me something regarding this??
Hey Shane! Thanks for the video! Is it possible to do this just through Power Automate? Creating a flow specifically pulling images and data from Sharepoint and creating a PDF for each row item in Sharepoint?
Hi . . . I'm looking to use the HTML box, but without the Gallery. I've been able to display fields correctly with just the DataCardValue.Text working. However, I can't get a people picker field to display correctly. I've tried many things like DataCardValue.DisplayName, but nothing is working. I'm surprised it isn't the same as with the Gallery syntax, like DataCardValue.'People Field'.DisplayName or something similar. Any insight is appreciated. Thank you for all your great videos.
Excellent video. Is there a way to either split the psf output into 2 columns on 1 page, or to justifiy some to the left and some to the right on the same row. I have uswd style left and float right but that doesnt seem to work when converted, same with setting width and height to an image
Yes, you just need to try a bunch of different stuff. The easiest way is to make a table and use inline styles. Let your table define the layout and put your pieces in. Float doesn't work I don't think. Images sizes can be set with width and height px I am pretty sure.
Awesome Video Shane! When I move a a solution from Dev Environment to Test Environment, the same flow also moves to the Test Environment but the print button doesnt work. Since the Test Environment is a managed solution, if I edit it, it creates an unmanned layer. Have you noticed it doesnt work in a different Environment? Do you know how I can move it to another environment and make the print flow feature work? Thank you!
Thank you Shane. In using the OneDrive- is it always the users OneDrive or is it always my OneDrive that the user is accessing when they access that flow? I’m just curious how that works because I would have to have a folder that everyone in my organization had the same named folder for the flow to work if it was accessing their OneDrive.
The user is always using THEIR OneDrive. If the folder you specify in the flow doesn't exist the create file process will automatically create it for them. 😎
Great video! However, when I try styling HTML such as aligning some text and giving text background color I can see it in Power Apps. But somehow that part doens't come through in the PDF. Am I missing something?
The conversion engine uses different HTML rules. Try inline styles. It is all possible just have to keep trying different ways till you find the one that works. 😐
Wow, thank you so much, Shane! Your solution is brilliant and worked perfectly on my OneDrive. However, when I tried saving the PDF to SharePoint, the file appears in the folder but won't open-it says 'Error on file.' Do you have any idea what I might have missed? 🤷♀
Hi @ShaneYoung, I want to get the export of all the gallery Items and including their attachments of those gallery records and create a PDF just like you having all the records appended. I am confused any idea?
Mine will create 2 files the HMTL and the PDF file but for some reason the PDF is blank. Any idea what causes this? Is there a step at the end that can either open the file location or the good file to print without going the long route?
Hi Shane, Great Video...big fan from India.... I have two issues where i need your help: 1. How to do for SharePoint list with image attachments (or multiple images) 2. I have copied exactly how you did, but my flow error is occurring in the last two steps of the flow, The flow test is successful but when i run the PowerApp the flow is getting failed.. Thanks in Advance
Hi ALL, quick question, I performed the Flow as outlined in the video, when I ran the flow it creates the HTML File ( I can open and see it in a browser) , but won't convert to PDF,... this is the error "ERROR Details : Conversion of this file to PDF is not supported. (Sandbox_HtmlTransform_InvalidOperation / An exception occurred while executing within the Sandbox) "
Great video, Shane! Thank you for this! I wanted to make use of that laying two images on top of each other. However, even though the HTML looks perfectly fine, the images display one after the other in the PDF after the conversion process. Is this also due to the restrictions of the free integretated PDF converter or did you manage to do this with your presented method? Thanks again for your videos, they are very helpful!
Hello Shane! Thanks for putting so much information for us about PowerApps. I wanted to ask bout using SharePointIntegration instead of Gallery1.Selected. I have tried a way to use the SharePoint integration to use dynamic information based on selected itmes but cant get it to work :(
Hey Shane. Awesome video. Thanks for showing the conversion process with the power apps V2. Quick question. Is there a way to show the file size limit before the user exports to PDF. That way they know if the amount of information they are taking out is too much and they need to cut down their selection?
So, I'm assuming if you loop through a list with many entries since it's html it will span multiple pages? Now if we could get external style sheets to work that would be awesome.
@@ShanesCows Is there any fix to pagination? I often have a file that has a table that goes into a second page. The last item on the first page gets cut in the middle because the conversion doesn't recognize it's crossing pages.
Hi Shane, long time no speak :-) Hope you are well. As always thank you for your excellent videos. I am working on something to produce a pdf report based on powerapps data and am wanting to add the company logo to the top. I've added the logo to a variable using the JSON mentioned in this video (Set(VarCustomerlogo, JSON(LookUp(MyDataSource, Title = "MyCompanyName",Company_Logo), JSONFormat.IncludeBinaryData))) and have added the HTML () but my PDF just shows the border of a box with a red cross at the top. I must be doing something wrong but have gone back over your video and can't spot the error - any ideas?
Hallo Shane. Very nice tutorial. Is there also a way, to make a Report from a filtered Gallery. One Or two lines as a formated form in html to bring it in the Flow to Generate a Report?
Stefan did you see this video where I dive into Table Data? ruclips.net/video/bfXV_GXc_JM/видео.html You can apply a Filter inside the Concat and get what you want. :)
Can the html in powerapps also be used where powerapps has a multi choice selection. I cannot seem to get rid of the error generated. e.g Location has 5 location to select from in an inspection app, but when writing the html code in powerapps all i get is an error
OMG!!!!! I got it. GPT 4 FTW! Here's what we did - To add items from a collection to your HTML invoice in Power Apps, you need to dynamically generate the HTML table rows for the line items based on the collection. Since Power Apps doesn't natively support looping through collections in a single HTML text control, you will need to generate the HTML for the table rows dynamically using Power Apps functions. Here's how you can do it: Prepare Your Collection: Ensure you have a collection with the necessary properties, such as ExpenseName, Description, and Expense. Generate HTML Table Rows: Use the Concat function to concatenate the HTML for each item in the collection. This will dynamically generate the table rows.
What if I want to include an image that I don't want the user to see until the image is generated? Just create an image in the app and make the image visible property to false?
See if this video helps. PowerApps Send email - Everything you need to know about sending mail via Outlook and Power Apps ruclips.net/video/vpYkOccwn4Y/видео.html I show getting emails from Dropdown which is similar idea.
Great video Shane. Have you played around with the $-string function in the newer authoring version builds? Seems to be some lack of consensus on whether it will work for HTML Text controls or not, but could make writing this dynamic code a little less painful.
2 года назад+1
$-string works fine with html text controls as well, since it just needs a string as the result, you can concatinate such string the way you like. ;) With( { MyTable: [ "First is ❤"; "Second is 🚀"; "Third is a 🐢"; "Last but one is 🥂"; "Finally 🍺" ] }; $" {First(MyTable).Value} {Index(MyTable;2).Value} {Index(MyTable;3).Value} {Index(MyTable;CountRows(MyTable)-1).Value} {Last(MyTable).Value}" )
Thanks! I haven't kicked the tires on $-string stuff yet. I try to avoid features that aren't main stream yet, now that I think everyone has it I should dive in and see what happens.
YOu don't have to move the file. The 3rd step you can create the file in SharePoint or any other file location. The Create HTML file and Conver file actions have to be OneDrive for Business, then you can do anything you want. :)
Thank you for the tutorial, Shane! I have HTML content with special characters (e.g. Chinese/Korean text) but whenever the .HTML file is converted to PDF it shows up as ■■■■■■■■. Is there a way to handle this use case? Would appreciate the help!
I have never had to deal with it but you aren't the first person to report other characters don't cover right. 😔 I don't know what the work around is. Maybe try one of the 3rd party conversion tools? Sorry.
One last thing. If anyone has issues with the PDF conversion... A great workaround is to add a print button that goes invisible when clicked so it does not show on the printed doc. Then just print to PDF and save to sharepoint. I know that's not automated etc, but a friend of mine brought it up as an idea when I was getting frustrated with my html formatting. Luckily GPT4 resolved that for me, but it worth noting that print to PDF will still get you a PDF doc with dynamic properties from your app. Which is the goal, right?
Now my boss is so excited she wants some multipage docs to also be populated like the one page invoice I just made. I don't think this method works for a multipage doc. Or am I wrong there? I see some things online from Andrew Hess about a free way to populate a word doc using content types. I might give that a try. Do you have any videos on that as well? Yours are better hehehe!@@ShanesCows
Hi there Shane Your videos are always insightful and great to watch Hope you could help with this one with there being no information about this. I am trying to grab a SharePoint PDF attachment convert it to code 64 in order to send it in a response via HTTP Think you could figure this one out?
@@ShanesCows It did not. It said "Click to Download" and was a long JSON. but took a different approach. So when the file is first uploaded I convert PDF to code64 and store it in a column. When the flow is called I read it out of that column. It reduces the response time as well. But having other issues now with trying to get nested field layers down and struggling a bit lol - but I am sure I will eventually figure it out. Would have been cool to jump on a Teams call with you, but I know you a busy man. Thanx for the reply man appreciate it
Hello Shane; thanks for this awesome video!!! There is any way to generate powerpoint from template in sharepoint list or lib with power automate; whitout premium?
Hello Shane! I would like to ask how can I create an HTML file using PowerAppsV2 trigger. I have defined the parameters but when the flow begins it doesn´t recognizes the HTML file parameter. The reason I need PowerAppsV2 trigger is because I need to ask for more variables. Appreciate your help!
Hi Shane, Thank you for this video, I created the app, and the flow. But the thing is, my data is not coming in pdf, in html file all are working as expected. Could you please help here
Awesome video Shane. Can I ask if we could use Sharepoint document library to store created PDF file instead of using OneDrive? If we could use Sharepoint document library then I do not need to create the same folder location in Onedrive for all application users.
Anyone have an issue of random instances where the pdf has "show your html text here" it seems that power app sometimes fails to send flow information.
That has never happened to me but I have heard of it for others. 😑 Usually the app was too busy to keep up or a hidden control kind of thing. Not sure but you are not alone.
Hello Shane, have you a solution without premium connectors or third party connectors with subs, with HTTP request to SP for example, to merge 2 PDFs ?
Hi Shane, Your video's are so, so, helpful! I'm stuck on one item though. Trying to print item that has multiple selected items in one field from drop down choices. When I try to enter .value after the code, it keeps erroring out. How can I write this to display all the selected choices? " & Gallery1.Selected.ViolenceTypes.Value & " is erroring out. Can you offer a solution to capture the multiple choice answers for this field? Thanks.
So I need about 1000 images to create a pdf report. I need to use base64 but the data column in SharePoint shows the list down to a crawl. How do get around that?
The free PDF conversion process shown here has a file size limit of about 2 MB total 🫤 So no way you are getting a 1000 images in there. Probably not even 10. If you need that massive of a PDF you will need to look at on of the 3rd party tools, I think I mention at the end of the video.
@@ShanesCows yeah. I’ve scratched my head on that limitation. It’s for building a punch list app with photos. I’ve been down on my luck with finding an alternative solution, to the point where 7 months of development, 5 of those was dealing with this pdf issue. What is your recommendation? I’ve thought of getting a hosting site just for images, or sadly scrapping the whole thing and redoing it as a browser version. ::Shrug::
Dear Shane - I learned a lot from your videos and made good progress. Thank you! But today I am really fcked up.. My App and flows work almost perfectly but obviously there is no stock solution to convert files >2MB. I felt like beeing on the last meters to my goal but now it feels like I am lightyears apart from that.... Do you have any good Idea of fow I can use a report in HTML format with pictures in it into a PDF? Thanks for your support! Felix
Hi , Is It possible to save a record of Model driven app with entire data in it as PDF ? IF yes how to save that record as PDF in Model driven app. Reply is much appreciated. Thank you.
Great content, can you please kindly make a video tutorial with detailed steps on how to make a workflow in Powerapps for the following thing suppose there is a work order form for a company with several fields like Billing, E-mail IDs, etc etc and the workflow should be created in such a way that the work order form can be edited, updated accordingly by some specific concerned persons in the company whose email ID will be linked in the workflow in Powerapps, Please kindly have a look into the request, also wishing you and your family a very happy Easter from Kolkata, West Bengal, India, God bless all
Happy Easter to you also. 🐶 You will need a Power Apps app to facilitate most of this. I would start there and only incorporate flow if necessary. Check out this for an example. ruclips.net/video/49O284deOAI/видео.html
Hi Shane,I watched many of your video and they helped me lot❤, but we find out one problem for the PDF generated , the line will be separated if the PDF is over one page. One line will be separated into two part , half of them in the first page , another half in another page. How this can be resolved? We also tried find out some resolution but failed.
Is it possible to just take a file, convert it and save it to SP. I'm getting "Conversion of this file to PDF is not supported." It seems they broke Convert File in 2018 and no solution seems to work. I don't wanna go to power apps, convert to html, save the file, convert it again to pdf etc
@@ShanesCows Thanks for the reply Shane, mainly Excel files. My tests were done with xlsx. PS they don't want to get my coworker another paid license for the N other premium actions available since they already paid for his Power Automate Plan 2
Conversion of this file to PDF is not supported. (Sandbox_HtmlTransform_InvalidOperation / An exception occurred while executing within the Sandbox) :(
Hi Shane, great video, if it's possible I have a question for you, is it possible to rename the PDF file name dynamically?, for example using the employee's last name or another gallery field? tks in advance
I think the question is in the flow part can the file name be dynamic? You could put a get items Sharepoint step before this and add ‘Created by’ to the name and ‘Created’ to that box
I can't seem to be able to avoid using OneDrive. In my Teams environment some of the users have guest status and have access to Sharepoint but not to OneDrive. Once I connect the flow using OneDrive these users loose access to the created app. Is there any way to get PDF to a Sharepoint folder without having to use OneDrive??
@@ShanesCows Ok, I just checked and the new PDF function covers all the PDF-making needs I had! :D No Flow modules required. You just point to a container or gallery and get a PDF. It also supports scrollable galleries or containers that go beyond the extents of the page. Finally!
This is (almost) exactly what I've been looking for. The only thing you didn't cover was dynamically naming the PDF file. For example, how would you include the employee's name as part of the PDF file name so that you would have unique file names for each PDF?
Excellent video!! Thank you!. How would you change the hello.html/hello.pdf to save it under the name of the record. IE in this example under Greg's name ? Thank you.
Dear Shane Can you please add a video on how to add a footer to pdf document generated in this video , I did generate a pdf with a logo but failed to add fixed position footer to my doc . Can you please help me with this.
What does your code look like? I don't follow. It is an art getting it to look exactly how you want. Or, if you are struggling with page size check out this video on Page Breaks ruclips.net/video/YkSNg7B_rps/видео.html might help.
Thank you soo much Shane for this incredible video!❤🔥 This helped me solve my work of converting customer form to pdf document. Shane now I want to save the pdf by the customer name. For example CustomerName.pdf. How do you dynamically grab the customer name from the customer text field in powerapps and populate it in the place of hello.pdf. Can you please make a video on it? It will be highly appreciated! or guide me to the right Microsoft documentation🙂 Thanks again!! Your videos are super helpful as always!!🙂
Hi Shane, great video as usual. In my HTML text I'm attempting to pull data from multiple galleries which are linked to multiple SharePoint lists. In SharePoint I have a primary list using its ID as a primary key and foreign key to my other lists. In my HTML text when I filter to get multiple items where my primary key is foreign then I get Invalid number of arguments: received 1, expecting 2 or more.... here is my filter: Filter(Transport.travel_request_id = selectedID), where Transport is my list and travel_request_id is my foreign key and selectedID is a variable set to my primary key. Please help, thank you.
@@ShanesCows the comma didn't work as well, so I ended filtering into a collection then reading from there. Thank for coming back to me much appreciated.
You're the MAN Shane! I took your advice and watched this. Then I got on chat GPT 4 and uploaded an existing PDF template, asked it to make it into HTML, and a few cleanup prompts later I had a working HTML template complete with place holders for my dynamic client data. AMAZING! now I just need to make the flow to convert and save it. The easy part.
I love this so much! Great job! 🤩
Thanks Shane. I just completed it and had a beer. Cheers to you for making all this possible. What a great hack on that html control. Makes getting the document set correctly a breeze@@ShanesCows
So, this is the 5th PowerApps911 video that I have watched today. I am focusing on components and making pdfs. They all have been extremely helpful and have saved me time. Thanks!
Wonderful!
AMAZING!!! I've been struggling for days now trying to find an easy free way to accomplish what you just showed us. Thank you Shane!
Happy to help. Have a great day. 🐶
Thank you Shane! I have a technical test for a new job I'm applying for, your video helped me a lot. Greetings from Central America.
Good luck on your test! You will do awesome 🤩
I studied HTML code all week and I finally got this working Shane! TY Again! one more thing crossed off.
Awesome. 🤩
Thanks!
I am starting in this world of Power Apps and the videos have been very helpful.
Awesome, glad to help on your journey. Be sure to check out training.powerapps911.com if you want more structured learning also. 😎
Yes! Got it to work! Now I need to see about using one of the third party converters because I really need it to be landscape. Awesome video!
Awesome Pam. I think Cloudmersive or Encodian is the first 2 you should look at. 😎
I love Power Apps. I hope back to Power Apps sometime. Greetings from Chile 🇨🇱
Have a great day José! 🐶
Good job pretty much anticipating all of the questions I was going to ask: first off if there's a way to do it without One Drive for Business and instead creating the html file in a Sharepoint Library and then converting it to PDF. Second was the landscape question since I want to ultimately create a shipping label for our Logistics Department. It's been a year since this video so maybe there's a more updated solution, but thanks for the video!
Thanks Shane
Another one of those common asks. Glad you covered the limits at the end to. As that trips up a lot of people.
Some times I wonder if one day things like thos would be easier and that certain features supported the same html rules. I can only dream I guess.
That would be amazing! The fact that the HTML rules are so radically different across the platform is exhausting quite frankly. 😵💫
@@ShanesCows email clients is flying of html in email is just as bad. Outlook desktop being one of the worst as it strips out certain tags. Yet the web version doesn't. 😜 Hopefully on the road to getting that fixed.
Great video as always. Thank you Shane. I'm wondering how I can use the title Label in PowerApps as the filename for the PDF.
Set your flow up to Ask in Power Apps for the file name. Then pass the labels text as that input.
Hi Shane, if you connect this with a form you can also pull all the attachments through and attach to the email if you pass through the List ID to flow from PowerApps.
Also I create the new file in SharePoint add metadata to the file and then attach a copy of the file to the list item tying it all together with a GUID()
Thank You Shane for the lovely video - I have a use case where the image in a certificate template which has 3 to 4 items that I would like to populate in the blank spaces. Since this is an image and I need 3 to 4 text boxes on the top of it, how can I make that happen. Any help is much appreciated.
I don't have the exact answer, you are going to have to fiddle with the HTML until you find a pattern that gets you the output you need. Maybe ask ChatGPT for ideas?
Shane - you always bring the gravy!
Happy to help. Have a great day. 🐶
This is great. Is it possible to use powerapps and automate to fill in existing pdf templates with user data that are in a SharePoint?
Great video, this might just solve two issues/requirements I currently have with one apps.
Thank you for your new lesson.. that was awesome !!
Hi Shane, thanks again for your great video!
Just wondering if part of a SharePoint page can be converted to PDF or Picture using Power Automate please?
Not directly sorry
Thanks Shane, you're the master!
Appreciate that :)
Hi there, great content. I am new to powerapps. I am looking to create a power app from a Sharepoint List that uses a flow to create a pdf sent by email. Do you have any videos on that? Cheers
I don't have anything exact. If I was you I would do things in this order.
1 - Build a POwer Apps app using SharePOint that collects and interacts with the info you want. Once it works
2 - Build a flow that makes a PDF from your data by pressing a button in the app. Get it looking the way you want. Once it works.
3 - Add to the flow the ability to attach that file to an email.
Solve small problems and you got this! 🤩
Hi Shane. Thanks for another awesome video!
I've watched a couple of your tutorials on this now and almost everything works, except the 'Convert File' or 'Convert file using path' steps are outputting a generic file instead of a PDF.
The files are named filename.pdf using a dynamic input from PowerApps through a compose step to create the name.
Do you have any idea why I can't generate a .pdf output please?
After extensive searching all I can find is a suggestion that the Microsoft converter is unreliable, but can you suggest anything else please and thank you?
You should have 3 steps.
Create file in OneDrive - This should be an HTML file with an HTML extension
Convert file - This should use the ID of the file you created in the previous step
Create file in OneDrive - This should be the output of the Convert file plus a name like Buddy.PDF
Confirm the HTML file is correct.
Remove anything dynamic and try with hard coded names and such.
The process should work 100% of the time in this simple scenario, get that to work then troubleshoot.
@ShanesCows Thanks Shane.
It turned out to be a connections issue in the end.
After deleting and adding the connections again, removing and re-adding the Flow to PowerApps, everything seems to be working and I'm creating a PDF. 🤷♂️
Thanks for another great video. I will definitely try out the image part
Great video, Shane! I have followed this step by step and having issues with the images coming through on the PDF. The text and all come through just fine from PowerApps into HTML, and then into PDF....all except the images. I was super excited to try this short cut. Any troubleshooting ideas? BTW, I can see the images when I open the HTML file.
same here
Same here.
it worked for me when I've removed the quotes from html, it looks strange but the quotes are generated by Shanes JSON so the code looks like:
Thanks Shane, please continue share your knowleadge. Rgds
Hi Shane, Nice video clears basic concept. But would you have or can you make a video similar to this but instead of using HTML codes to create pdf file it should call a flow which fills up my predesigned word or pdf file.
Maverick it is on my far out list of videos. I have never had a project where I have had to populate a project so I don't have any first hand experience. My team has done it but I haven't. 😐
Hey Shane. Great video! You do a great job of breaking it down and being entertaining. Is it possible to select multiple Gallery fields? In your example, could you select you and Chewy?
William, Yes! You will need to adapt the concept in this video. ruclips.net/video/0xZ4fMJbLvk/видео.html
Hola! Muchas gracias por sus videos!!! Le saludo desde Guatemala! Con una consulta, cómo se puede adjuntar varios archivos con html? Desde ya muchas gracias
In this video I talk about sending emails including attachments. Does that help? ruclips.net/video/vpYkOccwn4Y/видео.html
If you are trying to attach files to the PDF then I do not know how to do that. Sorry.
Hello Shane, if you have a child/repeating table ... can I save the html data in a parent field to be used later in a created pdf or re-opening in power apps? I saw a example of a Nintex Form saving the repeating table info as XML in a sharepoint parent list 'more lines field'.
This is a great video. How would you dynamically compute the file name and also how would you pull other information from the gallery over so you can use it it in the rest of the flow, such as email addresses that you have within the gallery. thanks.
How can I also do this?
This is the bit I am struggling with- help us out Shane!
Hi Shane, I really appreciate you putting this content out on RUclips, I've used many of your videos for inspiration. I've looked high and low and cannot find out how to control the page size of the PDF when going thru this process, no matter what I do in the HTML. Is there documentation out there? Is that something you address in any other video?
The only luck I have had is inserting Page Breaks. ruclips.net/video/YkSNg7B_rps/видео.html All of the other page manipulation stuff doesn't seem to work unless you use one of the 3rd party tools.
As always, you have the answers! One question, can you share how we can bring the name of the doc generated in Powerapps over as the filename (that will obviously be dynamic). I've tried a gazillion different ways and am reaching the crazy side of efforts...
In this really old video I show how to respond from flow. Different topic but same concept. I will put responding to Power Apps on my to do list. :) ruclips.net/video/ovLIwnj6QjU/видео.html
Thank you for the video. Is it possible to add a signature block that allows using government smart ID card (PIV)? Can you show example of it?
Not that I know of. Sorry
Hi Shane, great video, say you wanted to select 3 of the Employees from the Gallery and print their details in an ordered or unordered list how do you do that? add them to a collection then put the collection info into the HTML code for HTMLtext box? I can't seem to get the syntax right!!
Shane, Thanks for the useful videos. Request you to share a video about the Indian Rupee comma format
thank you for your help that is exactly what I'm looking for ..but I have a question how do you link the icon of the pdf in the items to the html page that you want to generate.. so what I meant is how it generate the exact item data I need!!
Hai Shane, in this episode I'm very interesting in getting image to PDF. How about, there is multiple images. How can i implement using JSON Function?
ruclips.net/video/bIne3DD3HAg/видео.html You can have multiple small photos, handle each one individually like the video shows.
Hi shane! Using this same methodology can we build pdf using data from different SharePoint lists which are connected using referal ID. Actually my requirement is to build a payslip of the employees but i also want to display their leaves taken and leaves balance which is stored in another list. Could you please suggest me something regarding this??
Yes, use the Concat function and adding looking or nesting as necessary. ruclips.net/video/AnERfGIE8gw/видео.html
Hey Shane! Thanks for the video! Is it possible to do this just through Power Automate? Creating a flow specifically pulling images and data from Sharepoint and creating a PDF for each row item in Sharepoint?
Hi mate. Have u done that? I am with the same situation...
Hi @shane - how would you do this if you wanted to produce a report for each employee in one click?
Hi . . . I'm looking to use the HTML box, but without the Gallery. I've been able to display fields correctly with just the DataCardValue.Text working. However, I can't get a people picker field to display correctly. I've tried many things like DataCardValue.DisplayName, but nothing is working. I'm surprised it isn't the same as with the Gallery syntax, like DataCardValue.'People Field'.DisplayName or something similar. Any insight is appreciated. Thank you for all your great videos.
Excellent video. Is there a way to either split the psf output into 2 columns on 1 page, or to justifiy some to the left and some to the right on the same row. I have uswd style left and float right but that doesnt seem to work when converted, same with setting width and height to an image
Yes, you just need to try a bunch of different stuff. The easiest way is to make a table and use inline styles. Let your table define the layout and put your pieces in. Float doesn't work I don't think. Images sizes can be set with width and height px I am pretty sure.
Awesome Video Shane! When I move a a solution from Dev Environment to Test Environment, the same flow also moves to the Test Environment but the print button doesnt work. Since the Test Environment is a managed solution, if I edit it, it creates an unmanned layer. Have you noticed it doesnt work in a different Environment? Do you know how I can move it to another environment and make the print flow feature work? Thank you!
Hmmm... I haven't ran into that. I don't have an answer but I will try to think about that next time I am playing with Solutions.
Thank you Shane. In using the OneDrive- is it always the users OneDrive or is it always my OneDrive that the user is accessing when they access that flow? I’m just curious how that works because I would have to have a folder that everyone in my organization had the same named folder for the flow to work if it was accessing their OneDrive.
The user is always using THEIR OneDrive. If the folder you specify in the flow doesn't exist the create file process will automatically create it for them. 😎
@@ShanesCows thank you! Saves me from having to test ot out with someone.
Hi Shane, thanks very much for your content. Could you make a video showing how generate a PDF file from a SharePoint page? Thanks again
Great video! However, when I try styling HTML such as aligning some text and giving text background color I can see it in Power Apps. But somehow that part doens't come through in the PDF. Am I missing something?
The conversion engine uses different HTML rules. Try inline styles. It is all possible just have to keep trying different ways till you find the one that works. 😐
Wow, thank you so much, Shane! Your solution is brilliant and worked perfectly on my OneDrive. However, when I tried saving the PDF to SharePoint, the file appears in the folder but won't open-it says 'Error on file.' Do you have any idea what I might have missed? 🤷♀
Nothing jumps out at me. Assuming you mean the 3rd step, Create File, you are doing that in SP not OneDrive. Should just work. Hmmm.
@@ShanesCows I found a solution :-) Thank you for answer 🙂
Hi @ShaneYoung, I want to get the export of all the gallery Items and including their attachments of those gallery records and create a PDF just like you having all the records appended.
I am confused any idea?
Another awesome video, thanks! Do you have a video on how to make the file name dynamic?
Mine will create 2 files the HMTL and the PDF file but for some reason the PDF is blank. Any idea what causes this? Is there a step at the end that can either open the file location or the good file to print without going the long route?
Look at your html. You have a bad or missing tag most likely
Hi Shane, Great Video...big fan from India....
I have two issues where i need your help:
1. How to do for SharePoint list with image attachments (or multiple images)
2. I have copied exactly how you did, but my flow error is occurring in the last two steps of the flow, The flow test is successful but when i run the PowerApp the flow is getting failed..
Thanks in Advance
Have you solved your problem???
No bro....if you can solve...please ping me
Good video and great explanation.
But tell me one thing that how can I download this pdf file directly in my local system from powerapps
I have never tried the Download function but worth a go docs.microsoft.com/en-us/power-platform/power-fx/reference/function-download
Hi ALL, quick question, I performed the Flow as outlined in the video, when I ran the flow it creates the HTML File ( I can open and see it in a browser) , but won't convert to PDF,... this is the error
"ERROR Details : Conversion of this file to PDF is not supported. (Sandbox_HtmlTransform_InvalidOperation / An exception occurred while executing within the Sandbox) "
Is it possible in Powerapps, to have a button that takes a screen shot of the final screen in an app, and make it a pdf to store in a OneDrive folder?
Not really. The one thing you could look at is maybe print to pdf? ruclips.net/video/JMhVtII5hQs/видео.html
Great video, Shane! Thank you for this! I wanted to make use of that laying two images on top of each other. However, even though the HTML looks perfectly fine, the images display one after the other in the PDF after the conversion process. Is this also due to the restrictions of the free integretated PDF converter or did you manage to do this with your presented method? Thanks again for your videos, they are very helpful!
Hello Shane! Thanks for putting so much information for us about PowerApps. I wanted to ask bout using SharePointIntegration instead of Gallery1.Selected. I have tried a way to use the SharePoint integration to use dynamic information based on selected itmes but cant get it to work :(
Hey Shane. Awesome video. Thanks for showing the conversion process with the power apps V2. Quick question. Is there a way to show the file size limit before the user exports to PDF. That way they know if the amount of information they are taking out is too much and they need to cut down their selection?
So, I'm assuming if you loop through a list with many entries since it's html it will span multiple pages? Now if we could get external style sheets to work that would be awesome.
Yup, this video talks about the looping. ruclips.net/video/bfXV_GXc_JM/видео.html
@@ShanesCows Is there any fix to pagination? I often have a file that has a table that goes into a second page. The last item on the first page gets cut in the middle because the conversion doesn't recognize it's crossing pages.
Hi Shane, long time no speak :-) Hope you are well. As always thank you for your excellent videos. I am working on something to produce a pdf report based on powerapps data and am wanting to add the company logo to the top. I've added the logo to a variable using the JSON mentioned in this video (Set(VarCustomerlogo, JSON(LookUp(MyDataSource, Title = "MyCompanyName",Company_Logo), JSONFormat.IncludeBinaryData))) and have added the HTML () but my PDF just shows the border of a box with a red cross at the top. I must be doing something wrong but have gone back over your video and can't spot the error - any ideas?
James try this video. You need dthe base64 and I don't think the lookup is getting what you think it is. :) ruclips.net/video/bIne3DD3HAg/видео.html
Hallo Shane. Very nice tutorial. Is there also a way, to make a Report from a filtered Gallery. One Or two lines as a formated form in html to bring it in the Flow to Generate a Report?
Stefan did you see this video where I dive into Table Data? ruclips.net/video/bfXV_GXc_JM/видео.html You can apply a Filter inside the Concat and get what you want. :)
Can the html in powerapps also be used where powerapps has a multi choice selection. I cannot seem to get rid of the error generated. e.g Location has 5 location to select from in an inspection app, but when writing the html code in powerapps all i get is an error
You need to use concat Concat(combobox1.SelectedItems, Value, “;”) that would write them semicolon separated.
OMG!!!!! I got it. GPT 4 FTW! Here's what we did - To add items from a collection to your HTML invoice in Power Apps, you need to dynamically generate the HTML table rows for the line items based on the collection. Since Power Apps doesn't natively support looping through collections in a single HTML text control, you will need to generate the HTML for the table rows dynamically using Power Apps functions.
Here's how you can do it:
Prepare Your Collection: Ensure you have a collection with the necessary properties, such as ExpenseName, Description, and Expense.
Generate HTML Table Rows: Use the Concat function to concatenate the HTML for each item in the collection. This will dynamically generate the table rows.
You might enjoy this video where I have some concat chaos fun for html :) ruclips.net/video/AnERfGIE8gw/видео.html
Swweeeeet! TY!!!! PS. I am very close in prucring funds for your classes. ;)Chat soon I guess.@@ShanesCows
What if I want to include an image that I don't want the user to see until the image is generated? Just create an image in the app and make the image visible property to false?
That should be fine. :) Or because you will have the base64 you don't have to display it. Remember base64 is the key to images in PDFs.
Hi Shane. I am very grateful for your videos. You're my hero. Just one question: how do I make the email go to an account that is in the gallery?
See if this video helps. PowerApps Send email - Everything you need to know about sending mail via Outlook and Power Apps
ruclips.net/video/vpYkOccwn4Y/видео.html I show getting emails from Dropdown which is similar idea.
Thanks so much, Shane. Best regards from España.
Great video Shane. Have you played around with the $-string function in the newer authoring version builds? Seems to be some lack of consensus on whether it will work for HTML Text controls or not, but could make writing this dynamic code a little less painful.
$-string works fine with html text controls as well, since it just needs a string as the result, you can concatinate such string the way you like. ;)
With(
{
MyTable: [
"First is ❤";
"Second is 🚀";
"Third is a 🐢";
"Last but one is 🥂";
"Finally 🍺"
]
};
$"
{First(MyTable).Value}
{Index(MyTable;2).Value}
{Index(MyTable;3).Value}
{Index(MyTable;CountRows(MyTable)-1).Value}
{Last(MyTable).Value}"
)
Thanks! I haven't kicked the tires on $-string stuff yet. I try to avoid features that aren't main stream yet, now that I think everyone has it I should dive in and see what happens.
Very fun Kristóf. I love With so much. 😍
How would you then move that file from OneDrive to a SharePoint library in flow?
YOu don't have to move the file. The 3rd step you can create the file in SharePoint or any other file location. The Create HTML file and Conver file actions have to be OneDrive for Business, then you can do anything you want. :)
Thank you for the tutorial, Shane! I have HTML content with special characters (e.g. Chinese/Korean text) but whenever the .HTML file is converted to PDF it shows up as ■■■■■■■■. Is there a way to handle this use case? Would appreciate the help!
I have never had to deal with it but you aren't the first person to report other characters don't cover right. 😔 I don't know what the work around is. Maybe try one of the 3rd party conversion tools? Sorry.
@@ShanesCows Gotcha. Appreciate the response!
One last thing. If anyone has issues with the PDF conversion... A great workaround is to add a print button that goes invisible when clicked so it does not show on the printed doc. Then just print to PDF and save to sharepoint. I know that's not automated etc, but a friend of mine brought it up as an idea when I was getting frustrated with my html formatting. Luckily GPT4 resolved that for me, but it worth noting that print to PDF will still get you a PDF doc with dynamic properties from your app. Which is the goal, right?
I like it
Now my boss is so excited she wants some multipage docs to also be populated like the one page invoice I just made. I don't think this method works for a multipage doc. Or am I wrong there? I see some things online from Andrew Hess about a free way to populate a word doc using content types. I might give that a try. Do you have any videos on that as well? Yours are better hehehe!@@ShanesCows
Hi there Shane
Your videos are always insightful and great to watch
Hope you could help with this one with there being no information about this.
I am trying to grab a SharePoint PDF attachment convert it to code 64 in order to send it in a response via HTTP
Think you could figure this one out?
If you use the flow action Get File Content for the SharePoint file does that give you the base64? I am 99% sure it does. :)
@@ShanesCows It did not. It said "Click to Download" and was a long JSON. but took a different approach. So when the file is first uploaded I convert PDF to code64 and store it in a column. When the flow is called I read it out of that column. It reduces the response time as well. But having other issues now with trying to get nested field layers down and struggling a bit lol - but I am sure I will eventually figure it out. Would have been cool to jump on a Teams call with you, but I know you a busy man.
Thanx for the reply man appreciate it
Hello Shane; thanks for this awesome video!!! There is any way to generate powerpoint from template in sharepoint list or lib with power automate; whitout premium?
I don't know. I have never tried. I don't have any good ideas off the top of my head. Sorry.
Nice video, can you have the pdf in landscape instead of portrait, this can be helpful for wide range of columns that span across an invoice.
I talk about this at the end. You have to use a 3rd party tool to do that.
Hello Shane! I would like to ask how can I create an HTML file using PowerAppsV2 trigger. I have defined the parameters but when the flow begins it doesn´t recognizes the HTML file parameter.
The reason I need PowerAppsV2 trigger is because I need to ask for more variables.
Appreciate your help!
Hi Shane,
Thank you for this video,
I created the app, and the flow.
But the thing is, my data is not coming in pdf, in html file all are working as expected.
Could you please help here
You have a typo in your HTML. Look at it closely. You are missing a closing tag or something similar.
@@ShanesCows Thank you so much😃😃😃
I missed one double quotes, now it worked 🎉
Awesome video Shane. Can I ask if we could use Sharepoint document library to store created PDF file instead of using OneDrive? If we could use Sharepoint document library then I do not need to create the same folder location in Onedrive for all application users.
Yes, the Create File portion at the end (3rd step) can be created any where you want, like a SharePoint document library.
Anyone have an issue of random instances where the pdf has "show your html text here" it seems that power app sometimes fails to send flow information.
That has never happened to me but I have heard of it for others. 😑 Usually the app was too busy to keep up or a hidden control kind of thing. Not sure but you are not alone.
Hello Shane, have you a solution without premium connectors or third party connectors with subs, with HTTP request to SP for example, to merge 2 PDFs ?
I don't, the only way I know to merge is with premium. SOrry
@@ShanesCows Ok thank you but my client doesnot take premium licensing. Otherwise, is it possible to create a Page break in HTML?
Hi Shane, Your video's are so, so, helpful! I'm stuck on one item though. Trying to print item that has multiple selected items in one field from drop down choices. When I try to enter .value after the code, it keeps erroring out. How can I write this to display all the selected choices? " & Gallery1.Selected.ViolenceTypes.Value & " is erroring out. Can you offer a solution to capture the multiple choice answers for this field? Thanks.
I found an answer that worked. " &Concat(Gallery1.Selected.ViolenceTypes.Value, Value &", ")& "
Good Job Linda. i was going to answer Concat. :) Glad you found it.
Hi, can i know how to send email dynamically based on manager name that input in powerapps?
So I need about 1000 images to create a pdf report. I need to use base64 but the data column in SharePoint shows the list down to a crawl. How do get around that?
The free PDF conversion process shown here has a file size limit of about 2 MB total 🫤 So no way you are getting a 1000 images in there. Probably not even 10. If you need that massive of a PDF you will need to look at on of the 3rd party tools, I think I mention at the end of the video.
@@ShanesCows yeah. I’ve scratched my head on that limitation. It’s for building a punch list app with photos. I’ve been down on my luck with finding an alternative solution, to the point where 7 months of development, 5 of those was dealing with this pdf issue. What is your recommendation? I’ve thought of getting a hosting site just for images, or sadly scrapping the whole thing and redoing it as a browser version. ::Shrug::
Dear Shane - I learned a lot from your videos and made good progress. Thank you!
But today I am really fcked up.. My App and flows work almost perfectly but obviously there is no stock solution to convert files >2MB. I felt like beeing on the last meters to my goal but now it feels like I am lightyears apart from that....
Do you have any good Idea of fow I can use a report in HTML format with pictures in it into a PDF? Thanks for your support! Felix
Felix you will have to go with one of the 3rd party tools. Either Encodian or Cloudmersive would be my recommendation. Sorry, wish I had better news.
Hi ,
Is It possible to save a record of Model driven app with entire data in it as PDF ? IF yes how to save that record as PDF in Model driven app. Reply is much appreciated.
Thank you.
Great content, can you please kindly make a video tutorial with detailed steps on how to make a workflow in Powerapps for the following thing suppose there is a work order form for a company with several fields like Billing, E-mail IDs, etc etc and the workflow should be created in such a way that the work order form can be edited, updated accordingly by some specific concerned persons in the company whose email ID will be linked in the workflow in Powerapps, Please kindly have a look into the request, also wishing you and your family a very happy Easter from Kolkata, West Bengal, India, God bless all
Happy Easter to you also. 🐶 You will need a Power Apps app to facilitate most of this. I would start there and only incorporate flow if necessary. Check out this for an example. ruclips.net/video/49O284deOAI/видео.html
Hi Shane,I watched many of your video and they helped me lot❤, but we find out one problem for the PDF generated , the line will be separated if the PDF is over one page. One line will be separated into two part , half of them in the first page , another half in another page. How this can be resolved? We also tried find out some resolution but failed.
Is it possible to just take a file, convert it and save it to SP. I'm getting "Conversion of this file to PDF is not supported." It seems they broke Convert File in 2018 and no solution seems to work. I don't wanna go to power apps, convert to html, save the file, convert it again to pdf etc
What type of file are you trying to convert? Some of the 3rd party conversion tools support more file types.
@@ShanesCows Thanks for the reply Shane, mainly Excel files. My tests were done with xlsx.
PS they don't want to get my coworker another paid license for the N other premium actions available since they already paid for his Power Automate Plan 2
Is the file comvert still only a 2mb limit?
Conversion of this file to PDF is not supported. (Sandbox_HtmlTransform_InvalidOperation / An exception occurred while executing within the Sandbox) :(
I have never seen that error. I would look at your HTML. It has to be well structured or the process gets mad.
It doesn't allow flexbox it looks like :(@@ShanesCows
Hey Shane or other knowledgeable people. Which step of the conversion is the limiting factor for 2MB?
Hi Shane, great video, if it's possible I have a question for you, is it possible to rename the PDF file name dynamically?, for example using the employee's last name or another gallery field? tks in advance
Yes, Gino. The filename portion that you send to flow is just text. It can be anythign you want. Like: User().FullName & " PDF file.PDF"
@@ShanesCows Any chance you could explain this a little more?
I think the question is in the flow part can the file name be dynamic? You could put a get items Sharepoint step before this and add ‘Created by’ to the name and ‘Created’ to that box
I can't seem to be able to avoid using OneDrive. In my Teams environment some of the users have guest status and have access to Sharepoint but not to OneDrive. Once I connect the flow using OneDrive these users loose access to the created app. Is there any way to get PDF to a Sharepoint folder without having to use OneDrive??
There is no convert action in SharePoint. 😑 Free pdf is only coming from OneDrive.
@@ShanesCows Any way to somehow export data not fitting on the screen with the new experimental "PDF" function in Power FX?
@@ShanesCows Ok, I just checked and the new PDF function covers all the PDF-making needs I had! :D No Flow modules required. You just point to a container or gallery and get a PDF. It also supports scrollable galleries or containers that go beyond the extents of the page. Finally!
Hey Shame, have you considered using the word online connector? I used to generate HTML document and just moved on from it
This is (almost) exactly what I've been looking for. The only thing you didn't cover was dynamically naming the PDF file. For example, how would you include the employee's name as part of the PDF file name so that you would have unique file names for each PDF?
i used Get items from the sharepoint list in power automate to assign the value in to the file name, then apply to each before make file 2.
Excellent video!! Thank you!. How would you change the hello.html/hello.pdf to save it under the name of the record. IE in this example under Greg's name ?
Thank you.
Dear Shane
Can you please add a video on how to add a footer to pdf document generated in this video , I did generate a pdf with a logo but failed to add fixed position footer to my doc . Can you please help me with this.
Not easy. Get some ideas of controlling the page with this video. QTT - Power Automate PDF Page Breaks
ruclips.net/video/YkSNg7B_rps/видео.html
Thanks for Youth reply , much appreciated
I have used this code but the format doesn't PDF the entire HTML page? what am i doing wrong?
What does your code look like? I don't follow. It is an art getting it to look exactly how you want. Or, if you are struggling with page size check out this video on Page Breaks ruclips.net/video/YkSNg7B_rps/видео.html might help.
Thank you soo much Shane for this incredible video!❤🔥 This helped me solve my work of converting customer form to pdf document.
Shane now I want to save the pdf by the customer name. For example CustomerName.pdf. How do you dynamically grab the customer name from the customer text field in powerapps and populate it in the place of hello.pdf.
Can you please make a video on it? It will be highly appreciated! or guide me to the right Microsoft documentation🙂
Thanks again!!
Your videos are super helpful as always!!🙂
Hi Shane, great video as usual. In my HTML text I'm attempting to pull data from multiple galleries which are linked to multiple SharePoint lists. In SharePoint I have a primary list using its ID as a primary key and foreign key to my other lists. In my HTML text when I filter to get multiple items where my primary key is foreign then I get Invalid number of arguments: received 1, expecting 2 or more.... here is my filter: Filter(Transport.travel_request_id = selectedID), where Transport is my list and travel_request_id is my foreign key and selectedID is a variable set to my primary key. Please help, thank you.
You need a comma after Transport in your filter formula
@@ShanesCows the comma didn't work as well, so I ended filtering into a collection then reading from there. Thank for coming back to me much appreciated.
can you explain about how to create pdf without using one drive or any third-party participation in power automate
Hi Shane great video again. I am using choices in my form. How do I get that value to appear?
Resolved it, just used data card value instead of gallery selected. 👍
Glad you got it Allan
how many pdf can i save in a Sharepoint list?
A lot. 😎
i need to save the pdf from all the company in the next 3 years it can be possible?
Can i save the files in a sql list? 👉👈
You can but I don’t recommend it. Saving files to SharePoint doc library tends to work best.
Thank you so much Shane! you're so great!
Hello Shane, I would like to known if is possible that 1 combobox search in two shareponit lists.
Look in Create File 2, Content File and be sure you introduce Content File from the previous step.