Upload a file or an image to Dataverse from a PowerApp

[lachlanP]

I am trying to upload an image to a Dataverse table with an Image column. The image is taken or selected in a power app and passed to the Flow formatted as a URI as follows:

data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAABAAAA...

I then use a compose to reformat this to binary using dataUriToBinary() :

{
"$content-type": "image/png",
"$content": "iVBORw0KGgo..."
}

Then, I'm passing this to the "Upload a file or an image" Dataverse action:

Where the content field is the produced binary from the compose action. 

This is not working though. I get the following error:

Error

Action 'Upload_a_file_or_an_image' failed

Is there another way I should be formatting the image? It seems that this is how it worked with the former CDS, and the Microsoft docs states that for this action it expects a binary type in the content field:

https://docs.microsoft.com/en-us/connectors/commondataserviceforapps/#upload-a-file-or-an-image

Thanks in advance for the help!

[Mira_Ghaly]

@lachlanP 

Can you please have a look and try if this works for you on how i have handled passing from powerapps to power automate to get the base64 string correctly.

https://onlinemgblog.wordpress.com/2021/03/24/save-and-retrieve-dataverse-email-attachments-in-a-can...

If this did not help please send me the exact value you have on your first step which is passed from powerapps to to power automate so I can try to give it a try on my side.

[lachlanP]

@Mira_Ghaly ,

Thanks for the reply.

I'm not sure how to apply your CDS example to the Dataverse action. The CDS action in your link uses "body" and "Mime Type" fields where the Dataverse action just uses a "Content" field. 

It looks like you pass the bas64veryLONGSTRING to "Body" and "image/png" to "Mime Type".

I have tried passing bas64veryLONGSTRING to "Content", as well as the binary structured as:

{
"$content-type": "image/png",
"$content": "bas64veryLONGSTRING"
}

Do I have the structure of this field wrong? Or is there somewhere I should be passing this "Mime type" for dataverse?

Trying to add my value from the first step keeps crashing my browser here. I'm sure any example of the same scenario would work.

Thanks

[Alex_Nguyen]

Hi @lachlanP , were you able to fix this issue ? I have the same.

[lachlanP]

@Alex_Nguyen , No I wasn't able to fix it

[Anonymous]

I stumbled upon this whilst searching the same error. After way too much time I cracked it. 

I'll leave this here if anyone else searches the same.

For Row Id, select the dynamic content from Dataverse that has "Unique identifier for entity instances" under it instead of the OData Id.

[Martin_W]

Thank you so much for this!! I was pulling my hair out trying to work out what was wrong!!