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
Community Support
Community Support

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
Community Support
Community Support

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
Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

Power Platform Call June 2022 768x460.png

Power Platform Community Call

Join us for the next call on June 15, 2022 at 8am PDT.

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.

PA.JPG

New Release Planning Portal (Preview)

Check out our new release planning portal, an interactive way to plan and prepare for upcoming features in Power Platform.

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