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
Solved! Go to 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:
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.
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.
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.
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:
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.
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.
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.
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?
This training provides practical hands-on experience in creating Power Apps solutions in a full-day of instructor-led App creation workshop.
Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.
User | Count |
---|---|
252 | |
124 | |
85 | |
84 | |
67 |