I have a responsive Canvas App which is built on dataverse which has a linked document library to sharepoint. I have a 'media' table where I'm storing additional information against the image. Users take the image in the canvas app, fill in the additional information and then the images are uploaded using a flow which creates the record and then attaches the url to the record in dataverse so that I can display it in a gallery in the canvas app.
The picture used in the canvas app gallery is just ThisItem.'Sharepoint Link' which displays the image without issue in browser, however in the mobile app none of the images render. I found this thread where the fix was to use a sharing link, I tried to do this using the 'Organisation' scope but this does not display images in either browser or mobile and I can't allow a sharing link that would give access to anyone due to sensitive images being uploaded. I also tried to use the Filter(StartsWith()) function that I've seen many people use however this is giving me a delegation issue and I will have a huge amount of records so I can't use this either.
Is there another solution for this?