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?