Trying to download file stored in dataverse

(0) Share

Report

Posted on by Muzammil_0695

Hi ALL

I have scenario where in on click on button in gallery it has to download a file stored in dataverse

However the issue is I'm able to download others are getting http401 unauthorized issue through I have added them in my environment and have given access to the table it's not working and it's working for few

I'm using

Download (https//:org79e2e2a5.crm.dynamics.com/api/tablename(tableuniqueid/columnname/$value))

No issue with link only that few are able to access few or not

Errorhttp401

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (13)

Answers (0)

Guido Preite 1,488 Super User 2024 Season 1 on at

Like (0)

Report

users can download a file stored inside Dataverse only if they have a security role with access to that column. If you get 401 it means not authenticated

Was this reply helpful? Yes No
Muzammil_0695 25 on at

Like (0)

Report

I have given organisational access to the role for custom tables which I need them to access all are green are there any other customization entities I should give?

Was this reply helpful? Yes No
Drew Poggemann 9,287 Most Valuable Professional on at

Like (0)

Report
Hi @Muzammil_0695 ,

Please check role assignments in the environment for the users. Based on the error it appears they do not have appropriate access to the table in Dataverse.

Try the following:

Verify all users have the right roles for access to the table setup in Dataverse

Check permissions levels on the record on the table, see if setup for "User" level on Read and if so, if the owner is not set to the user trying to access then this could be the problem. Might want to set to organization level on the Read security and verify works for all

Honestly if not #1 or #2, I would do the following:

Have user pull up record from Data in Dataverse to see if they can view the record with the file field and download the file from a standard form in Dataverse

Edit the Record in Dataverse form and utilize the Check Access for the user to see permissions.

Was this reply helpful? Yes No
Guido Preite 1,488 Super User 2024 Season 1 on at

Like (0)

Report

also make sure your users are authenticated to dataverse first, if they open the instance first after they will be able to download the file

Was this reply helpful? Yes No
Muzammil_0695 25 on at

Like (0)

Report

How do i try and authenticate user? As I'm building canvas app using data verse as a backend

Was this reply helpful? Yes No
Ismael_Novo 308 on at

Like (0)

Report

Why you don't use Power Automate for this kind of operations?

https://www.youtube.com/watch?v=D2_WCvelCHo

Was this reply helpful? Yes No
pmesiha 56 on at

Like (0)

Report

check this solution: https://www.linkedin.com/pulse/download-dataverse-attachments-from-canvas-power-app-mesiha-p-eng/?trackingId=JDbShfb9Q2ScUjoH4DOzhg%3D%3D

Was this reply helpful? Yes No
Ram Prakash Duraisamy 5,593 Super User 2025 Season 2 on at

Like (0)

Report

Hi @Muzammil_0695

Hope my blog can help you

https://microsoftcrmtechie.blogspot.com/2022/07/download-images-from-dataverse-image.html?m=1

Was this reply helpful? Yes No
gidiscacciati 69 on at

Like (0)

Report

Hello, did anyone get a solution for these? I am getting the same results. I have an app and can use the Download() function from Power Apps. Although, I have noticed that if I use an anonymous window or log in using a different browser, I get the 401 error as well.
I have also noticed that if I go to the table and edit the record using the form view, it asks me to authenticate again, and then I am able to download the file from the form and inside the app.
Does anyone know if there is a way to embedd this second layer of authentication when the user acesses the app? Is there a connection that needs to be done or something else? I have tried adding AzureAD connection to the app, but the results were the same.

Any idea is appreciated.

Thanks

Was this reply helpful? Yes No
Prakash4691 1,332 on at

Like (1)

Report

@Muzammil_0695,

If you are trying to download file from file attribute in an entity make sure to give necessary privilege in activity file attachment table. If you are trying to download from activities section kindly give permission to notes entity.

If it is from file attribute check whether field security profile is enabled for those field.

I think canvas/model driven can't be accessed as anonymous user only the power apps portal or power pages can be accessed as anonymous user.

Regards,

Prakash

Was this reply helpful? Yes No