Problem Adding Images in Excel Table from One Drive for Business to PowerApp

[thb65]

Hi,

I am new to Power Apps and i followed some MSFT fundamental instructions to build my first Power App.

The Flooring Estimates App worked well

https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/get-started-create-from-data

As a next step I wanted to build a simple "Facebook" app based on an Excel defined Table with names, and .jpg images stored in my One Drive for Business folder

I followed the instruction as per below under section :  "Add images from the cloud to your app" 

https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/add-images-pictures-audio-video

I followed the instructions and created an Excel table and created a Power App

* created a canvas App

* connection made with OneDrive for Business , Selected excel file and table "Jackets" 

* added Gallery Horizontal

* Gallery control - data items: Jackets

* Image property : ThisItem.Images

* Title 1 and Subtitle 2 are filled with the data from the Excel file so this seems to work.

Problem: Image1 is not visible in the app and also not the other 4 Images.

Also when I tried to create an automated "start from data" Excel online iPhone application the same issue appears: no visible images

1. Excel Table is defined and named "Jackets"

2. I named the column containing the path definition of the pictures : Images [images]

3. The path used in that column is: .\PowerApps\Assets_images\Jacket_5_Lilac.jpeg 

The instruction says: 

3. In an Excel spreadsheet, create a one-column table, and fill it with the following data.

Images

https://contoso.sharepoint.com/personal/contoso_com/Assets_images/Jacket_10_LightBrown.jpeg

https://contoso.sharepoint.com/personal/contoso_com/Assets_images/Jacket_5_Lilac.jpeg

https://contoso.sharepoint.com/personal/contoso_com/Assets_images/Jacket_7_DARKBLUE.jpeg

https://contoso.sharepoint.com/personal/contoso_com/Assets_images/Jacket_7_DarkGreen.jpeg

https://contoso.sharepoint.com/personal/contoso_com/Assets_images/Jacket_8_PaleMariGold.jpeg

To copy the file path from OneDrive for Business, select a file, and then select Path (Copy direct link) from the details pane on the right side of the screen.

So what Path should I take ?

1. if in Explorer Right Click Mouse on filename and select properties / Security Object name: 

"C:\Users\myname\OneDrive - Companyname\PowerApps\Assets_images\Jacket_5_Lilac.jpeg"

So i used:

Images [image]

C:\Users\myname\OneDrive - Companyname\PowerApps\Assets_images\Jacket_10_LightBrown.jpeg

C:\Users\myname\OneDrive - Companyname\PowerApps\Assets_images\Jacket_5_Lilac.jpeg

C:\Users\myname\OneDrive - Companyname\PowerApps\Assets_images\Jacket_7_DARKBLUE.jpeg

C:\Users\myname\OneDrive - Companyname\PowerApps\Assets_images\Jacket_7_DarkGreen.jpeg

C:\Users\myname\OneDrive - Companyname\PowerApps\Assets_images\Jacket_8_PaleMariGold.jpeg

Unfortunately it did not work. 

Then i changed path in : .\PowerApps\Assets_images\Jacket_5_Lilac.jpeg

Images [image]

.\PowerApps\Assets_images\Jacket_10_LightBrown.jpeg

.\PowerApps\Assets_images\Jacket_5_Lilac.jpeg

.\PowerApps\Assets_images\Jacket_7_DARKBLUE.jpeg

.\PowerApps\Assets_images\Jacket_7_DarkGreen.jpeg

.\PowerApps\Assets_images\Jacket_8_PaleMariGold.jpeg

UNFORTUNATELY - it did not work

So what is the proper setting or Path ? and do I need to do something with file sharing permissions ?

Looking forward to your solution !

Many Thanks.

thb65

[RandyHayes · Accepted solution]

@thb65 

Your links should be relative to the Excel file.  They cannot be on a local drive, they need to be on OneDrive and, again, need to be relative to the Excel datasource.

Have a look at this post where I also described this to the poster.

I hope this is helpful for you.

[thb65]

Randy,

Thanks for the answer - it pointed me to  the right solution. 

I checked and I was using the relative path as can been seen in the table above using: 

 .\PowerApps\Assets_images\Jacket_10_LightBrown.jpeg

.\PowerApps\Assets_images\Jacket_5_Lilac.jpeg

.\PowerApps\Assets_images\Jacket_7_DARKBLUE.jpeg

.\PowerApps\Assets_images\Jacket_7_DarkGreen.jpeg

.\PowerApps\Assets_images\Jacket_8_PaleMariGold.jpeg

BUT i noted your comment in the other post on the folder path and saw that my relative folder was incorrect.

The Excel Assets.xlsx Table was stored in .\PowerApps already so I had to change the relative links by taking out \PowerApps into:

.\Assets_images\Jacket_10_LightBrown.jpeg

.\Assets_images\Jacket_5_Lilac.jpeg

.\Assets_images\Jacket_7_DARKBLUE.jpeg

.\Assets_images\Jacket_7_DarkGreen.jpeg

.\Assets_images\Jacket_8_PaleMariGold.jpeg

And it works now !

Thanks.

thb65