Just started a new job fresh out of collage, these videos are helping a lot to get me up to speed on powerapps quickly. There isn't a ton of super specific content on Powerapps and automate, so these videos are highly appreciated
Hello Reza, the truth is, thank you very much for your excellent videos, receive a warm greeting from Peru, you help me a lot in my projects that I have been implementing. Thank you so much for everything!
Very nicely explained Reza - and practical! Personally, I would generate all the HTML in the PowerApp, and just pass the HTML as a variable to convert to Flow to convert to PDF.
If HTML is generated in Power App and any change is needed, one would have to change the App + publish the App. Ideally, I would read the HTML from a configuration list.
@@RezaDorrani yeah that’s a great point. So you would only have to deploy the flow when changes are needed. Having said that, I’ve been creating Flows within the powerapps editor, but they don’t appear in Power Automate - do you know why?
This is so clever and simple. I hadn’t thought of using HRML and OneDrive. I was only thinking about word templates and converting those to pdf. Great video, Reza!
Very detailed explanation and thank you so much. Happy to say am doing in the similar way in my project ☺️ and now can do even better as you said. Thanks again...
thank you to dhare your knowledge, Im wondering how did you do on Select action in the field map, to organize only the specific fieds 'Id' from the json
Hi, sorry I commented on the wrong video earlier. Here at 23:07 you have a condition to make sure PDF format doesn't get attached in the PDF you create. What code did you use there if I may ask to exclude PDF? I'm also adding the newly created PDF as attachment to the item in my SharePoint List, any idea how I can overwrite the PDF if it already exists (after amending an item and I generate a new PDF for example)?
23:07 is showing the flow to create html. Im not sure what you mean by PDF format doesn't get attached in the PDF you create. List item attachments override if name is same. Video description has links to download sample flows. Alternatively, you can also look at posting your issue with screenshots on the forums at powerusers.microsoft.com/
what is the code you use for your onSelect button in 20:35 ( export Power App data to PDF including Images). I have managed to get the flowing working, but i have no way to create the button.
Code is to call the flow from Power Apps and pass parameters. Example: ruclips.net/video/emAhLzVG9bM/видео.html & ruclips.net/video/1_F9msqF-f8/видео.html
At 23:08 in the video you skip to explain the condition. I can not enter "body('Get_attachment_content')?['body']?['$Content_type']" from dynamic content as you are showing in the video. How can I enter it as a condition as you are showing?
Hi Reza, i got one question. My data is too width, at the moment to generate the PDF, it cuts the last part because the orientation is vertical, how do i can change that to adjust my content on it? thanks
Hi Reza, Your videos are really amazing. I am loving watching these. I am new to Power Platform and having total 10 years into SharePoint technologies. Though I have learnt Power Apps and Power Automate from various different sources, I haven't done any real time project end to end. Just wanted to check if you have any Demo video project end to end, which I can practice and gain some more confidence and which will be helpful for my Power Platform job hunting. Thanks :)
Hello Reza. Thank you! I just have a question: Is there any chance that the Convert File (to PDF) have go to error if the file exceed an size limit? For me, looks like 20MB it's the size limit, but I need to include a bunch of images in PDF, that will exceeds this limit . Do you know if there's any other solution?
At 18:10 in the video I don't understand how you got the ID and Title into the value fields. Can you please share how? I'm new to this so sorry if its a stupid question
HI Reza, as i was replicating this flow you use to export the filtered data to pdf, i dont seem to get the individual data endpoints from the json that was passed from the powerapp, below is the logic used in the app on the button onselect, 'PowerAppV2->Compose,Createfile,Convertfile,Sendanemail(V2)'.Run(User().Email, JSON( Sort( Filter('Land Owner Entry List', Dropdown3.Selected.Value=Blank() Or Active=Dropdown3.Selected.Value, Dropdown4.Selected.Value=Blank() Or Deh=Dropdown4.Selected.Value, Dropdown5.Selected.Value=Blank() Or District=Dropdown5.Selected.Value ),Title,Ascending),JSONFormat.IgnoreUnsupportedTypes & IncludeBinaryData)) i can see the json come through in the DataInput compose action. Am i missing something? i used the expression on select action json(outputs('Data')) by adding the dynamic content of Data compose action outputs in the json function.
Formulas in the chat are hard to interpret without the intellisence and other aspects. I will have to look at your app & flow in action to provide guidance. I would recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com
@@RezaDorrani My bad, I think I watched 2 videos of yours at the same time. But the colors in the PDF is not the same as in the mail. How can you control the colors in a pdf? Thank u!
@@jollyonlan I believe the HTML action does have some limitations. Colors via css classes is one limit. I had seen some posts on this on the forums. I will recommend you check the forums at powerusers.microsoft.com/
Is there any characters or page limit when populate Word? When I ran my app which populates a Word document, after the document launched, clicked open the file. During opening the file, the character counter showed 110384 characters in the Word file. But, when finished opening the file, the character counter showed 18498 characters in 68 pages and only about 100 records populated in the Word file. There should have 792 records. Wonder why the rest of the records were not shown in the Word document?? Greatly appreciate your advice!! Thanks.
There are size limits with the connector. This is a standard feature and hence the limitations. The connector documentation must have the limits defined. You may want to look at 3rd party connectors. powerusers.microsoft.com/t5/Building-Flows/Convert-to-PDF-Failing-File-too-large/td-p/384254
Good morning, I made a stream that directs to my email. But what I wanted was to have a Button in PowerApps for the user to enter their email and send the PDF to their email. How can I do? Thanks for your help.
I do not have a video reference on this scenario (its in my backlog). I will recommend checking on the forums at powerusers.microsoft.com/ in case someone has done something similar.
Hello Reza, thank you for one more great tutorial. I have an use case where by I want to generate a PDF that has signature block which user signs using a smart card (PIV or CAC) and hits submit which saves the file as part of the app and sends the email to the next person in the workflow to review/approve/sign it with a smart card. How can this be achieved?
I do not have a video reference on this scenario and would have to try it out to provide guidance. I will recommend checking on the forums at powerusers.microsoft.com/ in case someone has done something similar.
Awesome tutorial. Have a quick question, how would you export each list entry, individually? As soon as a new entry is created, a button on PowerApps should be able to export to pdf only, the last created entry. Is this possible?
Possible. When an item is created, onsuccess call the flow and send the ID. I do not have a video reference on this specific scenario though. I would recommend giving it a shot and in case of issues, posting your issue with screenshots on the forums at powerusers.microsoft.com
Hi Reza, how would the Get items function work where the choice column in Sharepoint allows multiple selections? I found that I think a "Apply to each" would need to happen?
If i have a report with 10 section that needs to be populated from a sharepoint list with ~200 columns including image columns. I have it running for a single image/text combo, but am wondering if PA would run into performance issues or if I could even create that many actions? Batching by section and merging might be an option?
That seems to be a lot of columns. Not sure if you would hit any size limits. Check documentation to see about limits. This video uses OneDrive connector which definitely has a small size limit and your scenario would not fit. You would need to look into 3rd party premium connectors.
Hello Reza, Thank you for the Innovative Ideas, I'm searching for a flow which converts the attachments in sharepoint list from word attachments to pdf attachments and could update the same list in attachments. Is it possible, else give me some idea abt it. Thanks
I do not have a video reference on this scenario and would have to try it out to provide guidance. I recommend checking on the forums at powerusers.microsoft.com/ in case someone has done something similar.
This video is great. I am having an issue though where I use a Lookup column in my list but the flow does not return the selected item but instead the GUID. Is there a workaround?
I will have to look at your App/flow in action to provide guidance. I would recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com
hai Reza, thank you for your video, but I have a problem about the pictures size in pdf. I make a flow from sharepoint list attachment, can you give the cooding for the format size of HTML coding ? thank you
Video description has link to download sample flows. You can check the code in it. Alternatively, I would recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com
Great video and thank you for all of your videos they have been a great help. I have something similar and I got the flow to work but what is the trigger that goes in powerapps for the flow. I want to be able to export the form to pdf upon submit for example. Thank you.
@@RezaDorranithank you for your reply. I think I said it wrong. I am trying to figure out where to get the ID required in flow to put in powerapps. I am new to all this and learned a lot from your videos.
@@dimosgrigoropoulos274 Video description has link to download the flows. Its been a long while since I did this video hence do not remember the specifics.
Great video Reza! Question: at 22:00 you mentioned you're passing the ID, but every time I try to do this I get the options "Compose_Inputs" or "Body" What am I doing wrong here? I feel like I'm missing steps here.
When clicking on "Ask in Power Apps" to get the parameter from power apps, the name of the action will determine the name of the parameter. In my case I renamed the compose action to ItemId and then did ask in power apps.
Thanks for the video! Quick question - the Power Automate flow is not showing up in my Power Apps. I can see previous flows I have made but not this one. The flow is tested and running with no issues. Any idea how I can connect this to Power Apps please?
Hi @RezaDorrani I want to export to PDF all of my gallery items to a PDF along with their Attachment pictures if they are attached.. is there video? I am kinda stuck
I'm trying to send exported pdf of list item along with it's attachment in single approval email. So far I'm able to make them work individually, but can't figure out how to append attachments from multiple get items (Exported pdf and List attachments) into the Append to array variable. any tips would be appreciated. thanks.
I do not have a video reference on this scenario and would have to try it out to provide guidance. I would recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com
Hi Rezza, I am creating a reporting tool that I write Notes on Power Apps and Convert into PDF and send it to SharePoint and an Email. Also, I never got the other tools to format PDF.
I will have to look at your App in action to provide guidance. I would recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com
One more time, it remains super brilliant work even after 2 years. Thank you for the video. One question about one scenario, I submit a form, whose data is fed into a template in Power Apps and then converted to PDF for preview and submit. How can I save this submitted pdf file as an attachment of an item created in SP list (together with other details of the form), not a pdf file created in SP library? Thank you!
became an power addict.. will be power expert learning from your videos soon.. Great stuff my friend.. Also is there an link to inspection app? working on similar use case.
Thank You. No link yet. I have one more thing to add to the App which will I will showcase in my video next week and then plan to share the entire App.
@@vinayayinapurapu That is not my home. I was just walking around a neighborhood and saw a new construction and took some pics as I thought it would fit well for my use case 😊
This is good. If we have Multiple screens to print and each screen contains images and some text fields is power automate is suggested or better going with html code. If so how that would be getting images dynamically for print purpose?
Videos shows how to export data. Not printing. Print function supports single page only. Dynamic images - assuming you mean - images being passed to flow is shown in video
Hey Reza, thanks for this awesome video! You're channel is helping me so much its crazy! I just have one question: I am trying to create a pdf from filtered table just like you have done. In your video at 18:10 is where I get completely lost. When using the select function how do I specify the data points I want to print "Enter value" column? It looks like you are using power apps variables, but this flow has not been activated yet so we dont have those variables yet? I also don't think I should be adding new variables because then the flow is looking for additional values in powerapps and in this use case we only give the flow the user email as well as the Json data. So how do I specify in the Select function which "columns" I want printed to pdf? When I click on "enter value" I don't see the column names to choose from. I only see my created variables (Email & data) as well as outputs from the data and email compose variable functions. But nowhere do I see the JSON data's columns to choose from I hope my question makes sense. I would really appreciate your feedback as I am extremely stuck at this point.
Those are not variables. Those are data points from the JSON object passed from apps to flow. To get those data points, you would need to use expressions. Video description has a link to download the sample flow. For the Select action if you go to peek code, you can look at the expressions.
@@RezaDorrani Hey Razi, I have gone to your github to download the flows. But in both of the flows you uploaded you don't use the select action in either of them so I am struggling to know how to write the expressions to specify the data points I want using the select action.
Hi Reza, thanks for the insightful video. A quick clarification: Is there a way to bypass the create file in onedrive and create a file directly in SharePoint since my list may have large data? I was able to create a html file and save it in a Document library.
Hey Rezza, I'm trying to generate PDF for SOPs from SharePoint list item which has a few columns that can contain image and text thus they r in Rich text format, but not able to render these columns into PDF, Please help.
I do not have a video on this use case. I will have to look at your App in action to provide any guidance. I would recommend you post your issue/query with screenshots on the forums at powerusers.microsoft.com
Hello Reza, can you please advise or show direction how to extract all sharepoint list items with images (receipts) your help would be much appreciated.
I do not have a reference on this scenario and something that would be a challenge for flow with high volume of data. I recommend checking on forums in case someone has done something similar powerusers.microsoft.com
Hi Reza, Is there is any way to reduce the image size (clicked via add media control with flash) in powerautomate (other than encodian like tool) My html is getting created, but for PDF getting error like "An exception occurred while executing within the sandbox Status 412"
I have not come across the error you have stated. Also, we do not have additional capabilities like encodian with the technique I have showcased. I will recommend checking on the forums at powerusers.microsoft.com/ in case someone has done something similar.
Thank you for your great video and effort , I am not sure how to get the html for my power apps form (in my case purchase order) that I need to convert to pdf
Hey Reza, thanks for this wonderful wonderful video. Any way to attaching this pdf fle automaticaly to sharepoint list attachement ,while pressing the Export button?
You can use flow to add these as file attachments to list item. I have done some videos on my channel where I have done something similar. You will need to look through those.
Final scenario, could you teach me how to input the correct formula to trigger the PDF document icon and run flow from Power automate, I tried many ways but It was failed. In the on select function of PDF document, I input the name flow.run(...but after the racket what would be right here,, thanks for your kindness
I have not experienced the mentioned issue and hence not sure what the cause for it could be. I will recommend posting your issue on forums in case someone has experienced something similar powerusers.microsoft.com
Your video Really Help me understood alot about PowerApps and the flow!! Do you have video shows passing combobox values from powerapps to flow? My PowerApps has several comboboxes and each one allows multi filter values. Don't know how to pass each combobox's values to the flow?? Make it more complicated, my app also has a input text box for users to enter text for filtering. Greatly appreciated!!
Is it possible to do with data that is set up as one to many? For my situation, the user selects 1 or more records to export. But there is child data under each record that would need to export as well.
Hi Reza, thanks for your video. I want to ask how Id and Title from powerapps show (18.04) in select ? I tried many times I didn't find the way. Thanks for your attention.
By using expressions. Video description has link to download the flows. I have even made the app available at github.com/rdorrani/PowerApps/blob/master/InspectionApp_20210518155834.zip
Hey the email function does't work if you are not the person who created the flow how can I fit that I already have a delegated email address and it is still failing
Works for all users as the flow gets called from user context running the app. As long as user has a mailbox, it will work. I have not come across this issue and hence not sure what is the cause for your issue. I recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com
This is very helpful - I just have issue as I am using a gallery.selected to pull a certain row in a table with attachments. I am not certain how to execute on the power app side to tell the flow what to pull, any guidance would be appreciated. Thanks for doing these videos!!
I would have to look at your App and scenario in action to provide any guidance. I would recommend to post your query with screenshots on the forums at powerusers.microsoft.com
@@laxmirohinim5442 I cannot guide here on chat. Forums is an open platform. Look for discussion boards. Do some searching on the site and you should get it.
Hi, can you share the html style code you used to style the table, I have created the html table and added it in the compose action, when i add the dynamic content into the html and runs it, the data keeps falling out of the table. All content is not visible
Check ruclips.net/video/VnWg-Eox37Q/видео.html for HTML Table styling. I will have to look at your flow in action to provide any guidance related to your issue. I would recommend you post your issue/query with screenshots on the forums at powerusers.microsoft.com I have also made the sample App (which includes the connected flows) available for download at github.com/rdorrani/PowerApps/blob/master/InspectionApp_20210518155834.zip
This was so helpful! I have one issue with multiple lines of text columns. When exporting it to pdf, it doesn't wrap the text which leads to over flowing text. Is there anyway to wrap the text? Thank you!
I believe that is a limitation. The technique showcases in the video uses standard connectors. There are premium connectors that offer a lot more flexibility. I will recommend checking on the forums at powerusers.microsoft.com/ in case someone has done something similar.
@@RezaDorrani Thank you so much Reza! I was able to convert it into rich text and it resolved the over flowing text when it was converted to PDF. Your videos have helped me so much these last couple of months, thank you for everything you do!!!
I will have to look at your flow in action to provide guidance. I would recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com
@@RezaDorrani Reza, my json passes the values of all the fields from powerApps to the flow. However, my generated html content is not a table like in your video. But, still passing array of text values with several fields. How can I reference each field in the html content. My output file is like a array of text paragraphs. Also, do I still need to use the create html table data operation? My data still is an array. I don't know how to share the info with you? I don't know how to attach screenshots in this comment. Hope you can help! Greatly appreciated! Thanks.
Hello, I’m having issues with the create file in one drive. It creates it in my personal one drive even when someone else triggers the flow. Can I make it so that whoever triggers the flow gets the file in their personal one drive instead ?
The default behavior is that in creates in users onedrive. I have not come across the mentioned issue and hence not sure what the reason for your issue is. I recommend posting your issue with screenshots on the forums at powerusers.microsoft.com
@@RezaDorrani thank you for your reply. Could it have something to do with the fact I’m using ‘when an item is created or edited’ in share point as a trigger? Maybe this trigger doesn’t provide the flow with who actually triggered that change and therefore it defaults to my one drive because I made the flow ?
I actually, want to have a PDF of gallery items, 1 by 1 and with their attachment photos as you have only exported single record. I want to export multiple records like that.. how to edit the flow according to that please help?
Thanks a lot Reza, always clear and amazing. But if I've the storage of inspection photo on SQL table stored on a varbinary colum, do you think I can use your solution? Html need a src URL link of the pictures 🤔
My solution would not work with SQL. I do not have a video reference on SQL scenario. I will recommend checking on the forums at powerusers.microsoft.com/ in case someone has done something similar.
Hi Reza Dorrani! Since we are using our own one drive as part of the flow to generate the pdf, how we can allow the other user to use Powerapps PDF? I have try other to use that but it did not works to generate the pdf due to one drive.
@@541576 It should work but I believe the conversion action is in OneDrive connector only. I will recommend you check on the forums at powerusers.microsoft.com
@@RezaDorrani Sir, if you dont mind, can i talk via Teams on this which i can share what i have done so far. Can you drop ur email address here to invite in the teams.
Again superb and informative video. I just have a question. Is it possible to insert the attachment/images in a html table. Column 1 could be the description and column 2 is the pictures.
Possible by adjusting the html logic. I would have to try it out to give exact steps. Give it a try and in case of issues, post your issue/query with screenshots on the forums at powerusers.microsoft.com
I would give it a try and make this vid my guide. But it would be great to also see this type of solution from your channel. A lot will definitely benefit.
@@charlesdawnbeltran9603 I make videos when I get a lot of folks requesting a topic. I have received a few requests on this one. Every quarter I ask subscribers for topic suggestions on my Community Tab. Make sure to post this as an idea there. If it gets a lot of votes, I will consider it.
Reza , Thanks for this video. Is there any way to generate pdf with multiple records with multiple images? This video shows pdf generation for images in a single record.
I do not have a video reference for multiple record scenarios. I will recommend checking on the forums at powerusers.microsoft.com/ in case someone has done something similar.
When you create the first parameter, which is Compose the "UserEmail", you inform "UserEmail_Outputs". But when I try to link the flow in Power Apps, it doesn't identify. I'm not understanding how you created the variable in "UserEmail".
Hi Sir in the third step were you are using select and mapping it with ID and Title I am not getting any value there can you please help let me know what wrong a I am doing
@Abdil Game It should be the same. I will have to look at your app/flow in action to provide guidance. I will recommend you post your issue with screenshots on the forums at powerusers.microsoft.com/
How can I put page numbers in generated pdf file. We have a requirement where we are generating pdf of 2-3 pages of contents and we need to show page numbers like 1 of 3, 2 of 3, 3 of 3 like that. The content is dynamic and I don't know how many pages it will generate.
As far as I know, page breaks are not possible with this technique and hence no page numbers. You will need to look at using premium pdf based connectors for that.
Hi Reza, after creating the select action, there are no dynamic fields in the values (looks like PA does not gets the fields from the collection). Do you know how to fix it?
Dear Mr Dorrani, Thank you so much for your teaching. May i know if there is any way to generate powerpoint by template with power automate (without premium please, and using powerapps and sharepoint list/documents)?
Thanks for watching the videos and liking the teaching style. I am not sure about ppt with flow. Look if there are any APIs for it or check on forums if anyone has done something similar powerusers.microsoft.com
Hello Reza, as usual video is super helpful! Thank you a lot! One question. Content that i save to pdf doesn't fit well in the file. Landscape format might be better solution but when pdf is generated I don't know how to define landscape format to the file or maybe inside HTML format i can condition portrait format.
As usual, distinguished in choosing topics, really a smart way, thanks for sharing
Thank you
Just started a new job fresh out of collage, these videos are helping a lot to get me up to speed on powerapps quickly. There isn't a ton of super specific content on Powerapps and automate, so these videos are highly appreciated
Most welcome and thanks so much!
It doesn't matter what type of powerapps functionality I do a Google search for, Reza has video describing how to do it. Absolutely amazing!!
That's the goal 😊
Thank You for watching.
Reza is the best. Really knows how to break it down and not leave any steps out.
Thanks Kevin
Thank you Reza! You are light in office 365 world! And don’t be humble because you deserve it!!!!!
Thank You so much 🙏
It is the love of my subscribers that drives me to do better work.
Everytime a problem arises, there's a Reza tutorial, you've helped me a lot, thank you so much Reza
Most welcome Joana
Reza, I'm from Brazil and I want to congratulate you, your videos help me a lot. ;)
Happy to hear that! Love to Brazil.
Simply awesome - you are simply the iron man of powerapp
💪 Thank You!
Hello Reza, the truth is, thank you very much for your excellent videos, receive a warm greeting from Peru, you help me a lot in my projects that I have been implementing. Thank you so much for everything!
You are most welcome. Thank you for watching.
Thank you Reza for your generosity. I learn a lot from watching your videos 🙂
My pleasure 😊
Very nicely explained Reza - and practical! Personally, I would generate all the HTML in the PowerApp, and just pass the HTML as a variable to convert to Flow to convert to PDF.
If HTML is generated in Power App and any change is needed, one would have to change the App + publish the App.
Ideally, I would read the HTML from a configuration list.
@@RezaDorrani yeah that’s a great point. So you would only have to deploy the flow when changes are needed. Having said that, I’ve been creating Flows within the powerapps editor, but they don’t appear in Power Automate - do you know why?
@@LandscapeInMotion they do. In same env where App is created
Hi Reza, at 18:09 I can't Map automatically/dynamically the ID and Title. Am I missing a step?
Expression is the key.
Use item()?['column internal name']
example: item()?['ID']
@@RezaDorrani Perfect. Thank you for your time.
Reza awesome stuff Brother keep rocking thanks for being so great to all of us appreciate it
Your most welcome Alfonso.
I love your channel, its very detailed organised and fits viewers requirements..other ms developers please learn from reza.
Thank you so much 🙂
This is so clever and simple. I hadn’t thought of using HRML and OneDrive. I was only thinking about word templates and converting those to pdf.
Great video, Reza!
Thank you Chad
Thanks for this video Export to PDF. I'm waiting for long time. That's awesome.
Thank you Shibu
Very detailed explanation and thank you so much. Happy to say am doing in the similar way in my project ☺️ and now can do even better as you said. Thanks again...
Glad it was helpful!
You are my hero! Keep up the good work! ❤
Thank You!
I have been waiting for this for a very long time ... thank you, Reza.
Hope you enjoyed it!
Thank you so much for the shared content !! Another excellent video, congratulations !!
Thanks for watching!
Great "flow" in your tutorial here. Great delivery and content. Thank you for sharing.
Thanks Brad
Great explanatory skills, Reza. I am an MCT & have never cracked such ease of successful knowledge transfer. Good work!
Thank you for your kind words!
thank you to dhare your knowledge, Im wondering how did you do on Select action in the field map, to organize only the specific fieds 'Id' from the json
Video description has link to download the flow
Hi, sorry I commented on the wrong video earlier. Here at 23:07 you have a condition to make sure PDF format doesn't get attached in the PDF you create. What code did you use there if I may ask to exclude PDF?
I'm also adding the newly created PDF as attachment to the item in my SharePoint List, any idea how I can overwrite the PDF if it already exists (after amending an item and I generate a new PDF for example)?
23:07 is showing the flow to create html. Im not sure what you mean by PDF format doesn't get attached in the PDF you create.
List item attachments override if name is same.
Video description has links to download sample flows.
Alternatively, you can also look at posting your issue with screenshots on the forums at powerusers.microsoft.com/
Thanks so much for all contents u share on powerapps !
Thank You
Thanks for sharing this Reza! Really useful.
Thanks Suji
what is the code you use for your onSelect button in 20:35 ( export Power App data to PDF including Images). I have managed to get the flowing working, but i have no way to create the button.
Code is to call the flow from Power Apps and pass parameters.
Example: ruclips.net/video/emAhLzVG9bM/видео.html & ruclips.net/video/1_F9msqF-f8/видео.html
Excelent video thanks I learn very much with your tutorials
Glad you like them!
Great video, Reza!
Thanks Allan
Very good video. I always appreciate your videos.
Thank you Eric
Reza this is AMAZING VIDEO :) Now I can extract all receipts from All Items Attachments and make one file :) What would I do without you? :)
What would I do without all of my subscribers? :)
At 23:08 in the video you skip to explain the condition. I can not enter "body('Get_attachment_content')?['body']?['$Content_type']" from dynamic content as you are showing in the video. How can I enter it as a condition as you are showing?
Video description has link to download the flows. You can check all the code in it.
Hi Reza, i got one question.
My data is too width, at the moment to generate the PDF, it cuts the last part because the orientation is vertical, how do i can change that to adjust my content on it?
thanks
You cannot change the width and other aspects. For that you would need to use premium 3rd party PDF Connectors.
@@RezaDorrani got it, thanks Reza
Hi Reza,
Your videos are really amazing. I am loving watching these. I am new to Power Platform and having total 10 years into SharePoint technologies. Though I have learnt Power Apps and Power Automate from various different sources, I haven't done any real time project end to end. Just wanted to check if you have any Demo video project end to end, which I can practice and gain some more confidence and which will be helpful for my Power Platform job hunting. Thanks :)
Most of my videos are step by step tutorials.
Check playlists on my channel, I did live training sessions which may help.
Hello Reza. Thank you! I just have a question: Is there any chance that the Convert File (to PDF) have go to error if the file exceed an size limit? For me, looks like 20MB it's the size limit, but I need to include a bunch of images in PDF, that will exceeds this limit . Do you know if there's any other solution?
Check documentation on size limit. There may be 3rd party premium connectors that offer bigger file sizes.
At 18:10 in the video I don't understand how you got the ID and Title into the value fields. Can you please share how? I'm new to this so sorry if its a stupid question
By using expressions item()?['ID'] & item()?['Title']
@@RezaDorrani thank you! will try
HI Reza, as i was replicating this flow you use to export the filtered data to pdf, i dont seem to get the individual data endpoints from the json that was passed from the powerapp, below is the logic used in the app on the button onselect,
'PowerAppV2->Compose,Createfile,Convertfile,Sendanemail(V2)'.Run(User().Email,
JSON(
Sort(
Filter('Land Owner Entry List',
Dropdown3.Selected.Value=Blank() Or Active=Dropdown3.Selected.Value,
Dropdown4.Selected.Value=Blank() Or Deh=Dropdown4.Selected.Value,
Dropdown5.Selected.Value=Blank() Or District=Dropdown5.Selected.Value
),Title,Ascending),JSONFormat.IgnoreUnsupportedTypes & IncludeBinaryData))
i can see the json come through in the DataInput compose action. Am i missing something? i used the expression on select action json(outputs('Data')) by adding the dynamic content of Data compose action outputs in the json function.
Formulas in the chat are hard to interpret without the intellisence and other aspects.
I will have to look at your app & flow in action to provide guidance. I would recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com
@@RezaDorrani posted. its titled : Trying To Pass Filtered Records as JSON to Power Automate to Export to PDF
@@MustafaFarooq I only go to forums in my free time. You would need to wait for someone to respond.
Honestly, I was wondering how to achieve this, thank you
Glad to know this helped
Great! at 15:30 the colors does not display in the pdf file, how come?
Which colors?
@@RezaDorrani My bad, I think I watched 2 videos of yours at the same time. But the colors in the PDF is not the same as in the mail. How can you control the colors in a pdf? Thank u!
@@jollyonlan I believe the HTML action does have some limitations. Colors via css classes is one limit.
I had seen some posts on this on the forums.
I will recommend you check the forums at powerusers.microsoft.com/
Is there any characters or page limit when populate Word? When I ran my app which populates a Word document, after the document launched, clicked open the file. During opening the file, the character counter showed 110384 characters in the Word file. But, when finished opening the file, the character counter showed 18498 characters in 68 pages and only about 100 records populated in the Word file. There should have 792 records. Wonder why the rest of the records were not shown in the Word document?? Greatly appreciate your advice!! Thanks.
There are size limits with the connector. This is a standard feature and hence the limitations. The connector documentation must have the limits defined.
You may want to look at 3rd party connectors.
powerusers.microsoft.com/t5/Building-Flows/Convert-to-PDF-Failing-File-too-large/td-p/384254
You are the MAN. Thank you again
Most welcome
So that's how to solve the img problem 🙌🙌 thank you :-)
Your most welcome
Thanks a lot, just amazing, looking forward to try it on the weekend
Have fun!
Good morning,
I made a stream that directs to my email. But what I wanted was to have a Button in PowerApps for the user to enter their email and send the PDF to their email. How can I do?
Thanks for your help.
I do not have a video reference on this scenario (its in my backlog). I will recommend checking on the forums at powerusers.microsoft.com/ in case someone has done something similar.
Hello Reza, thank you for one more great tutorial. I have an use case where by I want to generate a PDF that has signature block which user signs using a smart card (PIV or CAC) and hits submit which saves the file as part of the app and sends the email to the next person in the workflow to review/approve/sign it with a smart card. How can this be achieved?
I do not have a video reference on this scenario and would have to try it out to provide guidance. I will recommend checking on the forums at powerusers.microsoft.com/ in case someone has done something similar.
Thank you for the great information. We implemented this functionality last week.
Now I know why word-break css was not working.
Thanks for watching. I hope in a future update it supports the word-break css.
Awesome tutorial.
Have a quick question, how would you export each list entry, individually? As soon as a new entry is created, a button on PowerApps should be able to export to pdf only, the last created entry.
Is this possible?
Possible. When an item is created, onsuccess call the flow and send the ID.
I do not have a video reference on this specific scenario though. I would recommend giving it a shot and in case of issues, posting your issue with screenshots on the forums at powerusers.microsoft.com
Hi Reza, how would the Get items function work where the choice column in Sharepoint allows multiple selections? I found that I think a "Apply to each" would need to happen?
It would add that apply to each loop. You can use the join expression to convert all the multiple selections into a string and use in document.
@@RezaDorrani thanks mate that worked. Also sorry to hear about what happened.
@@brendanv666 🙏
If i have a report with 10 section that needs to be populated from a sharepoint list with ~200 columns including image columns. I have it running for a single image/text combo, but am wondering if PA would run into performance issues or if I could even create that many actions? Batching by section and merging might be an option?
That seems to be a lot of columns. Not sure if you would hit any size limits. Check documentation to see about limits.
This video uses OneDrive connector which definitely has a small size limit and your scenario would not fit. You would need to look into 3rd party premium connectors.
Hello Reza, Thank you for the Innovative Ideas, I'm searching for a flow which converts the attachments in sharepoint list from word attachments to pdf attachments and could update the same list in attachments. Is it possible, else give me some idea abt it. Thanks
I do not have a video reference on this scenario and would have to try it out to provide guidance. I recommend checking on the forums at powerusers.microsoft.com/ in case someone has done something similar.
This video is great.
I am having an issue though where I use a Lookup column in my list but the flow does not return the selected item but instead the GUID. Is there a workaround?
I will have to look at your App/flow in action to provide guidance. I would recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com
hai Reza, thank you for your video, but I have a problem about the pictures size in pdf. I make a flow from sharepoint list attachment, can you give the cooding for the format size of HTML coding ?
thank you
Video description has link to download sample flows. You can check the code in it.
Alternatively, I would recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com
So useful, great video
Thank you 👍
Great video and thank you for all of your videos they have been a great help. I have something similar and I got the flow to work but what is the trigger that goes in powerapps for the flow. I want to be able to export the form to pdf upon submit for example. Thank you.
Trigger is as shown in video
@@RezaDorranithank you for your reply. I think I said it wrong. I am trying to figure out where to get the ID required in flow to put in powerapps. I am new to all this and learned a lot from your videos.
@@dimosgrigoropoulos274 Video description has link to download the flows. Its been a long while since I did this video hence do not remember the specifics.
Can you also edit the size format of the pdf file? I have a power bi paginated report that doesn't fit horizontally in a normal pdf size.
Its limited in formatting options. Check documentation on pdf function.
Can you do a video on how to generate pdf for dynamic data in PowerApps without using flow (for offline mode)
I do not think that is possible.
Great video Reza!
Question: at 22:00 you mentioned you're passing the ID, but every time I try to do this I get the options "Compose_Inputs" or "Body"
What am I doing wrong here? I feel like I'm missing steps here.
When clicking on "Ask in Power Apps" to get the parameter from power apps, the name of the action will determine the name of the parameter. In my case I renamed the compose action to ItemId and then did ask in power apps.
Thanks for the video! Quick question - the Power Automate flow is not showing up in my Power Apps. I can see previous flows I have made but not this one. The flow is tested and running with no issues. Any idea how I can connect this to Power Apps please?
Check to see if you have built the flow in the same environment as the App.
so simple - so good!
Thank You :)
Hi @RezaDorrani I want to export to PDF all of my gallery items to a PDF along with their Attachment pictures if they are attached..
is there video? I am kinda stuck
I would have to try it out to provide guidance. I would recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com
I'm trying to send exported pdf of list item along with it's attachment in single approval email. So far I'm able to make them work individually, but can't figure out how to append attachments from multiple get items (Exported pdf and List attachments) into the Append to array variable. any tips would be appreciated. thanks.
I do not have a video reference on this scenario and would have to try it out to provide guidance. I would recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com
Hi Rezza, I am creating a reporting tool that I write Notes on Power Apps and Convert into PDF and send it to SharePoint and an Email. Also, I never got the other tools to format PDF.
I will have to look at your App in action to provide guidance. I would recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com
One more time, it remains super brilliant work even after 2 years. Thank you for the video. One question about one scenario, I submit a form, whose data is fed into a template in Power Apps and then converted to PDF for preview and submit. How can I save this submitted pdf file as an attachment of an item created in SP list (together with other details of the form), not a pdf file created in SP library? Thank you!
Thanks!
How and where are you saving the pdf?
You could use flow to attach as list item. This is not something I have tried though.
became an power addict.. will be power expert learning from your videos soon.. Great stuff my friend.. Also is there an link to inspection app? working on similar use case.
Thank You.
No link yet. I have one more thing to add to the App which will I will showcase in my video next week and then plan to share the entire App.
@@RezaDorrani hey can’t wait to watch it. Btw congratulations on new home 🏡😎
@@vinayayinapurapu That is not my home. I was just walking around a neighborhood and saw a new construction and took some pics as I thought it would fit well for my use case 😊
This is good. If we have Multiple screens to print and each screen contains images and some text fields is power automate is suggested or better going with html code. If so how that would be getting images dynamically for print purpose?
Videos shows how to export data. Not printing. Print function supports single page only. Dynamic images - assuming you mean - images being passed to flow is shown in video
Hey Reza, thanks for this awesome video! You're channel is helping me so much its crazy!
I just have one question:
I am trying to create a pdf from filtered table just like you have done. In your video at 18:10 is where I get completely lost.
When using the select function how do I specify the data points I want to print "Enter value" column?
It looks like you are using power apps variables, but this flow has not been activated yet so we dont have those variables yet? I also don't think I should be adding new variables because then the flow is looking for additional values in powerapps and in this use case we only give the flow the user email as well as the Json data.
So how do I specify in the Select function which "columns" I want printed to pdf? When I click on "enter value" I don't see the column names to choose from. I only see my created variables (Email & data) as well as outputs from the data and email compose variable functions. But nowhere do I see the JSON data's columns to choose from
I hope my question makes sense. I would really appreciate your feedback as I am extremely stuck at this point.
Those are not variables. Those are data points from the JSON object passed from apps to flow. To get those data points, you would need to use expressions.
Video description has a link to download the sample flow.
For the Select action if you go to peek code, you can look at the expressions.
Reza thank you so much! Now I get it.
You are the best!
@@johanhaasbroek979 Thanks
@@RezaDorrani Hey Razi, I have gone to your github to download the flows.
But in both of the flows you uploaded you don't use the select action in either of them so I am struggling to know how to write the expressions to specify the data points I want using the select action.
@@johanhaasbroek9952 Use expression item()?[‘PropertyName’]
Hi Reza, thanks for the insightful video. A quick clarification: Is there a way to bypass the create file in onedrive and create a file directly in SharePoint since my list may have large data? I was able to create a html file and save it in a Document library.
The convert to pdf is a OneDrive only action.
Hey Rezza, I'm trying to generate PDF for SOPs from SharePoint list item which has a few columns that can contain image and text thus they r in Rich text format, but not able to render these columns into PDF, Please help.
I do not have a video on this use case.
I will have to look at your App in action to provide any guidance. I would recommend you post your issue/query with screenshots on the forums at powerusers.microsoft.com
Hello Reza, can you please advise or show direction how to extract all sharepoint list items with images (receipts) your help would be much appreciated.
I do not have a reference on this scenario and something that would be a challenge for flow with high volume of data. I recommend checking on forums in case someone has done something similar powerusers.microsoft.com
Hi Reza,
Is there is any way to reduce the image size (clicked via add media control with flash) in powerautomate (other than encodian like tool)
My html is getting created, but for PDF getting error like
"An exception occurred while executing within the sandbox
Status 412"
I have not come across the error you have stated.
Also, we do not have additional capabilities like encodian with the technique I have showcased.
I will recommend checking on the forums at powerusers.microsoft.com/ in case someone has done something similar.
Thank you for your great video and effort , I am not sure how to get the html for my power apps form (in my case purchase order) that I need to convert to pdf
You would need to create an HTML. There is no direct way to get it.
Hey Reza, thanks for this wonderful wonderful video. Any way to attaching this pdf fle automaticaly to sharepoint list attachement ,while pressing the Export button?
You can use flow to add these as file attachments to list item. I have done some videos on my channel where I have done something similar. You will need to look through those.
Final scenario, could you teach me how to input the correct formula to trigger the PDF document icon and run flow from Power automate, I tried many ways but It was failed. In the on select function of PDF document, I input the name flow.run(...but after the racket what would be right here,, thanks for your kindness
I have not experienced the mentioned issue and hence not sure what the cause for it could be.
I will recommend posting your issue on forums in case someone has experienced something similar powerusers.microsoft.com
Your video Really Help me understood alot about PowerApps and the flow!! Do you have video shows passing combobox values from powerapps to flow? My PowerApps has several comboboxes and each one allows multi filter values. Don't know how to pass each combobox's values to the flow?? Make it more complicated, my app also has a input text box for users to enter text for filtering. Greatly appreciated!!
I do not have a video on passing combox box info.
I will recommend you check on the forums at powerusers.microsoft.com/
Is it possible to do with data that is set up as one to many? For my situation, the user selects 1 or more records to export. But there is child data under each record that would need to export as well.
Possible. You would have to query the child data and accordingly add it to the HTML. I do not have a video reference for this use case though.
@@RezaDorrani if you made a video on it, pretty sure you'd be the first one...just saying 😎
@@dankirchner4460 :)
Hi Reza, thanks for your video. I want to ask how Id and Title from powerapps show (18.04) in select ? I tried many times I didn't find the way. Thanks for your attention.
By using expressions. Video description has link to download the flows.
I have even made the app available at github.com/rdorrani/PowerApps/blob/master/InspectionApp_20210518155834.zip
Hi reza, About in the orientation of PDF. How can I transpose the portrait to landscape?
Orientation update is not an option with this technique. You would need to look into 3rd party premium connectors for those features.
Hi @@RezaDorrani it is possible to use CSS in compose?
@@jumilbolhano3910 You could but the technique shown in video only supports inline styles (not all styles are supported there as well)
Hey the email function does't work if you are not the person who created the flow how can I fit that I already have a delegated email address and it is still failing
Works for all users as the flow gets called from user context running the app. As long as user has a mailbox, it will work.
I have not come across this issue and hence not sure what is the cause for your issue. I recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com
Thank you for this wonderful idea!!!
There is two mail send to the receipt after trigger the flow.
How can I send only one mail ?
This only sends one mail
This is very helpful - I just have issue as I am using a gallery.selected to pull a certain row in a table with attachments. I am not certain how to execute on the power app side to tell the flow what to pull, any guidance would be appreciated. Thanks for doing these videos!!
I would have to look at your App and scenario in action to provide any guidance. I would recommend to post your query with screenshots on the forums at powerusers.microsoft.com
Thank's Reza , very interesting !
Thanks for watching
hi can u help me with..Create a Flow of your choice. It should have 2 actions including a condition for yes and no.
Best place to post issues/queries is the forums at powerusers.microsoft.com/
@@RezaDorrani where to post i am unable to see actually
@@laxmirohinim5442 I cannot guide here on chat. Forums is an open platform. Look for discussion boards. Do some searching on the site and you should get it.
any video is their of yours so that i can create a normal flow with yes or no condition
@@laxmirohinim5442 I may have done it in one of my 100 videos. You will need to check.
Hi, can you share the html style code you used to style the table,
I have created the html table and added it in the compose action, when i add the dynamic content into the html and runs it, the data keeps falling out of the table. All content is not visible
Check ruclips.net/video/VnWg-Eox37Q/видео.html for HTML Table styling.
I will have to look at your flow in action to provide any guidance related to your issue. I would recommend you post your issue/query with screenshots on the forums at powerusers.microsoft.com
I have also made the sample App (which includes the connected flows) available for download at github.com/rdorrani/PowerApps/blob/master/InspectionApp_20210518155834.zip
This was so helpful! I have one issue with multiple lines of text columns. When exporting it to pdf, it doesn't wrap the text which leads to over flowing text. Is there anyway to wrap the text? Thank you!
I believe that is a limitation. The technique showcases in the video uses standard connectors.
There are premium connectors that offer a lot more flexibility.
I will recommend checking on the forums at powerusers.microsoft.com/ in case someone has done something similar.
@@RezaDorrani Thank you so much Reza! I was able to convert it into rich text and it resolved the over flowing text when it was converted to PDF. Your videos have helped me so much these last couple of months, thank you for everything you do!!!
@@ee2373 Awesome!
I followed your Json flow steps, but can't select "Ask in PowerApps" (the items from my collection). Anything I did wrong? Please help!
I will have to look at your flow in action to provide guidance. I would recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com
@@RezaDorrani Reza, my json passes the values of all the fields from powerApps to the flow. However, my generated html content is not a table like in your video. But, still passing array of text values with several fields. How can I reference each field in the html content. My output file is like a array of text paragraphs. Also, do I still need to use the create html table data operation? My data still is an array. I don't know how to share the info with you? I don't know how to attach screenshots in this comment. Hope you can help! Greatly appreciated! Thanks.
@@maggieho9521 You can attach screenshots and all other details on the forums.
powerusers.microsoft.com
Hello, I’m having issues with the create file in one drive. It creates it in my personal one drive even when someone else triggers the flow. Can I make it so that whoever triggers the flow gets the file in their personal one drive instead ?
The default behavior is that in creates in users onedrive. I have not come across the mentioned issue and hence not sure what the reason for your issue is. I recommend posting your issue with screenshots on the forums at powerusers.microsoft.com
@@RezaDorrani thank you for your reply. Could it have something to do with the fact I’m using ‘when an item is created or edited’ in share point as a trigger? Maybe this trigger doesn’t provide the flow with who actually triggered that change and therefore it defaults to my one drive because I made the flow ?
@@forzeferrari2668 yes that is the reason.
Did you not hit the 2mb limit on converting the Html to PDF via One Drive Business connector?
Did not for this scenario since size was within 2MB.
I actually, want to have a PDF of gallery items, 1 by 1 and with their attachment photos as you have only exported single record.
I want to export multiple records like that.. how to edit the flow according to that please help?
I would have to try it out to provide guidance. I would recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com
Thanks a lot Reza, always clear and amazing.
But if I've the storage of inspection photo on SQL table stored on a varbinary colum, do you think I can use your solution? Html need a src URL link of the pictures 🤔
My solution would not work with SQL. I do not have a video reference on SQL scenario. I will recommend checking on the forums at powerusers.microsoft.com/ in case someone has done something similar.
Hi Reza Dorrani! Since we are using our own one drive as part of the flow to generate the pdf, how we can allow the other user to use Powerapps PDF? I have try other to use that but it did not works to generate the pdf due to one drive.
Since Power Apps is called from flow, the flow runs under context of user running the Power App. So the file will be generated in the users OneDrive.
@@RezaDorrani What if i use SharePoint library to create the file and convert the file? Does this will be works?
@@541576 It should work but I believe the conversion action is in OneDrive connector only.
I will recommend you check on the forums at powerusers.microsoft.com
@@RezaDorrani Sir, if you dont mind, can i talk via Teams on this which i can share what i have done so far. Can you drop ur email address here to invite in the teams.
@@541576 Please post your issue on the forums. I myself go to forums in my free time.
Again superb and informative video.
I just have a question. Is it possible to insert the attachment/images in a html table. Column 1 could be the description and column 2 is the pictures.
Possible by adjusting the html logic. I would have to try it out to give exact steps. Give it a try and in case of issues, post your issue/query with screenshots on the forums at powerusers.microsoft.com
I would give it a try and make this vid my guide. But it would be great to also see this type of solution from your channel. A lot will definitely benefit.
@@charlesdawnbeltran9603 I make videos when I get a lot of folks requesting a topic. I have received a few requests on this one.
Every quarter I ask subscribers for topic suggestions on my Community Tab.
Make sure to post this as an idea there. If it gets a lot of votes, I will consider it.
Reza , Thanks for this video.
Is there any way to generate pdf with multiple records with multiple images?
This video shows pdf generation for images in a single record.
I do not have a video reference for multiple record scenarios.
I will recommend checking on the forums at powerusers.microsoft.com/ in case someone has done something similar.
When you create the first parameter, which is Compose the "UserEmail", you inform "UserEmail_Outputs". But when I try to link the flow in Power Apps, it doesn't identify. I'm not understanding how you created the variable in "UserEmail".
Check this video ruclips.net/video/UZdngrwWsqA/видео.html where I go step by step
Hi Sir in the third step were you are using select and mapping it with ID and Title I am not getting any value there can you please help let me know what wrong a I am doing
You will need to write expressions.
Example: item()?[‘Title’]
@Abdil Game It should be the same. I will have to look at your app/flow in action to provide guidance. I will recommend you post your issue with screenshots on the forums at powerusers.microsoft.com/
You are a genius
Thanks :)
Hi Reza, can we convert pdf to html without using premium connectors and then add the signature at the end fetched from powerapps
Im not sure about that as I have not tried it
How can I put page numbers in generated pdf file. We have a requirement where we are generating pdf of 2-3 pages of contents and we need to show page numbers like 1 of 3, 2 of 3, 3 of 3 like that. The content is dynamic and I don't know how many pages it will generate.
As far as I know, page breaks are not possible with this technique and hence no page numbers. You will need to look at using premium pdf based connectors for that.
@@RezaDorrani Thanks mate for the quick response. Can you suggest some good and affordable third party connectors to achieve this requirement?
@@ravirachchh4062 I have not used any of them. I have seen posts about them on forums. Please check on forums at powerusers.microsoft.com
Hi Reza, after creating the select action, there are no dynamic fields in the values (looks like PA does not gets the fields from the collection). Do you know how to fix it?
You would need to use expressions.
Example: item()?['propertyname']
@@RezaDorrani Thank you Reza, I will try that!
Dear Mr Dorrani, Thank you so much for your teaching. May i know if there is any way to generate powerpoint by template with power automate (without premium please, and using powerapps and sharepoint list/documents)?
Thanks for watching the videos and liking the teaching style.
I am not sure about ppt with flow. Look if there are any APIs for it or check on forums if anyone has done something similar powerusers.microsoft.com
@@RezaDorrani ok thanks for your response
Hello Reza, as usual video is super helpful! Thank you a lot!
One question. Content that i save to pdf doesn't fit well in the file. Landscape format might be better solution but when pdf is generated I don't know how to define landscape format to the file or maybe inside HTML format i can condition portrait format.
The pdf generation technique shown in video does not provide those options. You would need to look into 3rd party premium connectors.