web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Problem Adding Images ...
Power Apps
Unanswered

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

(0) ShareShare
ReportReport
Posted on by 41

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

 

 

Categories:
I have the same question (0)
  • Verified answer
    RandyHayes Profile Picture
    76,297 Super User 2024 Season 1 on at

    @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 Profile Picture
    41 on at

    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

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 796 Most Valuable Professional

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 327 Super User 2025 Season 2

#3
Power Platform 1919 Profile Picture

Power Platform 1919 268

Last 30 days Overall leaderboard