cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
New Member

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
Highlighted
Community Support
Community Support

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

8 REPLIES 8
Highlighted
Community Support
Community Support

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

Highlighted
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!
Highlighted
Frequent Visitor

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.

 

 

Highlighted
Frequent Visitor

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

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

Highlighted
Frequent Visitor

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

It was 6line multiline PLAINTEXT.

SignatureContractor.jpg

 

Highlighted
Frequent Visitor

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

Flow.GIF

Highlighted
Post Patron
Post Patron

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

Hi @ReflexConsultin ,

I am trying to follow this using an image from a camera control in a Powerapp.  I can create the html, but when it goes to create the jpg it errors on the file is not valid.  Do you know why it would be invalid?

 

Is there a difference between a signature and camera image?  

 

Thanks,

Joe

Helpful resources

Announcements
firstImage

Super User Program Update

Three Super User rank tiers have been launched!

firstImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

firstImage

Join the new Power Virtual Agents Community!

We are excited to announce the launch of Power Virtual Agents Community. Check it out now!

firstImage

New & Improved Power Automate Community Cookbook

We've updated and improved the layout and uploading format of the Power Automate Cookbook!

thirdimage

Power Automate Community User Group Member Badge

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

Top Solution Authors
Top Kudoed Authors
Users online (5,919)