I built an app that uses the camera control and OneDrive Excel shared spreadsheet to access and store images.
The spreadsheet (let's call it AppImages.xlsx) has the required "Image[image]" column that contains the path to the image.
The path typically looks something like this;
.\AppImages_images\f2bf3ec4692a732ea6038d9a8c1a91d4.jpg
My understanding is that the relative path is in relation to the spreadsheet - meaning, wherever the spreadsheet was found, then the path would be relative to that - for everyone accessing the spreadsheet.
I could take images and recall them with no problem. Initial testing seemed fine, but then people started complaining of not seeing images. I did some more tests and then noticed I now had a .\AppImages_images\ folder in the ROOT of my OneDrive - to be clear, I had one relative to the spreadsheet, but somewhere along the line it created a new one in the root of my OneDrive folder and subsequent images were being loaded in there.
I checked other people's OneDrive and they too had a .\AppImages_images\ folder in the root of their OneDrive, and the pictures they had been taking were being saved there. Now I'm stumped.
The intent was to store all the images in the same place - this is really unexpected behaviour. Did I miss something? is this the way it's supposed to work? The result is that I can't see anyone elses pics and with the new sheet I created it seems they just can't access it at all. It will be easy enough to create a new one again, but if this is the way it works, it's useless for my application....I need everyone's images to be in the same place.
[EDIT]
I created a new app using the Template App "Site Inspection" and simply shared it vanilla with no changes.
I also shared the folder it created on my OneDrive under PowerApps\Templates and gave a user Edit access to the top level folder and everything under it.
I can add photo's from the app, no problem.
The user can access the folder via OneDrive and add/edit everything in it.
When the user runs the app from Dynamics however, red-bar errors pop up saying "Error loading Site Inspector" and "Failed to load SitePhotos" and "Unknown error occurred."
Running from PowerApps the error is "Failed to load SitePhotos. The specified record was not found. Server response: Failed to read metadata from the file source. Response from the end service is : The resource could not be found."
[Session ID: 0b03a7d6-4bfe-8839-da7e-b1422c47b86d]
I've tried creating a brand new spreadsheet from scratch with a basic camera control - I get exactly the same - works for me, but other users get the error. Even for completely newly created apps. It looks like PowerApps cannot access the source, even though the user can....so now I've got to resolve that issue before I can try and unravel the relative path issue I started with....unless they're caused by the same thing?
I don't think it's relevant because my pics saved correctly, but I did notice the paths of the bundled template app images are all ./path/file and my new images are saved by powerapps as .\path\file in the spreadsheet [image] column....however it saves it in the right place relative to the spreadsheet so doesn't seem to be a problem.
R
