Skip to main content

Notifications

Community site session details

Community site session details

Session Id : OTFDmaO+5rcEfm96k/Rrke
Power Apps - Building Power Apps
Answered

Image Column in Excel not Recognized by PowerApps Connector

Like (0) ShareShare
ReportReport
Posted on 29 Nov 2023 16:03:13 by 3

Hi, 

 

Not sure this is new but after viewing many related posts, I haven't seen similar behavior. I am trying to load images stored in OneDrive with their relative paths saved in an Excel file to be used in PowerApps. I have a root folder '\App', where I have the 'files.xlsx' and 'files_images' folder. Here are the screenshots showing the contents: 

 

mxgharryliu_0-1701273243690.png

mxgharryliu_1-1701273273427.png

However, when I load the data source, the image column is not properly recongized: 

1. Create a blank PowerApp Canvas. 

2. Click Data icon on the right and select 'Add data'. Select 'Excel Online (Business)' under 'Connectors'. 

3. On the right popup drawer, select the 'OneDrive for Business' > 'OneDrive' > 'App' > 'files.xlsx'. Select 'ImageList'. Click 'Connect'. Click 'Use unique column from Excel table'. Select 'ID'. Click 'Connect'. 

4. Add a 'Vertical gallery' from 'Insert' panel. Set the 'Items' property to 'ImageList'. 

5. Click the 'Image1' under the Gallery1 in the tree. Change the 'Image' property. 

mxgharryliu_2-1701273470547.png

Now, you can see that the image column is not recognized as images, i.e. there is no ThisItem.Path option but instead ThisItem.'Path [image]' option. 

mxgharryliu_3-1701273628053.png

I am not sure if there needs to be certain naming convention for the folder/files that I might have missed. 

 

Thanks. 

Categories:
  • Verified answer
    timl Profile Picture
    34,955 Super User 2025 Season 1 on 29 Nov 2023 at 16:52:13
    Re: Image Column in Excel not Recognized by PowerApps Connector

    @mxgharryliu 

    For step 2 (where you selected the Excel Online Business connector), if you were to select the 'OneDrive for Business' connector instead, that should give you access to the images.

     

    timl_0-1701276648535.png

     

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

Understanding Microsoft Agents - Introductory Session

Confused about how agents work across the Microsoft ecosystem? Register today!

Markus Franz – Community Spotlight

We are honored to recognize Markus Franz as our April 2025 Community…

Kudos to the March Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 146,670 Most Valuable Professional

#2
RandyHayes Profile Picture

RandyHayes 76,287 Super User 2024 Season 1

#3
Pstork1 Profile Picture

Pstork1 66,004 Most Valuable Professional

Leaderboard
Loading started