cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
PierreGiusti
Advocate II
Advocate II

How to show base64 images in PowerApps

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

13 REPLIES 13
v-yamao-msft
Community Support
Community Support

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

Community Support Team _ Mabel Mao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

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

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.


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
Advocate V
Advocate V

 
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
New Member

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.

 

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
Regular Visitor

Has anyone found a proper solution to this? 

eshahroodie
Regular Visitor

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,"""",""))

Helpful resources

Announcements
PA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

secondImage

Are Your Ready?

Test your skills now with the Cloud Skill Challenge.

secondImage

Demo Extravaganza is Back!

We are excited to announce that Demo Extravaganza for 2021 has started!

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

Top Solution Authors
Top Kudoed Authors
Users online (58,870)