Dataverse Image URL

[ChrisHarper]

Is it possible to get the URL of a dataverse image into Power Apps?  Either the thumbnail or full image

I need to be able to add the URL to a collection and pass to an API

[JamesYumnam · Accepted solution]

Hi @ChrisHarper 

Yes, basically we need to construct this URL: https://orgc34d9a55.crm8.dynamics.com/Image/download.aspx?Entity=cr71c_myimageentity&Attribute=cr71c...

Please try this way and let me know if this helps you:

• Create a table 
  
• Add an image column as below:
  

  Add a new image record:
  
  

  In the URL, there is the organisation URL, then Entity = table name, Attribute = image column name, id = the value in the MyImageEntity. So other values are static but ID is the dynamic one. To fetch the ID I have done this.
• In power apps app, I have a label whose Text property is set as below:

Concatenate("https://orgc34d9a55.crm8.dynamics.com/Image/download.aspx?Entity=cr71c_myimageentity&Attribute=cr71c_entityimage&Id=",Gallery1.Selected.MyImageEntity)​

This will give the below:

Hope this helps.

[ChrisPiasecki · Accepted solution]

Hi @ChrisHarper,

The above will only retrieve the primary image as a thumbnail. The URL to download a specific column image would use the following patterns:

Thumbnail: https://<orgUrl>/api/data/v9.1/<entity-type(id)>/<image-attribute-name>/$value 

Full-size image: https://<orgUrl>/api/data/v9.1/<entity-type(id)>/<image-attribute-name>/$value?size=full

Note that if the full image size is greater than 16 MB, you will need to download the file in 4 MB chunks.

More information at the reference below.

Image columns (Microsoft Dataverse) - Power Apps | Microsoft Docs

---
Please click Accept as Solution if my post answered your question. This will help others find solutions to similar questions. If you like my post and/or find it helpful, please consider giving it a Thumbs Up.

[ChrisHarper]

@JamesYumnam  & @ChrisPiasecki 

Many thanks for your prompt responses - got it working

[Muzammil_0695]

Hi Chris

Is it going to work if I'm trying to download a file data type instead of image 

I have stored XLS file in a column in data verse table I want to download that on the click of the button is there a solution can some one help?

[dnkt]

Hey @ChrisPiasecki - I am still having trouble with this but your solution has gotten me farther than most! I'm getting stuck on the <entity-type(id)> and <image-attribute-name> and was wondering if you could elaborate on this a little more or provide an example? Thanks!

[ChrisHarper]

Hi dnkt,

I used the following URL format to retrieve the image:

https://<orgUrl>/api/data/v9.1/entity=<table>&attribute=<column>&id=<GUID> 

Please click Accept as Solution if my post answered your question. This will help others find solutions to similar questions. If you like my post and/or find it helpful, please consider giving it a Thumbs Up.

[BrucePain]

@ChrisPiasecki @JamesYumnam Hi, I am using PowerApps to upload attachments/file to Dataverse table, I would want the users to have the ability to launch or open the attachment/file in the browser. How can this be achieved? 

[CamFi]

Hi @BrucePain,

im trying to do something similar. did you manage to find a solution for this? 

thank you. 

[brink23]

Hi all,

I was able to create the Url for retrieving the full image.

After putting similar Url's in a PDF file for use by other users, the Url's are working fine for myself, however other users within the company seem to be lacking user rights.

The user are able to use the applicable user expenses App, but not the created links

Regards Henk van den Brink