Awesome! Keep up the learning 🤩

Thanks 🤩

Thanks for sharing Gavin. Pinning so it helps others. 🤩

Glad to help. 😀

@@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

Excellent!

I keep tabs on you. 😉

@@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.

Get the base64 of each and put them in their own img tags. If you can do one, you can do two. 😍

That is the fun part 😍

I get a lot of requests for booking apps. Maybe one of these days :)

@@ShanesCows I'm sure you do - we all want to learn from the best :)

Awesome. If you are new to Power Apps then at training.powerapps911.com I have a free intro class.

Glad you liked it. It is a great core skill.

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.

Glad to help. 😀

Not that I know of. 😑

Glad to help. 😀

All of my Power Apps and flow videos. You can email me Shane at PowerApps911 dot com for more info

Thanks 😊

Happy to help

@@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!

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.

Every email client handles HTML differently. You could try adding and see if you get better results.

Thanks Darrell. Good to see you back in the mix. 😻

Glad it helped.

Glad to help. 😀

Glad you liked it.

I think I covered just this here kzfaq.info/get/bejne/mK-emJZ1qZmscZs.html

I have tried and most if not all of them have not worked. Boo

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. 🤩

@@ShanesCows , thank you very much for your guidance.

Yes. The html control can’t show base64 or any images 😕

Yes, this is the first of many videos I have on the topic. kzfaq.info/get/bejne/aNiWdLSWltGvaIE.html

@@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?

The html control in Power Apps doesn’t show images. :( You would need to us an image contral

@@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.

The attachments column is a table. Try using a gallery to view its contents

@@ShanesCows It worked! You are amazing!

Nope. Sorry

I don’t think this is possible

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 😍

You are welcome 🙏

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

Thanks 😊

I am not sure. I haven’t tried that one. 🤔

@@ShanesCows okay shane, thanks

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. kzfaq.info/get/bejne/aNiWdLSWltGvaIE.html

I doubt it. When I need a lot of images or more flexibility I find myself using Azure Blob Storage

@@ShanesCows Thanks for the anwer. By blob storage you talk about SQL?

It code have some lag depending on your file size.

@@ShanesCows Thanks will check again for optimization

Yes. You would do a LookUp to the collection where you stored the predefined base64 to retrieve it.

You are welcome 🙏

You have to have a character out of place. If you look at he html does it look right? Maybe an extra “ or space?

File has to be hosted to be shown in a browser.

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.

You wuold have to loop through them. Concat is probably the way to go :)

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.

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.

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

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.

Not that I know of but maybe. You have to get File Content of the file with an action.

NOt that I know of but I have never tried.

NOt possible. You can show the base64 inside of an Image control but not an HTML control that I know of.

@@ShanesCows any way i can show any image ( i mean base 64 or other ) inside html without using flow?

Yes you can. I show the concept briefly here kzfaq.info/get/bejne/aNiWdLSWltGvaIE.html

The RTF should be html and should just insert? Are you seeing something different?

@@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.

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.

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!

Thanks 🙏

Not with free actions but there are some paid options in flow that can do it.

@@ShanesCows would you please mention names of the paid actions?

I will see but no promises.

Probably not. The html has about a 2mb limit so they would have to be tiny images.

@@ShanesCows any alternative?

It is on my list. 😀 I did it with Flow to test it out and it worked.

Shane Young looking forward to it! 👍👍

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.

@@ShanesCows ok sir, bundles of thanks

By the way you create very good videos that answer many questions so I could imagine how to create my flow...

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.

Depending on how many items you have you could use either CountIf(datasource, formula) or CountRows(filter(datasource, formula))

@@ShanesCows thank you sir!

I think you need to put the image in a Table and then set the TD to align right.

@@ShanesCows I have this exact question/problem. for some reason i can't get the image aligned to the right in a PDF...

Hi Vara I don’t know. 😕 makes sense but I haven’t tried this one.

@@ShanesCows np

Never tried but sounds like fun. If you get it figured out let me know.

I am trying the same...will confirm when it is done

@@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

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.

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

You have to push it through an image control to get the base64 version of it I think

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

I responded to your other comment.

@@ShanesCows where , can I see the answer to that ??