Solved: Re: Picture from Excel (One Drive)

Anonymous · ‎07-26-2019

Hello everyone.

I am developing an app on PowerApp using an excel database that is shared on One Drive.

There is a column (Pictures) in excel spreadsheet (database) that I put the image link, but when I run the App in PowerApp does not appear the image (only shows the link).

Thank you.

v-xida-msft · ‎07-29-2019

Hi @Anonymous ,

Based on the issue that you mentioned, I have made a test on my side, and don't have the issue that you mentioned.

The data structure of my Excel table as below:

Based above Excel table, I generated an app, the Excel table records displayed well within the Gallery as below:

Please consider re-configure your Excel table based on the the following article:
https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/tutorial-working-with-images-in-excel

then re-generate a new app based on the new Excel table, check if the issue is solved.

Please consider add a Label control within your Gallery, set the Text property to following:

ThisItem.Image

then check if the Label could display proper Image Url link.

In addition, please also make sure the Image URL link you typed within the Image[Image] column in your Excel table is a URL link without any authentication requirement.

Best regards,

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

View solution in original post

RandyHayes · ‎07-26-2019

@Anonymous

What is the Image property of your picture control set to?

_____________________________________________________________________________________
Digging it? - Click on the Thumbs Up below. Solved your problem? - Click on Accept as Solution below. Others seeking the same answers will be happy you did.
NOTE: My normal response times will be Mon to Fri from 1 PM to 10 PM UTC (and lots of other times too!)
Check out my PowerApps Videos too! And, follow me on Twitter @RandyHayes
Really want to show your appreciation? Buy Me A Cup Of Coffee!

Anonymous · ‎07-26-2019

If I understood your question. I'm just adding the image (web) link in the Excel cell.

RandyHayes · ‎07-26-2019

@Anonymous

So, you need to look at the Image property of the picture control in your Gallery and see what the property is set to.

It should be set to ThisItem.Image[Image] based on what I see for your excel file.

So, in your Gallery, click on the picture control and then look at the properties for that and see what the Image property is set to.

_____________________________________________________________________________________
Digging it? - Click on the Thumbs Up below. Solved your problem? - Click on Accept as Solution below. Others seeking the same answers will be happy you did.
NOTE: My normal response times will be Mon to Fri from 1 PM to 10 PM UTC (and lots of other times too!)
Check out my PowerApps Videos too! And, follow me on Twitter @RandyHayes
Really want to show your appreciation? Buy Me A Cup Of Coffee!

Anonymous · ‎07-26-2019

@Rand

RandyHayes · ‎07-26-2019

@Anonymous

Yes, so, I am guessing, your intention is to have the Image displayed that is referenced by the URL from your excel file.

If that is the case, then you will need to change that property to ThisItem.Image[Image] - again, the Image[Image] is what appears to be your column name for that value. If not, then adjust accordingly.

_____________________________________________________________________________________
Digging it? - Click on the Thumbs Up below. Solved your problem? - Click on Accept as Solution below. Others seeking the same answers will be happy you did.
NOTE: My normal response times will be Mon to Fri from 1 PM to 10 PM UTC (and lots of other times too!)
Check out my PowerApps Videos too! And, follow me on Twitter @RandyHayes
Really want to show your appreciation? Buy Me A Cup Of Coffee!

Anonymous · ‎07-26-2019

@RandyHayes

...and this case?

RandyHayes · ‎07-26-2019

@Anonymous

It would really be the same column name you want there.

This is all assuming that PowerApps sees your column name as "Image[Image]" as it appears in your excel file. If it has another name for it, then you will want to use that.

_____________________________________________________________________________________
Digging it? - Click on the Thumbs Up below. Solved your problem? - Click on Accept as Solution below. Others seeking the same answers will be happy you did.
NOTE: My normal response times will be Mon to Fri from 1 PM to 10 PM UTC (and lots of other times too!)
Check out my PowerApps Videos too! And, follow me on Twitter @RandyHayes
Really want to show your appreciation? Buy Me A Cup Of Coffee!

Anonymous · ‎07-26-2019

Can there be a delay for PowerApp to read the image?

Because I put Image (ThisItem.Image).

In this case, the column in Excel is "Image [Image]" have a problem?

RandyHayes · ‎07-26-2019

@Anonymous

Not really. But, you are only assigning a URL to the Image (through the information in your excel file), so it is at the mercy of all the hops that it has to go through to get the bits from the source server.

_____________________________________________________________________________________
Digging it? - Click on the Thumbs Up below. Solved your problem? - Click on Accept as Solution below. Others seeking the same answers will be happy you did.
NOTE: My normal response times will be Mon to Fri from 1 PM to 10 PM UTC (and lots of other times too!)
Check out my PowerApps Videos too! And, follow me on Twitter @RandyHayes
Really want to show your appreciation? Buy Me A Cup Of Coffee!

Picture from Excel (One Drive)

Helpful resources

Power Apps News & Announcements

Introducing the Community Calls Conversations

Power Apps Community Blog