Dataverse table, where are images stored and how can i access them?

(0) Share

Report

Posted on by felixcheah

I have a dataverse table like below

Is there a way for me to retrieve all the images that are on the table? For example get them all into a local drive?

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (11)

Answers (0)

wwweber 146 on at

Like (0)

Report

The images are stored for each individual row. You could create a view or query showing only the image column for that individual table, but they are not stored together somewhere you can access by itself like a sharepoint site. I also recommend using alternative sources for storing images and files because of this limitation in storing things like this in dataverse. This of course depends on what the use-case is.

Was this reply helpful? Yes No
Parvez Ghumra 1,579 Moderator on at

Like (0)

Report

@felixcheah Where do you want to access them from? Programmatically or manually?

Was this reply helpful? Yes No
felixcheah on at

Like (0)

Report

Manually, I would like to download these images to a local drive

Was this reply helpful? Yes No
wwweber 146 on at

Like (1)

Report

You can download them either directly or find the download url based on this documentation:
Use image column data (Microsoft Dataverse) - Power Apps | Microsoft Learn

Was this reply helpful? Yes No
felixcheah on at

Like (0)

Report

How do I download them directly?

Was this reply helpful? Yes No
wwweber 146 on at

Like (1)

Report

@felixcheah
The quickest way to get the image url is to use the following:
https://yourorg.crm.dynamics.com/api/data/v9.1/tablenameinplural(recordId)

Then retrieve the image_url and insert "&Full=true" after the url.

Was this reply helpful? Yes No
felixcheah on at

Like (0)

Report

https://org6f500abf.crm.dynamics.com/api/data/v9.1/FelixMeals(Image)
Like this ?
I get this error.

Was this reply helpful? Yes No
wwweber 146 on at

Like (0)

Report

the GUID/recordid needs to be within the parenthesis instead of (image). This will give you the image url in the returned array.

Lets say you have a record with the GUID 1304494f-f260-48f9-9221-1539a4e82bce

Then you put the following in the address:
https://org6f500abf.crm.dynamics.com/api/data/v9.1/FelixMeals(1304494f-f260-48f9-9221-1539a4e82bce)
In the result, search for where it says "image_url" and use that string.
This will tell you the image url. You then only need to add &Full=true after that image url

Was this reply helpful? Yes No
felixcheah on at

Like (0)

Report

This only shows on row right? is there a way to show all the rows for one column?

Was this reply helpful? Yes No
Rolson1 45 on at

Like (0)

Report

How to do this within a power automate flow?

Was this reply helpful? Yes No