Okay so I have been watching your videos(over and over again most of the time) for a few months and I have really grown as a creator. I have finally figured out how to use images uploaded *dynamically* from power-apps and put them into a variable in automate. Then call the variable in a concat, and create an HTML file in one-drive. Then when a file is created in one-drive have a separate flow create a file in SharePoint and shoot a confirmation email to the user with a link to the file location. The end user can access to the HTML and print as PDF. Game changer. I am thrilled I ran across one of your videos and watched it over and over until it started to make sense. Thanks again Shane.
Hi Shane, thank you for all you videos, they really have helped me get my apps working well. Just a note, at the point (15:13 in the video) you wanted to refresh the component, you closed the app and then opened. If you click on the 3 ellipsis next to the "Search" box, you have a "Check for updates" option, negating the need to close and open. Hope this gives back a little for the large amount your videos have helped me.
@@ShanesCows Tremendously. I created my first program to take data from PowerApps, add rows into Excel, and send an email with the company header and the excel data in it thanks to your videos. 10/10
Thank you! I was not able to add my image with Data URI, once the stage I needed to start the variable was not the correct one and I could not change it. Now it worked perfectly. Thanks again!
@@ShanesCows My plan is to rework the way my app stores images in my SharePoint lists. Presently, I'm using a flow connected to the add image control(s) to grab the image and store it as an attachment to the given list item referred to in the powerapps form. This has been 'working' however there are occasions where the flow fails for this-or-that reason and that can cause a mess down the production line as images get incorrectly ordered. (My app is effectively an automated editorial desk for the purpose of automated pagination in Indesign for our local printed newspapers). My thinking was that I would instead use powerapps to grab the base64 encoded data using a formula and store it in a unique column in my SharePoint list (Image001 to Image010) instead of relying on the limitation of the single attachment column. But reading into what you're saying in this vid, I'm having reservations. A 'story' (list item) could have up to 10 images of around 3-5mb each, and we produce at least a couple of hundred stories per month. If you don't mind answering, and can vaguely understand what I'm rambling about, would I be creating data-zilla by doing this and potentially break everything? My intent is to also hide the base64 columns in SharePoint so the browser doesn't need to load all the characters, for whatever that's worth. Appreciate if you're able to give a vague answer, but I understand this is a vague and complicated question.
Hi Shane. Your videos are super awesome! Thank you!!! I have been looking for something all over the web, and your video is the closest I have found... I am needing to dynamically create thumbnails from images in a datasource to embed into html (for email and PDF purposes). Your video describes images that are known in advance, i.e. company logo, whereas I am wanting to include images in the invoice detail section that will be different each time. In addition to creating Base64 dynamically, I need these to be downsized to a predefined size, i.e. 100x100 px. Might this be an upcoming video? Pretty sure others would benefit from this as well. :)
Hi Shane, Thanks for your videos and efforts for educating us, "What formula should I use if I want to attach signature and image" Your prior reply on this will help me a lotttttt
Excellent, thanks for sharing. Great solution if you have images in emails that reference O365 source images. Fine for all your employees but if the email gets forwarded to externals, or the employee is reviewing the email when not connected and don’t have access to the O365 sources. This way the images will still work. 👍
Hi Shane! Thanks for all the videos you make, you have saved me sooo many times :) Thanks to you I love working with powerapps! I would love to see how you would build an app for booking of office rooms/meeting rooms (connected to the outlook calendar) with a floor plan to see which office/meeting room is selected. Keep up the good work and have a nice summer!
Hi Shane, thank you for all you videos, they really have helped me get my apps working well. Just a note, can i do this automatically without going to the base64-image website, thanks in advance.
hello, only a small standard preview image is displayed, but unfortunately not the whole image in the email client, what am I doing wrong? Kind regards
This is glorious, I've been looking for "what's your conversion rate in email marketing" for a while now, and I think this has helped. Have you heard people talk about - Jenevi Digital Duppy - (do a google search ) ? Ive heard some unbelievable things about it and my partner got excellent success with it.
Shane, I *think* that images could be converted to base64 dynamically fully within PowerApps, this would really open-up some possibilities. I haven't tried yet but it looks like when you store an image in a collection that PowerApps stores it in the Data URI scheme which is just Base64 with some HTML at the start that could be stripped. I think you'd have to make a collection from the collection, example: ForAll(colPictureList,Collect(colBase64Image, { filename: "myimage.jpg", filebody: Url })). Hopefully I'll have time to play with this next week, but it might be beyond my skills TBH. My goal is to be able to print a dynamically generated QR code (I just emailed you about QR codes thing).
Hi Shane, can you do a video on how to add a picture into the background of a pdf that I create out of PowerApps? Should be like a watermark behind a table That would be awesome!
Shane, I need your help. I have a SharePoint list, with several columns, one of which is an image column. I'm using PowerApps to register this data, using the patch function. The data to register comes in an Excel spreadsheet, the image is a link. I am unable to use the patch function to register a new item, there is a problem with the image column, it does not accept the link to register with the patch function. Would you have any guidance on how to resolve this. Thank you for your collaboration.
The Image column is special and cannot be patched. 😞 You could store the url in a hyperlink column and set the type to picture. This would work based on what I read. 🤩
This is really useful, Shane, and thanks for pointing me to it from another of your videos. I am embedding the Base64 code into the HTML for an email. The output renders fine in Outlook and now also in both Yahoo and Roundcube email clients, thanks to the Base64. But still not in Gmail. Any ideas? Also, do you have Patreon or similar?
Hi Shane! Had a question about embedded images coming in from a user email. I'm trying to get those embedded images to display within the HTMLText field I'm displaying the email body in but it usually doesn't with the exception of a few images it does display for some reason. Is there any way to display these embedded images?
outstanding video, great sense of humor! I have customized the power app Meeting Capture and am having trouble customizing the email output. I can change what is says by using onvisable to see the code but i want to insert a header that is an image, same size as the pink header that is defaulted. I have the image, ran it through the base64 as you showed here but i am not sure how to get that into the code when looking at the welcome screen onvisible html. Any ideas would be so appreciated, i so want to be successful at this power app.
Hi Shane! I tried something like You did, but my PDF file does not show the images. I put it in a table, to a better design, at the browser the file works well, but at the PDF file some formats and images does not work/appear. Cold You help me?
I have saved video links in Sharepoint list , connecting sharepoint to power apps, i wanted to play the videos in Power apps, i'm able to play it in power app browser but not in mobile device it is showing black screen
Because your mobile device doesn't have a connection to the SharePoint list like your browser does. You have to get the file from SharePoint not via the URL but by a data connection. I still don't have a video on this sorry.
Hi Shane - great video (as always) but I have a small snag that I just can't find a solution for at the moment. I've tried using the base64 code directly in the htmltext body and storing it in a variable but I can't get the image to display in a preview htmltext control on the screen. Is this the same kind of issue as trying to use tables with borders in an htmltext control, do you think? It does come through in the email but as I'm trying to use it as an email preview before sending it's not quite as useful as I thought. Bizarrely, if I link to images stored in a shared drive they do appear in the preview control (?)
@@ShanesCows i have seen this video and this doesn't talk about how to break your pdf in multiple pages. There was another video that you have uploaded 2 months back for the same... I will try using that... Thank you both these videos. Really very helpful.. i will try to return some of the favor by sharing your videos and content... it's the least that I can do... One last query.. My HTML tables are populating very nicely in the HTML files that gets created, but when it gets auto converted into PDF via power apps flow, the tables gets distorter/unstructured... Loose their colors, borders, shapes...almost everything... Is they any solution for that?
@@ShanesCows I've had to do a last minute project in power apps with literally 0 experience of prior knowledge - I'm a sys admin not a Dev - your content has been amazing. Literally watched this video on the bus in to work, got in and implemented it without issue. This whole time I was trying to link images in the html and they kept failing on the email delivery!
Hi Shane! Im a huge fan of your videos. Now im dealing with an issue: I need to allow user of an app to inser multiple images in rich text editor, after that i will put all the user writes within the app to a Word Document. The issue im having trouble is allowing user to inser image within a paragraph of their response. Can you help me with this?
Thanks Shame, this is great for fixed images, however what if the image would be a dynamic one - based on a person field, could I for example, create a table in the app somewhere with all thee base 64 for each potentially dynamic image (There will be a finite number based on approved people) and then do a lookup adding in the base 64 into a label, and then refer to the label in the HTML text field?
Hi Shane, I gave this a go but for some reason my Logo doesn't show up. I used an image tag inside a HTML text field in PowerApps, it recognises the code but doesn't display the image. Am I doing something wrong? My code looked like this
So I was able to attach the logo by inserting an img tag that points strait to the file path. My flow generates a html file (which recognises the logo image) but when I convert the html to PDF, the logo just displays as a red X. Any ideas?
It is annoying. The html control in Power Apps will not show a base64 image only a file. The conversion from html to pdf will show the base64 but not a link to the file. 😐 This video I show how to go from file to base64 in flow if that helps. ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-2rfAQe1kK8M.html
Hi Shane, great video. Thanks for all video you posting is very helpful to learn things quickly. My question is do you try something like custom fonts like Dancing Script font implement in PDF?
Hi Shane! I have one question, how do I actually create a pdf for a SharePoint list item that includes its attachment image inside the pdf? Because I tried to create but unsuccessful only for the image into pdf step. Other column have no problem. Hope you have solution for this. I use power automate for this activity. Thanks!
Excellent video once again. I have a problem which I haven't found in your series yet. I am extracting attachments from emails then putting the attachment into a SharePoint Document Library, using PowerAutomate, that works, but, I also want to save the body of the email as a separate PDF file along with the attachments. Is there a way to do this? I can save the body in a multi line metadata column added to the file but then how can I display it in a formatted HTML way instead of just showing the raw HTML? I tried using an HTML text control but it doesn't show up in the SharePoint form. Any ideas?
Should work fine. Use this video for the steps of making a pdf. Where I ask in Power Apps in the video you pull from the email body. ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-2rfAQe1kK8M.html
Hy Shane, thanks for the video. i have been trying to send email using a base64 image saved in a variable, i have been trying to add the variable to make it work but it's not working... help please..
Hi Shane. In first place i'm grateful for your helping. I'm learning too much! I want to ask: How can i get to show pics and pdfs saved as attachment in some records of Power Apps? Now they are only in Sharepoint Lists.
Thanks Shane. This tutorial is very helpful. I convert image to base64. It works in Power App when replace image by base64 code. It doesn't work, when I replace base64 code in HtmlText in the part
Hi Shane, thank you for all of the awesome videos! Tried to put an image into a pdf as you described in the video. For some reason, the pdf is just generating a red X instead. I tried to send an email to myself and the same thing happened. When inserting the image code into powerapps, it appears fine on my screen, then when I plug the exact code into the pdf or email surrounded by , it's not working.. Any idea why? Thanks!!
Thanks Chuck. That means a lot coming from a guy like you. ☺️ Bonus feedback. My kids were fishing this morning and my oldest caught a bass with a spinner bait for the first time 😍
Very helpful tutorial, thank you. How I can automatically convert all images from the galley? so i can put them all in a .pdf file and send them by email?
Hi Shane , would it be possible to display this base 64 image iniside a HMTL control in powerapps canvas app ? it is not showing for me the image if you would be kind enough to post a link to something your covered with this or actually tell me how in the comment , thank you in advance
Hi Shane, so i am truly very new to PowerApps, been doing it for a month or so, and have been watching your videos to get the app done i need for my daily work, however i need some help, and i do not know where or how to find it, so i am using HTMLtext to create a interface for printing Certificates into .pdf format, so i have managed to get the image into Base64, and added it, on the HTML file it looks perfect, but once it converts to PDF the logo's are centralized, and it is no more over 1 page it is 2 pages long, and i need it to be only one page in size. can you assist
It is all possible just takes a lot of trial and error with the HTML. It is a topic I cover in my advanced class because it is hard. :( No easy answer here. Sorry.
Great Video! Shane. I have problem to convert html file into PDF when images are too big sized. Only 2M HTML file could be converted to PDF. Do you have any solution?
Hi Shane, Thanks for the video. Does the encoded images makes the app slow? I am trying to save the encoded images using SaveData for offline use and is experiencing some lag.
Hi Shane, Email nd image control part is working for me, but for PDF logo part is not visible, is there is any reason for it ? If we add logo inside the control 'html text ' then also it is not working
Hi Shane, I'm very happy with your video's. They helped me a lot, when creating my first app. In my app I have a lot of images created with the camera and saved as Base64. In total these are about 40-50 for every record. When opening the list in SharePoint is very very slow. In my test case I had only 6 or 7 records added. Is there anything I can do about this? Any help would be very much appreciated.
@@ShanesCows the thing is I'm not sure how to insert it in a specific position in the PDF, any idea how? I was using the replace function but I realized that's only for strings, so the text was getting populated into the PDF but no images. Pls help
@@ShanesCows i have used the column setting in Sharepoint list as "Enhanced Rich text format" coz this column could be text , tables , images and what not. but i`m at ends to understand how to get such columns in the pdf file I`m tryig to generate.
Thanks for the video, Shane. Is there a way to convert 64base image in png (when taken a Photo from camera) to base64 jpg inside powerapps before uploading, it would be 10x faster due to jpg compression? Power apps only takes photos in base64 png
Hi Shane, Could you show us how to add Base64 to compose connector from flows? I did create a flow using PARSE connector where a put a table in html in order to create a file but I don't know how to add image inside of table...
Thanks Shane! I'm trying to use the Camera function to take pictures and then included them on my PDF output. I was able to do it with Static Photos, but unable to add the photos captured the PDF. Are you able to help? Any Suggestions?
I am pretty sure you can use this video. It is about pen input but same concept should work with an image from camera PowerApps Pen Input to SharePoint ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-RFZfvTuDmP0.html
Hi. With what I have learnt from Shane's videos, I was able to do just this. Here is how we did this: 1) Add a camera control and capture the image, using JSON function converted the image to B64 encoding. (Shane has a video on this) 2) Store the B64 string into a SP list 3) Add HTML component and read that B64 back from SP using IMG SRC tag. 4) Hook the HTML to flow and convert it into PDF. One catch I found while working with images was, PowerApps IOS app compresses the images by default which is really really helpful or else as Shane mentioned, the B64 encoding would be millions of characters and wouldn't fit in SP list. Hope that helps.
@@hudsonquay I am using Single line of text. The default option in the Power Apps IOS app which compresses the images by default is really helpful here. There were cases where I tried to insert images from my desktop that weren't compressed but it failed as the b64 string was too long. So, as long as the image is uploaded from the phone app compressed, it works. Hope this helps. Also, I am not aware of max char limit that you mentioned.
Hi Shane .. please please please please please help n do an video on help desk app in powerapps .it's very useful to everyone not only me .. please do it
Follow this video ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-3QaiM8SeWfM.html and instead of CreateFile in SharePoint in the flow you would Put/Post to your API.
Hello Shane. Great video like always!. I have a question about this function : Set( ImageJSON, JSON( SampleImage, JSONFormat.IncludeBinaryData ) ) This function actually does the same as in that www.base64-image.de. Input image in Powerapps, and convert it to that 'gibberish' text. But the weird part for me is, i actually have to remove the quotation mark (") from the variable ImageJSON so i can display the image correctly using Media image in Powerapps. Because i saw in your video, after you copy the text from www.base64-image.de, you definitely add " symbol in the first and the last part. Any idea why did this happen? Thank you.
I run into some weirdness with that. In this video ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-3QaiM8SeWfM.html I show a Mid formula for stripping those extra characters also but it sounds like got it.
Good morning from Indonesia Shane! Thanks for the video links. It works great for me. And this is my version because i use it only for uploading image to my sharepoint library. Set(varImgBase64,JSON(UploadedImage.Image,JSONFormat.IncludeBinaryData)); Set(varImgBase64, Mid(varImgBase64,Find(",",varImgBase64)+1, Len(varImgBase64)-Find(",",varImgBase64)-1)); Set(varIDImg, PowerAppsBase64toSPLibraryWithID.Run(AddMediaButton.FileName,varImgBase64).fileid); The rest of the code i followed your step, the differences were: 1. I use the AddMediaWithImage instead of Attachment control 2. The file name comes from AddMediaButton.FileName 3. I tried to only use 1 variable (varImgBase64) and it worked too! 4. The last line of the code was just to retrieve the file id in sharepoint library because i need to look it up to match a set of sharepoint list data I noticed that if i uploaded image using phone camera from AddMediaWithImage, then the average maximum file size is only around 300 kb which is sweet. (after trial around 200 photos, all the file size is around that 300 kb, even after i changed the settings in my camera to high resolution) But if i upload image from AddMediaWithImage and took the file from gallery, then the file size will follow the original image. And again, thank you so much for sharing!
Hi Shane, would you be able to do a video showing how to use powerapps to send messages to your users in teams chat and also posting to channels within a team!? I read that this is possible?
Hi Shane, Great Video. Have a question on base64 encoding for an external image. Eg: When i upload an image to image control and use Set( ImageJson,JSON( Image6.Image,JSONFormat.IncludeBinaryData ) ). It converts to base64 and it works perfect. In my scenario i have get external image from an url(barcodes4.me/barcode/c128b/12223335555555.png) and convert this to base64 which seems not working when i use JSONFormat.IncludeBinaryData. It just returns complete url instead of base64. Any thoughts on how to address this.
Hi Shane am I able to push the peninput image to SharePoint list field. When I try to do so I get this in SharePoint "appres://blobmanager/7575e6e5cdb64737a756ebc445dbc874/8"
Hello! Great video, I would like to know if there is possible attach files into a HTMLtext control as base64 encode, and then using “href” link download the base64file
@@arunrohilla9597 Thank you! I found that PowerApps automatically saved my links with relatives URLs, eliminating the “azure.sharepoint.com/sites” And I solved using the “substitute” function which replace the string ‘sites/‘ in all the links inside the HTML control to my absolute url
Stu I can see how this wasn't what you were looking for. Working on a new video, I will release today, that will tackle this topic differently and hopefully be more of what you are looking for. Hint we use the JSON function to get the base64. 🙂 Hopefully it scratches the itch. Thanks for the feedback.
@@ShanesCows Thank you Shane. That's a great development. Trust is a huge deal in these times and I'm very sensitive to feeling misled :). Look forward to the next vid. Sounds exciting.
Hello Shane, thank you for the very informative PowerApps videos, you have helped me alot with learning PowerApps, please help me with my query if possible, a bit off topic for this video. I have 3x approval dropdowns on SharePoint List with the following values for management approvals, default set to ASSIGNED for new items. Choices ASSIGNED APPROVED REJECTED I have a PowerApp with an edit form and a PowerApp dropdown with the following values for progress visability on the item UNDER APPROVAL VACANCY OPEN NOT APPROVED I want to update the PowerApps dropdown when the SharePoint List choice dropdown values are as below, kindly advise how to do this. I am a beginner level, so please be as detailed as possible. Thanks If any status on SP list dropdown = ASSIGNED PowerApp dropdown = UNDER APPROVAL All status on SP list dropdown = APPROVED PowerApp dropdown = VACANCY OPEN Any status on SP list dropdown = REJECTED PowerApp dropdown = NOT APPROVED Thanks in advance
Hi Shane, thank you kindly but I managed to figure it out, I will post the result here if you like, and thanks for the great great work you are doing, much appreciated, Deon
Can you get the base64 out of the field? If you can you can do it, if not... I am not sure. This video I talkd about pasting screenshots with the rich text control and saving them to SharePoint. Might give you some ideas ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-9upbaQmQ6XQ.html
Hi Shane, thank you for all of the awesome videos! Tried to put an image into a pdf as you described in the video. For some reason, the pdf is just generating a red X instead. I tried to send an email to myself and the same thing happened. When inserting the image code into powerapps, it appears fine on my screen, then when I plug the exact code into the pdf or email preceded by , it's not working.. Any idea why? Thanks!!