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.
@ShanesCows4 жыл бұрын
Awesome! Keep up the learning 🤩
@sunnylove433 жыл бұрын
I've watched many Shane's exceptionally helpful videos, and what I really want to hear is he says " He~~~re's the intro! "
@ShanesCows3 жыл бұрын
Thanks 🤩
@gavinmcdougall29264 жыл бұрын
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.
@ShanesCows4 жыл бұрын
Thanks for sharing Gavin. Pinning so it helps others. 🤩
@jabbist3 жыл бұрын
Thank you. Someone made this super complicated for no reason and it was this simple
@ShanesCows3 жыл бұрын
Glad to help. 😀
@jabbist3 жыл бұрын
@@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
@Andressamagalha2 жыл бұрын
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!
@ShanesCows2 жыл бұрын
Excellent!
@brucethiessen59722 жыл бұрын
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. :)
@threewiseman14 жыл бұрын
Ha, I'm literally just doing this now Shane! Will check out this vid when I get time. You always seem to upload a timely video just when I need it.
@ShanesCows4 жыл бұрын
I keep tabs on you. 😉
@threewiseman14 жыл бұрын
@@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.
@Cheerful_Charish_Reddy2 жыл бұрын
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
@ShanesCows2 жыл бұрын
Get the base64 of each and put them in their own img tags. If you can do one, you can do two. 😍
@grahamsheeley4 жыл бұрын
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. 👍
@ShanesCows4 жыл бұрын
That is the fun part 😍
@kvartover4 жыл бұрын
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!
@ShanesCows4 жыл бұрын
I get a lot of requests for booking apps. Maybe one of these days :)
@kvartover4 жыл бұрын
@@ShanesCows I'm sure you do - we all want to learn from the best :)
@tymothylim65503 жыл бұрын
Thank you very much for this video, Shane! It was very educational for me and this has gotten me quite interested in Power Apps! :)
@ShanesCows3 жыл бұрын
Awesome. If you are new to Power Apps then at training.powerapps911.com I have a free intro class.
@jyothisrinivas66374 жыл бұрын
Thank you Shane for upload this video. This is one of the very very good stuff in real time scenario.
@ShanesCows4 жыл бұрын
Glad you liked it. It is a great core skill.
@carnuroalnanda52414 жыл бұрын
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.
@dianasoares78233 жыл бұрын
Amazing!!!!!! This video helped me so much! Thank you for making those power apps videos!
@ShanesCows3 жыл бұрын
Glad to help. 😀
@nguyenvietand3 жыл бұрын
Thanks Shane for all videos you made. They are very helpful to me. Is it possible if I want a user can only use the Power app on a specific devices.
@ShanesCows3 жыл бұрын
Not that I know of. 😑
@yazeedablan59702 жыл бұрын
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.
@NKBobcat4 жыл бұрын
Thanks again Shane. Relevant as usual!
@ShanesCows4 жыл бұрын
Glad to help. 😀
@sunshinelabz4 жыл бұрын
Hi Shane, For Curated PowerApps Video Library which all libraries will get ?
@ShanesCows4 жыл бұрын
All of my Power Apps and flow videos. You can email me Shane at PowerApps911 dot com for more info
@ashokpershad4 жыл бұрын
My first comment...i am.sure this.video will also be as awesome as always...will watch soon 😀😀👍
@ShanesCows4 жыл бұрын
Thanks 😊
@sheshd3 жыл бұрын
Thanks mate. Saved me!!!
@ShanesCows3 жыл бұрын
Happy to help
@sheshd3 жыл бұрын
@@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!
@MsGeoffers3 жыл бұрын
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?
@ShanesCows3 жыл бұрын
I am not sure. I haven't used any of this with gmail nor do I have a gmail address to test with 😮 so not sure.
@blutkraehe_official2 ай бұрын
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
@ShanesCows2 ай бұрын
Every email client handles HTML differently. You could try adding and see if you get better results.
@darrellbrummund96094 жыл бұрын
Another great helpful video, nice
@ShanesCows4 жыл бұрын
Thanks Darrell. Good to see you back in the mix. 😻
@thomasschaub94744 жыл бұрын
Awesome vid... thanks Shane!
@ShanesCows4 жыл бұрын
Glad it helped.
@mvos19804 жыл бұрын
Thanks Shane! Again a nice video.
@ShanesCows4 жыл бұрын
Glad to help. 😀
@alfredoouro79454 жыл бұрын
Very good! Thank you!
@ShanesCows4 жыл бұрын
Glad you liked it.
@uncleslapslap3 жыл бұрын
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).
@ShanesCows3 жыл бұрын
I think I covered just this here kzfaq.info/get/bejne/mK-emJZ1qZmscZs.html
@DanielLempert3 жыл бұрын
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!
@sugusenthil70413 жыл бұрын
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?
@ShanesCows3 жыл бұрын
I have tried and most if not all of them have not worked. Boo
@user-wv1gt8os3i22 күн бұрын
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.
@ShanesCows20 күн бұрын
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. 🤩
@user-wv1gt8os3i20 күн бұрын
@@ShanesCows , thank you very much for your guidance.
@keithdavies91503 жыл бұрын
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 (?)
@ShanesCows3 жыл бұрын
Yes. The html control can’t show base64 or any images 😕
@arunrohilla95973 жыл бұрын
@Shane : Please confirm.If we can use the power flows and Html to create multiple page PDF of all my SCREENs?
@ShanesCows3 жыл бұрын
Yes, this is the first of many videos I have on the topic. kzfaq.info/get/bejne/aNiWdLSWltGvaIE.html
@arunrohilla95973 жыл бұрын
@@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?
@amyanderson12803 жыл бұрын
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.
@ShanesCows3 жыл бұрын
The html control in Power Apps doesn’t show images. :( You would need to us an image contral
@amyanderson12803 жыл бұрын
@@ShanesCows thank you so very much! Sounds like it is doable, i will go through the rest of your videos to see if any help. I appreciate your time.
@mariadejesusrizo3365 Жыл бұрын
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?
@raulcabezasestrada18774 жыл бұрын
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.
@ShanesCows4 жыл бұрын
The attachments column is a table. Try using a gallery to view its contents
@raulcabezasestrada18774 жыл бұрын
@@ShanesCows It worked! You are amazing!
@sugusenthil70413 жыл бұрын
For converting pdf file using one drive connector, is there any other connector helpful to convert pdf without using third party connector?
@ShanesCows3 жыл бұрын
Nope. Sorry
@121balu Жыл бұрын
By using power automate how I will forward email with including images which is present in mail body
@mictow3 жыл бұрын
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?
@ShanesCows3 жыл бұрын
I don’t think this is possible
@charlessterling3794 жыл бұрын
Another great video!
@ShanesCows4 жыл бұрын
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 😍
@TheToni21234 жыл бұрын
Thx Shane.
@ShanesCows4 жыл бұрын
You are welcome 🙏
@robertoferreira56222 жыл бұрын
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?
@PaulShadwell4 жыл бұрын
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?
@ShanesCows4 жыл бұрын
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. kzfaq.info/get/bejne/aNiWdLSWltGvaIE.html
@GillesManiglier4 жыл бұрын
Just great, as usual!
@ShanesCows4 жыл бұрын
Thanks 😊
@AA-gn3lr3 жыл бұрын
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!
@ShanesCows3 жыл бұрын
I am not sure. I haven’t tried that one. 🤔
@AA-gn3lr3 жыл бұрын
@@ShanesCows okay shane, thanks
@christinachristophi57434 жыл бұрын
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
@christinachristophi57434 жыл бұрын
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?
@ShanesCows4 жыл бұрын
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. kzfaq.info/get/bejne/aNiWdLSWltGvaIE.html
@frenske20024 жыл бұрын
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.
@ShanesCows4 жыл бұрын
I doubt it. When I need a lot of images or more flexibility I find myself using Azure Blob Storage
@frenske20024 жыл бұрын
@@ShanesCows Thanks for the anwer. By blob storage you talk about SQL?
@prasadjoshi48124 жыл бұрын
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.
@ShanesCows4 жыл бұрын
It code have some lag depending on your file size.
@prasadjoshi48124 жыл бұрын
@@ShanesCows Thanks will check again for optimization
@robertwilson66833 жыл бұрын
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?
@ShanesCows3 жыл бұрын
Yes. You would do a LookUp to the collection where you stored the predefined base64 to retrieve it.
@sundrapillay66684 жыл бұрын
Thanks Shane
@ShanesCows4 жыл бұрын
You are welcome 🙏
@gabrielmens49563 жыл бұрын
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!!
@ShanesCows3 жыл бұрын
You have to have a character out of place. If you look at he html does it look right? Maybe an extra “ or space?
@shinshae78823 жыл бұрын
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
@pelinsen13 жыл бұрын
hi, thanks for the video. Is there any way to open this image on browser? Launch function is not working.
@ShanesCows3 жыл бұрын
File has to be hosted to be shown in a browser.
@dimplekapoor86003 жыл бұрын
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
@ShanesCows3 жыл бұрын
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.
@karolmalicki75903 жыл бұрын
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?
@ShanesCows3 жыл бұрын
You wuold have to loop through them. Concat is probably the way to go :)
@susanteng35923 жыл бұрын
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
@ShanesCows3 жыл бұрын
Susan you will need to look more at your HTML. Should work. Try manually working with your and get it working hard coded. Then try the dynamic.
@fernyezz02102 жыл бұрын
Sent E-Mail to someone else but the picture doesn't show. Is there a way?
@johannespurchase31854 жыл бұрын
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
@ShanesCows3 жыл бұрын
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.
@troyhiles9134 жыл бұрын
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?
@ShanesCows4 жыл бұрын
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 kzfaq.info/get/bejne/iKyKmdmF2qrRgGQ.html
@karteekabcd4 жыл бұрын
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.
@karteekabcd3 жыл бұрын
@@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.
@TarcisioPqdt3 жыл бұрын
Is it possible convert URL's image to base64 with Power Automate? How I can do that?
@ShanesCows3 жыл бұрын
Not that I know of but maybe. You have to get File Content of the file with an action.
@muhammadgarba7162 Жыл бұрын
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..
@antobourntec6352 жыл бұрын
Can you please tell me how to download a binary data in power apps? I got this binary from amazon S3
@XrumerServer3 жыл бұрын
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
@ShanesCows3 жыл бұрын
NOt that I know of but I have never tried.
@zhiqiangwang10682 жыл бұрын
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?
@XaljakalX Жыл бұрын
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
@ShanesCows Жыл бұрын
NOt possible. You can show the base64 inside of an Image control but not an HTML control that I know of.
@XaljakalX Жыл бұрын
@@ShanesCows any way i can show any image ( i mean base 64 or other ) inside html without using flow?
@fabiomonteirodias20794 жыл бұрын
Can I use the power automate to convert an image to base64 and them use the result into powerapps?
@ShanesCows4 жыл бұрын
Yes you can. I show the concept briefly here kzfaq.info/get/bejne/aNiWdLSWltGvaIE.html
@aarounge2 жыл бұрын
Could u help me understand how to get SharePoint list columns in Rich text format into my PDF that I'm generating from Flow
@ShanesCows2 жыл бұрын
The RTF should be html and should just insert? Are you seeing something different?
@aarounge2 жыл бұрын
@@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
@aarounge2 жыл бұрын
@@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.
@syedabidaliabdi12733 жыл бұрын
Isn't there any way to reduce the size of an image on runtime?
@mulatozroaster94833 жыл бұрын
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.
@ShanesCows3 жыл бұрын
I run into some weirdness with that. In this video kzfaq.info/get/bejne/abeRnLBpuMu7loE.html I show a Mid formula for stripping those extra characters also but it sounds like got it.
@mulatozroaster94833 жыл бұрын
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!
@franknielsen32193 жыл бұрын
SOOOOOOOOOOOO cool video this one :)
@ShanesCows3 жыл бұрын
Thanks 🙏
@otrocomentariomas3 жыл бұрын
Easy and simple. Thanks !! Does anyone knows how to align the images in a PDF?
@mardithpascua81123 жыл бұрын
hi shane, can a appress/blobmanager be converted and use also for ms flow email?
@TarekOne3 жыл бұрын
Great Video As usual , is there a way you can combine multiple jpg files into 1 PDF ???
@ShanesCows3 жыл бұрын
Not with free actions but there are some paid options in flow that can do it.
@TarekOne3 жыл бұрын
@@ShanesCows would you please mention names of the paid actions?
@abdulkhadir26614 жыл бұрын
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
@ShanesCows4 жыл бұрын
I will see but no promises.
@nipun3994 жыл бұрын
Hi Shane, If I am having 50 image in powerapps gallery, can I convert 50 images into binary and then into PDF?
@ShanesCows4 жыл бұрын
Probably not. The html has about a 2mb limit so they would have to be tiny images.
@nipun3994 жыл бұрын
@@ShanesCows any alternative?
@danielbell91924 жыл бұрын
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?
@ShanesCows4 жыл бұрын
It is on my list. 😀 I did it with Flow to test it out and it worked.
@danielbell91924 жыл бұрын
Shane Young looking forward to it! 👍👍
@zameer.vighio2 жыл бұрын
Hi Shame, i want to convert file attachments into base64 and then wana send base64 text to my API
@ShanesCows2 жыл бұрын
Follow this video kzfaq.info/get/bejne/abeRnLBpuMu7loE.html and instead of CreateFile in SharePoint in the flow you would Put/Post to your API.
@zameer.vighio2 жыл бұрын
@@ShanesCows ok sir, bundles of thanks
@davidantonio71273 жыл бұрын
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...
@davidantonio71273 жыл бұрын
By the way you create very good videos that answer many questions so I could imagine how to create my flow...
@stugryffin36192 жыл бұрын
Misleading title. Power Apps is not converting image to base64. Web tool is executing the conversion then you're using the output in Power Apps.
@ShanesCows2 жыл бұрын
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.
@stugryffin36192 жыл бұрын
@@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.
@randyarmy034 жыл бұрын
Good sir! Can you please do a video on counting SharePoint list items based on a filter in Microsoft flow?
@ShanesCows4 жыл бұрын
Depending on how many items you have you could use either CountIf(datasource, formula) or CountRows(filter(datasource, formula))
@randyarmy034 жыл бұрын
@@ShanesCows thank you sir!
@prakhargupta8141 Жыл бұрын
Hello @shane, at 11:14, i am also applying the same logic, but I want that image to be aligned to right, I tried writing -
@ShanesCows Жыл бұрын
I think you need to put the image in a Table and then set the TD to align right.
@dion4894 Жыл бұрын
@@ShanesCows I have this exact question/problem. for some reason i can't get the image aligned to the right in a PDF...
@varaprasadkosaraju76963 жыл бұрын
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.
@ShanesCows3 жыл бұрын
Hi Vara I don’t know. 😕 makes sense but I haven’t tried this one.
@varaprasadkosaraju76963 жыл бұрын
@@ShanesCows np
@fernandopenaloza11953 жыл бұрын
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
@ShanesCows3 жыл бұрын
Never tried but sounds like fun. If you get it figured out let me know.
@arunrohilla95973 жыл бұрын
I am trying the same...will confirm when it is done
@fernandopenaloza11953 жыл бұрын
@@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
@deongovender16164 жыл бұрын
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
@ShanesCows4 жыл бұрын
Deon you will have to write an If formula that matches the logic you wrote here. You got it and remember you can use Or to check multiple criteria.
@deongovender16164 жыл бұрын
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
@mtamitolanga3 жыл бұрын
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"
@ShanesCows3 жыл бұрын
You have to push it through an image control to get the base64 version of it I think
@FlowerBot2 ай бұрын
now show me how to email an image (or several) that is/are linked inside a rich text field from a SharePoint list..
@ShanesCowsАй бұрын
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 kzfaq.info/get/bejne/b9uglcSC0reaiIU.html
@aaronbeebe28413 жыл бұрын
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!!
@ShanesCows3 жыл бұрын
I responded to your other comment.
@prasannamannuru78123 жыл бұрын
@@ShanesCows where , can I see the answer to that ??