How to Convert a SharePoint Image to Base64 in Power Automate

Do you need to convert an image to a base64 string in your flow?

When getting images from SharePoint into your flow, they will be in a binary format. However, you might need them in a base64 format.

For example, when adding images into the body of an email with HTML or adding images within a PDF you will need the base 64 representation.

This post will show you how to get an image from SharePoint and then convert it to a base64 string.

Understanding Base64 and Image Conversion

Base64 is an encoding scheme that allows you to represent binary data in an ASCII string format.

It is commonly used for various purposes, such as embedding images in email, data transfer, and as a part of data URIs in web applications.

When working with Power Automate, you might come across situations where you need to convert an image file in binary to a Base64 encoded string.

This can be useful for scenarios like getting images from SharePoint and then sending them in email bodies or storing them in other applications.

Get Image Content from SharePoint

To convert a SharePoint image to base64, you first need to get the image content from SharePoint.

Here is how to use the Get file content with path action to get an image from SharePoint.

  1. Add the Get file content using path action from the SharePoint connector to your flow.
  2. Select the Site Address for the SharePoint site where your image is stored.
  3. Select the image file in the File Path input using the file picker menu.

This will get the image content into your flow from SharePoint.

@{body('Get_file_content_using_path')}

The above File Content dynamic content will then be available to get the file content.

@{body('Get_file_content_using_path')['$content']}

To get only the content, you will need to modify this expression a bit by adding on the $content key as seen above.

This is the part you will need to convert to a base64 string.

Convert Image Content to Base64 String with the base64 Function

base64(<content>)

To convert your image content to a Base64 string, you can use the base64 function.

Once you have retrieved the file content, you can use an expression to convert the image content to a Base64 string.

@{base64(body('Get_file_content_using_path')['$content'])}

Replace <content> with the output of the Get file content using path action, which can be accessed using the above expression.

Conclusions

This article has shown the process of converting an image to base64. The base64 function allows you to easily encode your binary image files to base 64 when needed.

The Get file content with path action will obtain the content of an image from SharePoint. This content will be in a binary format and you can apply the base64 function to convert the binary data to a base64-encoded string.

This enables integration with other applications or services that require base64-encoded images.

Have you needed to convert an image to base64? How did you do this? Let me know in the comments!

About the Author

John MacDougall

John MacDougall

John is a Microsoft MVP and freelance consultant and trainer specializing in Excel, Power BI, Power Automate, Power Apps and SharePoint. You can find other interesting articles from John on his blog or YouTube channel.

Related Articles

Comments

0 Comments

Submit a Comment

Your email address will not be published. Required fields are marked *

Get the Latest Tech Tips

Write For Us

Are you a tech enthusiast with a talent for writing great content? Come write for us!

Follow Us

Follow us on social media to stay up to date with the latest in tech!