cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
thb65
Helper I
Helper I

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

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

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
RandyHayes
Super User
Super User

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

 

_____________________________________________________________________________________
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.
Check out my PowerApps Videos too! And, follow me on Twitter @RandyHayes

Really want to show your appreciation? Buy Me A Cup Of Coffee!

View solution in original post

2 REPLIES 2
RandyHayes
Super User
Super User

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

 

_____________________________________________________________________________________
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.
Check out my PowerApps Videos too! And, follow me on Twitter @RandyHayes

Really want to show your appreciation? Buy Me A Cup Of Coffee!

View solution in original post

thb65
Helper I
Helper I

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

Helpful resources

Announcements
User Group Leader Meeting January 768x460.png

Calling all User Group Leaders!

Don't miss the User Group Leader meetings on January, 24th & 25th, 2022.

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Top Solution Authors
Top Kudoed Authors
Users online (2,614)