Hi everyone,
I have developed a Power Apps application that utilizes Dataverse tables as its data source. These tables include a column for storing attachment files, which are displayed in the app. Users should be able to download these files. To implement the download functionality, I followed the approach outlined in this article: https://www.matthewdevaney.com/power-apps-download-file-from-dataverse-file-column/
Issue Encountered:
My colleagues and I, who have the 'System Administrator' security role within the environment, can download the attachments without any issues. However, during the User Acceptance Testing (UAT) phase, I shared the app with some test users who have the 'Basic User' and 'App User' security roles, and they are unable to download the attachments.
When these test users attempt to download a file by clicking on the URL, a new browser tab opens displaying an HTTP 404 error message, which I believe indicates an authorization issue.
I am attaching screenshots of the application and the error that appears when a user clicks on the download URL.
Steps Taken So Far:
- I duplicated the 'Basic User' and 'App User' security roles, added full access permissions (write, read, and edit) for the custom Dataverse entities, and assigned these updated roles to the test users.
- I included the 'Notes' (Annotations) entity in the security role, as I've read that attachments in Dataverse are stored within this entity.
- I set the [environmentvariabledefinitions] to 'Read Only' within the security role, as this is necessary for constructing the download URL within the app.
Are there any other entities or miscellaneous privileges that I should add to the modified security roles to enable access to the Dataverse attachments for these users?
Thank you for your assistance.
