Handle Base64 and Binary File Content Types in Power Automate
Did you know that there are two types of file or image content type used in the input and output parameters? In this post, you will learn how to handle the different types of file content in the cloud flow action parameters.
When working with the input and output parameters for file content, you need to provide a value as Binary data type for most of the input parameters (e.g. Upload file or image content) and its counterpart action (e.g. Get file or image content) returns the value in Binary data type. However, some of the actions require the Base64 data type and some outputs return Base64 data type. So how do you identify what you need and when to convert which?
Understanding what type of file content to use in certain parameter is important. Sometimes, conversion of one type to another is required when the type of the output is different from the required input for the next step (e.g. get the Note attachment file and upload to SharePoint).
Identification
To identify the file content type of the input/output parameters, the Connectors Documentation is the best place to start.
🔗 Binary
All of the actions in the SharePoint connectors are consistent. Create file action requires the file content in Binary data type to upload the file and Get file content or Get file content using path returns the Binary data type. In Common Data Service (current environment) connector, Upload file or image content and Get file or image content uses the Binary data type but the rest of the parameters seems to be Base64.
🔗 Base64
To create a Note attachment, Base64 data type value needs to be populated in the Document column and Base64 value is returned when the documentbody column is retrieved from the Note table.
To use images in the Populate a Microsoft Word template action, the file content value needs to be constructed with the Compose action with Base64 value in the following format, unless the value is already a binary value of JPG or PNG.
{ "$content-type": "image/png", "$content": "iVBORw0KG...i/DhQmCC" }
You can read more details on this topic from Olena Grischenko's blog post about Populating Word template with the image field content from Microsoft Dataverse.
Conversion
To convert from Base64 to Binary data type, there is a base64ToBinary function. However, there is no such function for converting the other way round. The trick to converting the other way around is to set the Binary value into the Compose action and use the ['$content'] property of the output. You can also directly use the ['$content'] property of the Binary output too (e.g. outputs('Get_file_or_image_content')?['body/$content'] will return Base64 value). You can find more details about Binary to Base64 conversion in the blog post .
Now let's see the conversions in action.
🔗 Create Note Attachment from SharePoint File
outputs('Get_file_content')?['body']?['$content']
Upload File with Binary Data
base64ToBinary(outputs('Get_a_Note_Attachment')?['body/documentbody'])
Populate Word Template Image
outputs('Get_file_or_image_content')?['body/$content']
🛈 Note
Compose action step is required to construct the input for the image content using the Base64 value and populate the output of the Compose step to the image placeholder. If the content JSON is directly populated, the step will fail with the following error.
Compose action step is required to construct the input for the image content using the Base64 value and populate the output of the Compose step to the image placeholder. If the content JSON is directly populated, the step will fail with the following error.
The image is not of type PNG or JPG. Please provide an image of type PNG or JPG.
Summary
There are two types of file content (Binary and Base64) used in the input and output parameters and it is important to use the correct type based on the required parameter. To convert from Base64 to Binary, base64ToBinary function can be used and ['$content'] property of the Binary output can be used when needing a Base64 value.
Published on:
Learn more
Related posts
Input and Output Parameters for Child Flows in Power Automate
In this post, I will look at the input and output parameter types for child flows. Recently I hit a couple of small issues with the various d...
2 days ago
5 fundamental Power Automate ideas that will make your flows better!
It's time to have a look at some of my older posts. In this post I'm going to have another look at these Power Automate ideas. Back in 2017/20...
3 days ago
Replace the Excel Online connector with the Microsoft Graph API in Power Automate
If you have worked with the Excel Online connector in Power Automate then you will most likely know the pains of this connector. In this post ...
4 days ago
How to Automate Formula Writing in Power Automate Using Copilot
As developers, we use Power Automate to handle everyday tasks and automate small parts of our work. Flows help reduce manual effort, improve a...
5 days ago
Data Retention Strategy in Power Pages – Automated Archival with Scheduled Power Automate Jobs
As Power Pages portals scale, the amount of data they generate grows exponentially—form submissions, bookings, cases, applications, event regi...
6 days ago
From Business Central to SharePoint: The Right Way to Save PDF Files in Power Automate
If you’re pulling PDF files from Microsoft Dynamics 365 Business Central and saving them to SharePoint using Power Automate, there’s one criti...
9 days ago
How to Build Environment-Aware Flows by Fetching CRM Metadata Dynamically in Power Automate
Stop relying on OData workarounds and use a professional API-based pattern instead. When building flows in Power Automate, you often need envi...
10 days ago
Action ‘Update_a_record’ failed: An error has occurred. No resources were found when selecting for update – Fixing Cross-Company Update Issues in Finance & Operations Using Dataverse Virtual Entities (Power Automate)
Recently, while trying to update the Projects table in Finance & Operations using the Fin & Ops Apps actions in Power Automate, we ran...
12 days ago