Encode base64

[Anonymous]

Hello i have an application where i upload multiple images with powerapps and power automate to a server. The server requires base64 plane text ( just the base64 value ) how can this be done in power apps and power automate ? The images has also nametag, timestamp and are stored in a collection before shipped of to power automate for then to be posted to server. 

[v-siky-msft]

Hi @Anonymous ,

First, move the collect formula to OnChange property of DMG_SCHEME_BTN, rather than OnSelect property, and modify it as follows.

Collect(imgCol;({Name:"Skademelding.jpeg"; Image:DMG_SCHEME_IMG.Image; timeStamp: Now()}))

This is because  DMG_SCHEME_BTN.Media store the temporary blob URL of the image, but the DMG_SCHEME_IMG.Image store the binary file of image.

Then set the OnSelect of Send button:

ClearCollect(colBase64;DropColumns(AddColumns(colImg;"Base64";Mid(JSON(Image;JSONFormat.IncludeBinaryData);25;Len(JSON(Image;JSONFormat.IncludeBinaryData))-25));"Image"));;
Set(JsonCol;JSON(colBase64;JSONFormat.IncludeBinaryData));; IMG_API.Run(SONR;reg;Jobbtype;FORSIKRING;JsonCol)

 The Text of Label: 

Last(colBase64).Base64

Here are my test result:

Sik

[Anonymous]

When changing to onchange trigger i get the same error when using .image. Shall i put the aciton on the image itself or the btn ?

[v-siky-msft]

Hi @Anonymous ,

Ensure it is DMG_SCHEME_IMG.Image.  (ImageControlName.Image)

The code must be put on the OnChange event of DMG_SCHEME_BTN

Sik

[Anonymous]

Yes found it out, but format its wrong 😞 so not sure if its throwing just the base64 value

[Anonymous]

Found the issue it was missing a / at start. how can i include it ?

[v-siky-msft · Accepted solution]

Hi @Anonymous ,

Please check the Mid formula which is used for extracting the base64 string. change 25 to 24 to see if it works?

Mid(JSON(Image;JSONFormat.IncludeBinaryData);24;Len(JSON(Image;JSONFormat.IncludeBinaryData))-24)

 Sik

[Anonymous]

could i ask, is it possible to save the image url also? and convert it to jpg even tho its a png ?

[HEATFreight]

Is there a way to do this for a text string, like the time in zulu format: 2021-10-25T17:09:00Z because the Power Apps SharePoint connector converts text recognized as a time format into a different format: 10/24/2021 18:09:00, which will be interpreted by my API as a local time! If I could just encode base64 and decode later within Power Automate, I could guarantee no funny business with my perfectly formatted zulu time string. Without the Z at the end, the API I am connecting to will regard it as a local time. The SharePoint connector in PowerApps converts to an invalid format as far as I can tell, for my use case anyway. It won't just let a time string be a string.