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?