Save and display saved pictures with excel on onedrive

(0) Share

Report

Posted on by 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?

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Sort by

AJ_Z 3,711 Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!

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-App-executed-in-MS/td-p/864010

Was this reply helpful? Yes No
m_M 3 on at

Like
a
(0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
Verified answer

v-yujincui-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No