Patching a Dataverse Image column

(1) Share

Report

Posted on by astrontelstar

287

I have an app where I build a collection of items from a purchase order.

I iterate through the collection and retrieve the image URL of each of the product images so I can display the images next to their description.

Once I'm done editing/changing/reviewing the items in the collection I have a save command that runs a Patch command on a sharepoint dataverse table. One of the columns in the table is an image column.

I setup a sample table with just a product name and an image column for testing how to patch the image.

I use a flow function to pull the image from a given URL into a collection; again just for testing.

The data comes back apparently in the correct image format?

When I try to use this to patch the test table, I'm getting an type mismatch error, it says the ProductImage column field is expecting a record?

When I run the patch command using an image control whose property is First(Col).imagedata it works no problem.

Unfortunately I can't use the image control because I need to patch this as I'm iterating through my PO items.

Any ideas what the right syntax is here?

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (2)

Verified answer

Hussein Wahba 55 on at

Like (1)

Report
The error is passing the data in the field directly, the field of type image should be passed as a record with a schema of two fields each one having the base64 value as follows:

Patch( testImageTables, First( Filter( testImageTables, ProductName = "test" ) ), { 'ProductImage': { FileName: "test.png", Value: First(Col).imagedata, Full: First(Col).imagedata } } )

I don't know what the difference between the value and full columns of the image is, but both should be an image, I cannot find any documentation about the difference between the two fields.

Also, I think it will be better to update the image from the flow directly instead of sending the data between the app and the flow.

Was this reply helpful? Yes No
astrontelstar 287 on at

Like (0)

Report

Thank you! The missing part was the Value and Full as a record. Any idea where you found that? I searched everywhere. In my particular case FLOW seems much more complicated syntax than a canvas app so I'm using it instead. It seems to work fine now with your information!

Was this reply helpful? Yes No
Verified answer

Hussein Wahba 55 on at

Like (0)

Report

Unfortunately, there is no documentation for it, but I followed the errors that appeared in the formula.
The first error was saying that I was passing a string, but the type was a record, so I started to pass a record.
Then the error changed to passing the mandatory columns one by one.
One of the trials was retrieving the data from the Dataverse but it was retrieved as an image directly without a structure.

Was this reply helpful? Yes No