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
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?
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!
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...
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, 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 :)
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.
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?
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
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: ua-cam.com/video/emAhLzVG9bM/v-deo.html & ua-cam.com/video/1_F9msqF-f8/v-deo.html
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/
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?
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 😊
Reza ... great video that covers a lot of territory. One question on a key point that I'm missing. I am trying to imitate the sequence where you export filtered data to PDF using flow, except I am sending the values from an unfiltered collection. After I get to the Select/Data Operations at around 18:07 and enter 'json(outputs('Data')), I am unable to do any mapping. Specifically, when I select 'ask powerapps', it does not show or allow me to select any of the column headings. Is there another video you've prepared that has those details? I suspect I am missing something simple. :( Thank you! r/ Patrick
That's a great video, Reza, really helped me... I'm looking for how to export to pdf using filtering in PowerApps can you share how to enter ID and Title in JSON Select... Thanks for advance
2 ways, you can filter data in App itself and pass filtered collection to flow or query data source in flow and perform query. Most of this is covered in the video.
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.
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!!
Thanks for your useful information. You already have videos on "Export to Excel" and now "Export to PDF". I'd like to request a video on "Export to Word" that use share point list data. The scenario is in Powerapps view page, we'll have a link or icon to click to export to predefined word template. Thanks you in advanced.
Hey, I had the same issue because of having to create contracts and memos with a lot of dynamic values including a lot of if statements in different languages, so what I came up with is creating the text content including tables as Html in PowerApps, then a button creates a blank but named Word file in a specific file location including metadata using a template path file content and opens it in Word, then user can copy/paste the HTML into, save, done. It also writes the file link back to the app, so you can re-open if needed to adjust. That way, you can us CD headers and footers etc. without the Word connector.
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!
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 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.
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.
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?
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.
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.
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.
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
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
your videos have helped me a lot. Thank you very much for sharing. How can I make the columns go down as rows? I have added 6 columns and only 4 are visible
There is a width limit. For wide column scenarios this would not work. Columns changing down to rows would be complex and would need usage of flow expressions. I will recommend checking on the forums at powerusers.microsoft.com/ in case someone has done something similar.
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
Hey Reza, thanks. I have been waiting for this solution very long time. I have a question- On Select data operation if I have to Split values for specific column field(On key value pair- for Value field), how can I add expression for it. I am struggling with the solution and appreciate your help. Thanks
Split expression depends on your data, your schema etc. Not possible to provide guidance here on chat without looking at your solution. I will recommend you post your query with screenshots on the forums at powerusers.microsoft.com/
Hi Reza, this is excellent. Do you know can you create the PDF based on your dataverse data within Model Driven app directly or just need to embed the canvas app within the Model Driven app form? Cheers!
There are options in model driven apps where you can call a flow. You can also add a custom page (canvas app) in model driven apps. Better option that embedding canvas app.
@@RezaDorrani Cool, I was assuming to have the PDF icon that initiates the Flow I need to put the custom page (canvas app) into the model driven, but if same can be achieved without it then great!!
@@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/
Reza you have explained this video very beautifully. In all the scenarios I am looking at the last scenario which is the Inspection App. I am looking to build this app with HTML and convert it to PDF. I have done this with Word connector but I am looking to build with html. Is there a video on this separate. Or can you do a video on this. I am looking from the creating of the data. Likr taking photo and filling data etc. Do suggest.
I typically tend to build on a use case with multiple videos. This is not a full fledged solution but rather a prototype showcasing different features. I have 3 videos as part of the Inspection App. Video 1 (uploading pictures from camera control) - ua-cam.com/video/iW9dpDntKrY/v-deo.html Video 2 (current video) - exporting to PDF Video 3 (coming next week) - adding digital signatures.
Hi Reza, a very good presentation (as always...). But one question. Have you any exemple where you create a PDF from PowerApps including Office files (Word/excel).
I'm assuming you want to convert word or excel files to PDF. The showcased technique using flow onedrive to convert will work with word and excel. docs.microsoft.com/en-us/onedrive/developer/rest-api/api/driveitem_get_content_format?view=odsp-graph-online
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
Dear Reza , first of all thank very much for this video, but i have a question :) , do you think the PDF format keep the same format Of HTML after conversation ?? . thank you
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!!!
ItemID is the ID of the item for which you need the data to be exported. Video description has links to download sample flows. Video explains how the value is passed.
@@RezaDorrani @RezaDorrani appreciate the reply, top marks on the video. Really useful and on point for what I am aiming to achieve. On the flow I think it's just the 1st flow that I was unsure about. The ms power apps trigger... Thanks.
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.
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
Thank you for the demo! But a question, is there a way for the recipient to be dynamic? For instance, whoever users who would use the app would receive the exported PDF via email. I believe this part was hard coded on your video because you sent the email to your email.
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
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?
Hi Reza, Great video! I wanted to know what the HTML was that you sent from PowerApps for the Inspection Report was? I've attempted the version of this approach you posted recently, however it was unsuccessful for me, and the test inspection use-case is definitely far more simple. Cheers
Hi Reza. Thanks for continuing to share. I have an idea for a video - are you able to show how to add "Like" and/or "Ratings" to a Power App? I have a SharePoint list with ratings enabled, but the app side just fails. Thanks
Hi Reza, thank for sharing. I wanna ask you how did you manage the size of html while you had more than 1 images (photos) in one file? Html file size cannot bigger than 2 MB rite?
Reza, brilliant video as usual. Thanks for sharing. The Export Inspection Report to PDF is very similar to our business use case, but would use images already saved on device, rather than taking photos. How would the capture of images into this App and transmission to Sharepoint differ - would you still use colImages and DataCardPhotos in the App etc, or would you suggest a different solution. Do you have a video on this that would tie with the rest of the app Also, I have been unable to get three of the flows to Import. Export Inspection Report to PDF, Export Inspection Report to PDF with signature, and Export PDF Tabular Data. I get the following error message - Flow save failed with code 'DynamicOperationRequestClientFailure' and message 'The dynamic operation request to API 'sharepointonline' operation 'GetTable' failed with status code 'Unauthorized'. This may indicate invalid input parameters. Error response: { "error_description": "Exception of type 'Microsoft.IdentityModel.Tokens.AudienceUriValidationFailedException' was thrown." }'. Is there something I can do my end to get that to work so I can import and leverage the Export Inspection Report to PDF Flow. Thanks
Great; thank you sir, I have tried this and working. But i have one question In my html content is rotted 90 deg and the html is showing 90 deg but after conversion in PDF content is not rotating. Can you please share that this conversion support rotation or not?
The part where you passed the data set using Json from canvas app to the flow is really cool. Just a question though, is it possible to use parse Json instead of the select action to turn the Json into objects that can be used to create the html table?
Great Video as usual! Do you have any video examples on how to use the PDF viewer? For example view files from a SharePoint document library. If not, that could be very interesting to know more about! :) Keep up the good work!
I have one video coming next week that uses the PDF Viewer. The document in that case comes from list attachments. For PDF viewer to show data from a library, you would need flow. Check this - ua-cam.com/video/ut0g7hsWoC4/v-deo.html
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.
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
Dear Mr Dorrani, Thank you so much for your teaching. It is a simple and clever way to easily accomplish the tasks. By the way, instead of using png file in the demo, may I know if we could embed other files as jpg, tiff, docx. to the single HTML page as well?
Thanks for watching and liking the videos. Embedding images would require getting the base64 code and then add them to the HTML. Note that this approach is limited to small file sizes only. Images will quickly hit the limit.
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.
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
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.
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
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
Simply awesome - you are simply the iron man of powerapp
💪 Thank You!
Reza, I'm from Brazil and I want to congratulate you, your videos help me a lot. ;)
Happy to hear that! Love to Brazil.
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
Thank you Reza for your generosity. I learn a lot from watching your videos 🙂
My pleasure 😊
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.
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 so much for all contents u share on powerapps !
Thank You
Thanks for this video Export to PDF. I'm waiting for long time. That's awesome.
Thank you Shibu
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!
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!
Thanks for sharing this Reza! Really useful.
Thanks Suji
Thank you so much for the shared content !! Another excellent video, congratulations !!
Thanks for watching!
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!
Great video, Reza!
Thanks Allan
Great "flow" in your tutorial here. Great delivery and content. Thank you for sharing.
Thanks Brad
Very good video. I always appreciate your videos.
Thank you Eric
Honestly, I was wondering how to achieve this, thank you
Glad to know this helped
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.
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
Excelent video thanks I learn very much with your tutorials
Glad you like them!
You are the MAN. Thank you again
Most welcome
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.
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!
So useful, great video
Thank you 👍
so simple - so good!
Thank You :)
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? :)
Thank's Reza , very interesting !
Thanks for watching
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.
Thank you Reza!! 🎩’s off
Your most welcome
You are a genius
Thanks :)
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.
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.
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
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: ua-cam.com/video/emAhLzVG9bM/v-deo.html & ua-cam.com/video/1_F9msqF-f8/v-deo.html
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/
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.
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 😊
Reza ... great video that covers a lot of territory. One question on a key point that I'm missing. I am trying to imitate the sequence where you export filtered data to PDF using flow, except I am sending the values from an unfiltered collection. After I get to the Select/Data Operations at around 18:07 and enter 'json(outputs('Data')), I am unable to do any mapping. Specifically, when I select 'ask powerapps', it does not show or allow me to select any of the column headings. Is there another video you've prepared that has those details? I suspect I am missing something simple. :( Thank you! r/ Patrick
For those you would need to write expressions as follows:
item()?[‘propertyname’]
That's a great video, Reza, really helped me...
I'm looking for how to export to pdf using filtering in PowerApps
can you share how to enter ID and Title in JSON Select...
Thanks for advance
2 ways, you can filter data in App itself and pass filtered collection to flow or query data source in flow and perform query.
Most of this is covered in the video.
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.
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/
Thanks for your useful information. You already have videos on "Export to Excel" and now "Export to PDF". I'd like to request a video on "Export to Word" that use share point list data. The scenario is in Powerapps view page, we'll have a link or icon to click to export to predefined word template. Thanks you in advanced.
I will add it to my backlog but I would need a lot more folks requesting it to start working on a video. Word templates are a premium feature.
Hey, I had the same issue because of having to create contracts and memos with a lot of dynamic values including a lot of if statements in different languages, so what I came up with is creating the text content including tables as Html in PowerApps, then a button creates a blank but named Word file in a specific file location including metadata using a template path file content and opens it in Word, then user can copy/paste the HTML into, save, done. It also writes the file link back to the app, so you can re-open if needed to adjust. That way, you can us CD headers and footers etc. without the Word connector.
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.
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 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.
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’]
Amazing content as always Reza. What about if I have a gallery with data from SQL? Is it possible to do this?
Concept should work with any data source.
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.
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.
Really enjoyed this video. Can the same technique be used to create a pdf from a Microsoft list stored in sharepoint, along with images?
Yes you can!
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.
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.
thank you!
Welcome
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
Thanks very much for this demonstration. Question: For the HTML content can I pass content from an HTMLEditor.text component?
Yes, you should be able to.
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
your videos have helped me a lot.
Thank you very much for sharing.
How can I make the columns go down as rows? I have added 6 columns and only 4 are visible
There is a width limit. For wide column scenarios this would not work. Columns changing down to rows would be complex and would need usage of flow expressions.
I will recommend checking on the forums at powerusers.microsoft.com/ in case someone has done something similar.
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
Hey Reza, thanks. I have been waiting for this solution very long time. I have a question- On Select data operation if I have to Split values for specific column field(On key value pair- for Value field), how can I add expression for it. I am struggling with the solution and appreciate your help. Thanks
Split expression depends on your data, your schema etc. Not possible to provide guidance here on chat without looking at your solution.
I will recommend you post your query with screenshots on the forums at powerusers.microsoft.com/
@@RezaDorrani Sure. Thank you
Hi Reza, this is excellent.
Do you know can you create the PDF based on your dataverse data within Model Driven app directly or just need to embed the canvas app within the Model Driven app form?
Cheers!
There are options in model driven apps where you can call a flow.
You can also add a custom page (canvas app) in model driven apps. Better option that embedding canvas app.
@@RezaDorrani Cool, I was assuming to have the PDF icon that initiates the Flow I need to put the custom page (canvas app) into the model driven, but if same can be achieved without it then great!!
@@mkavo It can be done. Model driven apps can call flow.
Thank you for such a great video, Could you please advise us how to add arabic text inside the html to pdf conversion
I'm not sure about arabic text. I would recommend posting your query with screenshots on the forums at powerusers.microsoft.com
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/
Reza you have explained this video very beautifully. In all the scenarios I am looking at the last scenario which is the Inspection App. I am looking to build this app with HTML and convert it to PDF. I have done this with Word connector but I am looking to build with html. Is there a video on this separate. Or can you do a video on this. I am looking from the creating of the data. Likr taking photo and filling data etc. Do suggest.
I typically tend to build on a use case with multiple videos. This is not a full fledged solution but rather a prototype showcasing different features.
I have 3 videos as part of the Inspection App.
Video 1 (uploading pictures from camera control) - ua-cam.com/video/iW9dpDntKrY/v-deo.html
Video 2 (current video) - exporting to PDF
Video 3 (coming next week) - adding digital signatures.
@@RezaDorrani thanks Reza for the reply I shall wait for your next tutorial.
Hi Reza, a very good presentation (as always...). But one question. Have you any exemple where you create a PDF from PowerApps including Office files (Word/excel).
I'm assuming you want to convert word or excel files to PDF. The showcased technique using flow onedrive to convert will work with word and excel.
docs.microsoft.com/en-us/onedrive/developer/rest-api/api/driveitem_get_content_format?view=odsp-graph-online
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.
As always great work Reza. Is there a way to get the generated pdf back into the PowerApp and open it in Acrobat Reader? Thanks!
Shhhhh. That is my next video coming soon :)
@@RezaDorrani Amazing! Can't wait for that!
Dear Reza , first of all thank very much for this video, but i have a question :) , do you think the PDF format keep the same format Of HTML after conversation ?? . thank you
It does keep the formatting, but certain styles are not supported.
@@RezaDorrani Thank you very much for your quick response realy you are number one
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!
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.
Hi Reza. Amazing video. Could you explain what command you need to add to run the flow in the powerapps? what is the itemID.
ItemID is the ID of the item for which you need the data to be exported.
Video description has links to download sample flows. Video explains how the value is passed.
@@RezaDorrani flow download does not work because it is looking for your sharepoint token... you need to remove and export again.
@@johnwealsby4399 flow was shared years ago and I no longer have access to it. The exported zip is the only reference I have.
@@RezaDorrani @RezaDorrani appreciate the reply, top marks on the video. Really useful and on point for what I am aiming to achieve. On the flow I think it's just the 1st flow that I was unsure about. The ms power apps trigger... Thanks.
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.
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
Thank you for the demo! But a question, is there a way for the recipient to be dynamic? For instance, whoever users who would use the app would receive the exported PDF via email. I believe this part was hard coded on your video because you sent the email to your email.
Possible. You can pass the email of the recipient as a parameter to flow.
Nice question, did you solved it?
Great Video . Reza can you please advise can we generate in word documents ? like Power Apps Export to Word file . This is our requirement
There is a word online connector in flow which will allow you to populate a word document.
@@RezaDorrani thank you
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
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 🙏
Hi Reza, Great video!
I wanted to know what the HTML was that you sent from PowerApps for the Inspection Report was?
I've attempted the version of this approach you posted recently, however it was unsuccessful for me, and the test inspection use-case is definitely far more simple.
Cheers
I picked simple HTML from w3schools. All references are in video description.
@@RezaDorrani Apologies, have been back through the video. I see the code you mentioned.
Hi Reza. Thanks for continuing to share. I have an idea for a video - are you able to show how to add "Like" and/or "Ratings" to a Power App? I have a SharePoint list with ratings enabled, but the app side just fails. Thanks
^^yes... I know its not related to this video 😊
I can add this request to my backlog but I will need a lot more folks requesting this in order for me to start working on a video.
@@RezaDorrani Go for it! I'll be showcasing and crediting you in my next training.
Hi Reza, thank for sharing. I wanna ask you how did you manage the size of html while you had more than 1 images (photos) in one file? Html file size cannot bigger than 2 MB rite?
2MB is the limit. My images captured had small sizes. Power Apps mobile app - under settings - Optimize images on upload was turned on for me.
@@RezaDorrani I'm sorry, where did you turned on optimize images? where we can see those settings? thank you
@@loadcvdaily1142 In mobile app, open power apps, click on profile image on top left and you should see that option in menu.
Reza, brilliant video as usual. Thanks for sharing.
The Export Inspection Report to PDF is very similar to our business use case, but would use images already saved on device, rather than taking photos. How would the capture of images into this App and transmission to Sharepoint differ - would you still use colImages and DataCardPhotos in the App etc, or would you suggest a different solution. Do you have a video on this that would tie with the rest of the app
Also, I have been unable to get three of the flows to Import. Export Inspection Report to PDF, Export Inspection Report to PDF with signature, and Export PDF Tabular Data. I get the following error message -
Flow save failed with code 'DynamicOperationRequestClientFailure' and message 'The dynamic operation request to API 'sharepointonline' operation 'GetTable' failed with status code 'Unauthorized'. This may indicate invalid input parameters. Error response: { "error_description": "Exception of type 'Microsoft.IdentityModel.Tokens.AudienceUriValidationFailedException' was thrown." }'.
Is there something I can do my end to get that to work so I can import and leverage the Export Inspection Report to PDF Flow. Thanks
The pdf generated has a size limit. Its not meant for large number of images. You could use any image. All you need is the base64 of the image file.
Great; thank you sir,
I have tried this and working.
But i have one question In my html content is rotted 90 deg and the html is showing 90 deg but after conversion in PDF content is not rotating.
Can you please share that this conversion support rotation or not?
I believe rotation is not supported.
The part where you passed the data set using Json from canvas app to the flow is really cool. Just a question though, is it possible to use parse Json instead of the select action to turn the Json into objects that can be used to create the html table?
Yes, you can directly use parse json.
Great Video as usual!
Do you have any video examples on how to use the PDF viewer? For example view files from a SharePoint document library. If not, that could be very interesting to know more about! :)
Keep up the good work!
I have one video coming next week that uses the PDF Viewer. The document in that case comes from list attachments.
For PDF viewer to show data from a library, you would need flow. Check this - ua-cam.com/video/ut0g7hsWoC4/v-deo.html
@@RezaDorrani Aha I understand! Thanks! :)
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.
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
Dear Mr Dorrani, Thank you so much for your teaching. It is a simple and clever way to easily accomplish the tasks. By the way, instead of using png file in the demo, may I know if we could embed other files as jpg, tiff, docx. to the single HTML page as well?
Thanks for watching and liking the videos.
Embedding images would require getting the base64 code and then add them to the HTML. Note that this approach is limited to small file sizes only. Images will quickly hit the limit.
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.
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
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.
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