How to show base64 images in PowerApps

[PierreGiusti]

Hi, following orientations described in PowerApps forum “Re: Solved: How to save captured images in SharePoint” I successfully added base64 format in Sharepoint by taking a photo using a cellphone.

However, I could not show in a PA gallery base64 that images previously saved in Sharepoint.

How can I do that?

Thanks.

Pierre

[v-yamao-msft]

Hi PierreGiusti,

In the original thread Solved: How to save captured images in SharePoint, @Meneghino suggested that you can turn all of the images into real jpg files by converting the base64 text to bytes with any online converter, just make sure you take only the text after the initial "data:image/jpeg;base64,". Have you tried this?

Best regards,
Mabel Mao

[PierreGiusti]

Hi Mabel Mao, yes, I tried this in this website http://base64image.org/, it works, but in PowerApps do not show the photo as I said before. To try to present the photo I utilized the media image component and seting the option "Image" referenced to the multiline field where the base64 text is stored in Sharepoint.

I need an easy way to add photos toked from PowerApps app in Sharepoint list and show this photo later on the app for any user who need it; I really don’t care if it is base64 or the image itself.

PowerApps can do this?

I am using Sharepoint because looks like more robust solution than use a excel file in OneDrive, because in the app that I developed it's possible to add and read photos files simultaneously by different users.

You may consider that I’m a consultant with some IT technician knowledge, I don’t know programming languages at all. I´m taking your time because couldn’t find a viable solution to use camera and images in my app.

Thanks in advance.

Pierre

[Mike8]

Hello PierreGiusti,

Try to have the Text() function around your Base64 string.
Also check this: https://powerusers.microsoft.com/t5/General-Discussion/Media-in-Base64/m-p/94576#M35323
It is a question, but it mayhelp you.

[NoumanQ]

I am facing the exact same issue. I can save image into Sharepoint as base64 and check the text by converting it back to image elsewhere. However, powerapps gallery does not seem to show images form base64 strings. Is there any solution to this?

[Office365Master]

SharePoint Images Powered Up In PowerApps

Display any image stored anywhere in SharePoint Online, rendered within an app in any resolution / quality as you so desire and highly compressed in size vs. the original image actually stored in SharePoint.

[AnupalBora]

You can use Concatenate("data:image/jpg;base64,",logo) or Concatenate("data:image/jpeg;base64,",logo) in the Image formula. Logo contains your base64 String. (This seems to work only in Edit Mode and play)

In my solution i am retrieving base64 string from REST API connecting to SQL SERVER column of datatype Varbinary(max) .

However I must say that I found a bug when running the application after publish, it does not shows the Image. I modified the code as below:

"data:image;application/octet-stream;base64,"&logo

see my screenshot.

[Darvin]

Paul O'Flaherty has done some great videos on the subject:

    https://www.youtube.com/watch?v=qX3i8456YwU

    https://www.youtube.com/watch?v=QnDD7jleHME

I've followed his lead on this, and have great success with PowerApps handling Base64 images from a SQL back end.

Hope this helps!

[CC1282]

Has anyone found a proper solution to this? 

[Anonymous]

Hi Guys,

I have had the same problem and after two days of struggling, it was apparently about the double quotations. define a var and substitute the """" with ""! Try putting this formula in your Gallery.onselect:

Set(img,Substitute(ThisItem.YOUR_COLUMN_NAME,"""",""))