Getting full image size from Dataverse table Image Column into an Azure Blob Storage

(0) Share

Report

Posted on by gstredny

134

I have a flow that I am pulling an image column from my dataverse table. I am using a list rows to get my image, then a compose with a base64ToBinary expression (base64ToBinary(outputs('Get_a_row_by_ID')?['body/cr370_pictureoftank'])), then putting the compose output in my blob content for a create blob. This flow works to get my images into the blob storage, but my issue is the images are thumbnails and I can't figure out how to get the full image size from the dataverse. It seems like the only way to pull the image is getting a base64 encoded data, but how can I get the full image? It is stored as a full image in the dataverse

I would like my full image to come into the blob, not a thumbnail.

Categories:

Building flows

I have the same question (0)

All responses (5)

Answers (0)

Sort by

Suggested answer

Building with Why 351 Moderator on at

Like (0)

Report
Copy link

Link copied!

When you download the image use full in the image size. Otherwise it defaults to thumbnail.

Was this reply helpful? Yes No
gstredny 134 on at

Like (0)

Report
Copy link

Link copied!

Well that was simple! Thank you, I still can't seem to get that data from the download a file or an image to the blob storage as an image. If I just place the content from download a file or an image it shows all encoded base64 data. But when I try to decode the data it gives me an error because it is an object.

Was this reply helpful? Yes No
Building with Why 351 Moderator on at

Like (0)

Report
Copy link

Link copied!

Try this:

base64ToBinary(body('Download_a_file_or_an_image')?['$content'])

Was this reply helpful? Yes No
gstredny 134 on at

Like (0)

Report
Copy link

Link copied!

Ya I have tried that but I keep getting this error:

I have tried converting the content from the download a file or an image to a string first too and that doesn't work either.

The output from the Download a file or an image looks to be a string and base64:

Just for some reason if I put the content directly in the content for the create blob it shows up in my blob as this:

Was this reply helpful? Yes No
Building with Why 351 Moderator on at

Like (1)

Report
Copy link

Link copied!

Please note that I am digging into the object with the ?['$content']. When I ran a test it worked with that schema, but did not without the extension.

Was this reply helpful? Yes No