Answered

Image Field on Dataverse

(0) Share

Report

Posted on by barlowse

207

How do I patch a record in a Dataverse table's image column? I can do this in Sharepoint but not sure how to do this with Dataverse.
I don't want to use Power Automate, it has to be with a patch formula.
This is what I have but get an error that says the datasource is invalid...

The image is in an Image control called HiddenImageControl1.

upload file to companies.JPG

Formula on my Upload button.

Set(_addfile,JSON(HiddenImageControl_1.Image,JSONFormat.IncludeBinaryData));

Set(_base64File,Mid(_addfile,Find(",",_addfile)+1,Len(_addfile) - Find(",",_addfile) -1));

Set(_upload, false);

Patch(Filter(Companies, 'Company Name' = CompanyName.Text),

{'Company Logo':HiddenImageControl_1.Image});

Below is the error from Monitor when I click the button.

Anyone tried to do this?

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (2)

Verified answer

v-xiaochen-msft on at

Like (0)

Report
Hi @barlowse ,

Firstly, please make sure the picture is in base64 format.
Secondly, Image column expects a record . Its format is {Image:{Value:"***",Full:"***"}}

I've made a test for your reference:
1\ This is my image control 'Image1'.

2\ Add a button control and set its onselect property to:
Patch(Students,First(Students),{Image:{Full:Image1.Image,Value:Image1.Image}})

3\ Add another image control 'Image2' to show the Image value in my first record.
Set the image property of 'Image2' to:
First(Students).Image.Full

4\ The result is as follows:

Best Regards,
Wearsky
If my post helps, then please consider Accept it as the solution to help others. Thanks.

Was this reply helpful? Yes No
Verified answer

barlowse 207 on at

Like (0)

Report

Thanks for the help! I figured out that my issue was having a filter in my Patch statement. Once I removed that - all worked beautifully.

Was this reply helpful? Yes No