cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
m_M
Frequent Visitor

Save and display saved pictures with excel on onedrive

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:

m_M_0-1638656731382.png

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.

m_M_1-1638656841262.png

How can i display the saved picture on the app?

1 ACCEPTED SOLUTION

Accepted Solutions
v-yujincui-msft
Microsoft
Microsoft

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.

vyujincuimsft_0-1639027423336.png

2.Here is my Gallery.

vyujincuimsft_1-1639027423353.png

3.Here is an Image Control.

First(Table1).PictureFront

Last(FirstN(Table1,4)).PictureFront

vyujincuimsft_2-1639027423356.png

vyujincuimsft_3-1639027423358.png

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

vyujincuimsft_4-1639027423361.png

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

vyujincuimsft_5-1639027423366.png

vyujincuimsft_6-1639027423367.png

vyujincuimsft_7-1639027423368.png

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

View solution in original post

3 REPLIES 3
AJ_Z
Super User
Super User

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-... 

If you appreciated my comments/responses please be sure to Like/Kudo them it really does make me smile 🙂 !

m_M
Frequent Visitor

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
Microsoft
Microsoft

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.

vyujincuimsft_0-1639027423336.png

2.Here is my Gallery.

vyujincuimsft_1-1639027423353.png

3.Here is an Image Control.

First(Table1).PictureFront

Last(FirstN(Table1,4)).PictureFront

vyujincuimsft_2-1639027423356.png

vyujincuimsft_3-1639027423358.png

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

vyujincuimsft_4-1639027423361.png

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

vyujincuimsft_5-1639027423366.png

vyujincuimsft_6-1639027423367.png

vyujincuimsft_7-1639027423368.png

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

Helpful resources

Announcements
PA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

This training provides practical hands-on experience in creating Power Apps solutions in a full-day of instructor-led App creation workshop.

Microsoft Build 768x460.png

Microsoft Build is May 24-26. Have you registered yet?

Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.

May UG Leader Call Carousel 768x460.png

What difference can a User Group make for you?

At the monthly call, connect with other leaders and find out how community makes your experience even better.

Top Solution Authors
Top Kudoed Authors
Users online (3,611)