cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
sinabdchaser
Level: Power Up

base 64 converting back to image using flow - to send as email body

 


Hi All

I would appreciate some guidance. 

I have some images saved in a SharePoint List as base 64 coming from PowerApps. 

 

data:image/jpeg;base64,/9j/4AAQSkZJRgABAQEA  etc etc etc

 

My users save photos etc from the app and these are sent to a SharePoint with other text information.  The images are stored as base 64 in a 'multiple lines of text' column.

 

I would like Flow to send an email when information is added to the list, and I want to be able to see the image (photo taken) also in the email.

 

How can I get flow to convert “data:image/jpeg;base64,/9j/4AAQSkZJRgABAQEA  etc etc etc”, back to a .jpg file, and then email as part of the email body.

 

Thanks in advance

Mark

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

Re: base 64 converting back to image using flow - to send as email body

Hi @sinabdchaser,

 

I afraid that there is no any way to acheive your needs in microsoft flow currently.

 

Firstly,there is no any way to get the photo from the "data:image/jpeg;base64,/9j/4AAQSkZJRgABAQEA  etc etc etc".

Secondly, there is no any way to send an image in the email body, you could only send the email as the email attachment.

 

If you would like the features to be added in Microsoft Flow, please submit an idea to Flow Ideas Forum:

https://powerusers.microsoft.com/t5/Flow-Ideas/idb-p/FlowIdeas

 

Best regards,

Alice

 

 

View solution in original post

7 REPLIES 7
Community Support Team
Community Support Team

Re: base 64 converting back to image using flow - to send as email body

Hi @sinabdchaser,

 

I afraid that there is no any way to acheive your needs in microsoft flow currently.

 

Firstly,there is no any way to get the photo from the "data:image/jpeg;base64,/9j/4AAQSkZJRgABAQEA  etc etc etc".

Secondly, there is no any way to send an image in the email body, you could only send the email as the email attachment.

 

If you would like the features to be added in Microsoft Flow, please submit an idea to Flow Ideas Forum:

https://powerusers.microsoft.com/t5/Flow-Ideas/idb-p/FlowIdeas

 

Best regards,

Alice

 

 

View solution in original post

Administrator
Administrator

Re: base 64 converting back to image using flow - to send as email body

Hello, @sinabdchaser!

 

Thank you for posting on the Flow Community Forum! If you have already posted your idea to the Flow Community Ideas Forum then you need to post the URL to your idea’s thread as a reply to this thread and then "Accept as Solution" on that reply so other users may vote for your Flow Idea and identify the information easily.

 

Thank You!

 

-Gabriel
Flow Community Manager

-Gabriel
Microsoft Power Automate Community Manager
Are YOU a member of your local Power Automate User Group?
Fill out This Form to claim your Community User Group Member Badge!
ReflexConsultin
Level: Powered On

Re: base 64 converting back to image using flow - to send as email body

I recently figured out a way through Sharepoint Designer 2013 - try the following for now. My scenario was where a signture was captured through a form and stored as base 64 data in a multiline text field.

Start a Workflow (mine was a 2010, but i dont' think it matter for this).

Have it trigger when New Item is Created

Then create a WF variable and in the string builder: <img alt="Embedded Image" src="[CurrentItem:Photo]"/>

Then create SendEmail step; include this variable "As Sting" into the email. It should render when it gets send out.

Let me know if that worked.

 

 

ReflexConsultin
Level: Powered On

Re: base 64 converting back to image using flow - to send as email body

In addition to my workflow designer solution, i found a way to do it in FLOW as well.

It's displaying a target folder in OneDrive, but you can also replace that with a step that creates a file in Sharepoint.

Hope that helps anybody trying to work with Signature Capture forms like me.

FlowSetupFileConversion.jpg

Super User
Super User

Re: base 64 converting back to image using flow - to send as email body

Did you use MultiLine PlainText or RichText in SP List?

ReflexConsultin
Level: Powered On

Re: base 64 converting back to image using flow - to send as email body

It was 6line multiline PLAINTEXT.

SignatureContractor.jpg

 

pbunyan22
Level: Powered On

Re: base 64 converting back to image using flow - to send as email body

Flow.GIF

Helpful resources

Announcements
thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

firstImage

Incoming: New and improved badges!

We've given our badges an overhaul and also added some brand new ones!

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

sixthImage

Power Platform World Tour

Find out where you can attend!

seventhimage

Webinars & Video Gallery

Watch & learn from the Power Automate Community Video Gallery!

Top Kudoed Authors (Last 30 Days)
Users online (5,000)