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:
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.
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.
I am not sure if there needs to be certain naming convention for the folder/files that I might have missed.
Thanks.
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.
WarrenBelz
146,743
Most Valuable Professional
RandyHayes
76,287
Super User 2024 Season 1
Pstork1
66,079
Most Valuable Professional