Trying to download file stored in dataverse

[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

[GuidoPreite]

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

[Muzammil_0695]

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? 

[dpoggemann]

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:

1. Verify all users have the right roles for access to the table setup in Dataverse
2. 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
3. Honestly if not #1 or #2, I would do the following:
   1. 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
   2. Edit the Record in Dataverse form and utilize the Check Access for the user to see permissions.

[GuidoPreite]

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

[Muzammil_0695]

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

[Ismael_Novo]

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

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