Dataverse Image fields not copying in full resolution using the XRMToolBox DataTransporter? Power Automate to the rescue!

When moving data from a custom Table I created to store Rich Text Images into another environment using the XRMToolbox data transporter, I noted the images looked blurry:

Checking the image size, it’s only a small image (like a few KB) when the original image had more than 200kb in size.

So I wondered, what went wrong in the copy.

It turns out the Image field is a reference to a ‘FileAttachment’ table item on the background, and we can’t easily copy and filter items from the FileAttachments using the XRM toolbox.

Power Automate to the rescue!

When playing around a Flow to try helping with the data copy I noted two actions in Power Automate that actually I had never used before:

• Download a file or an image
• Upload a file or an image

And with the ‘For a Selected Environment’ actions, we have the same. So we could create a manually triggered flow that gets all images from a source and updates it in the destination environment.

Considering that all other field values were already copied, we can create a simple flow as below (given the Id’s of the items will match across environments):

Note: Mark the image resolution as ‘full’ when getting the image to get it in full size.

Results:

After running a flow, the images will be updated in full resolution:

The post Dataverse Image fields not copying in full resolution using the XRMToolBox DataTransporter? Power Automate to the rescue! appeared first on michelcarlo.

Original Post https://michelcarlo.com/2024/11/02/dataverse-image-fields-not-updating-in-full-resolution-using-the-xrmtoolbox-datatransporter-power-automate-to-the-rescue/