Save and display saved pictures with excel on onedrive

[m_M]

Hello,

in my project I wanna save pictures taken by the camera app to the excelsheet which is located on my onedrive.

My excel sheet looks like this:

It has a unique PictureID to find the right picture and two collums for the front and back of the object I wanna save.

My problem now is, that if i wanna display the taken picture in powerapps it shows nothing. It reads correctly the the data, but it wont show any image.

How can i display the saved picture on the app?

[AJ_Z]

I have seen a range of solutions to this problem some work some don't seem to for me but i found a range of great stuff through the links in this thread i hope it helps you:

https://powerusers.microsoft.com/t5/Power-Apps-Portals/Show-Base64-image-from-Sharepoint-List-in-an-... 

[m_M]

I have tried some solutions, but could it be that Excel has a max size of Characters per Box?

Because if i convert the picture with an online Base64 converter and copy/paste the code in Powerapps it shows the picture. And if i copy/paste the code in a single excel box and Powerapps reads the box, the picture is only half visible and has a very bad quality.

[v-yujincui-msft · Accepted solution]

Hi@m_M,

Based on the issue that you mentioned, I have made a test but it worked fine on my side.

1.Here is my Excel table.

2.Here is my Gallery.

3.Here is an Image Control.

First(Table1).PictureFront

Last(FirstN(Table1,4)).PictureFront

4.When I changed the structure of my table as below:

5.Refresh the connection and observe the Gallery and Image Control.

It seems that PowerApps is not taking your PictureFront[Images] column as an image column. So maybe you can rename your column or recreate your excel table and refresh your connection in PowerApps.

Best Regards,

Charlie Choi