Answered

How to get base64 data from a Dataverse File Column

(0) Share

Report

Posted on by gidiscacciati

Hi everyone!

Is there a way to get the base64 data from a Dataverse table File Column back to powerapps?

My issue is that I already have populated this table, but now I need to get the base64 data so I can send it to a flow, which will deal with it.

This table populates a gallery. I have tried using JSON(ThisItem.File.Value; JSONFormat.IncludeBinaryData), but it results in a "appres://datasources..." string. I have also tried using an Image control inside my gallery, with the Image property set to ThisItem.File.Value, and then collecting JSON(Image_1.Image; JSONFormat.IncludeBinaryData) to feed a collection, but it only works with the first item, the value does not change.

Am i missing something? Is there a way to do this?

Thanks in advance!

EDIT: Apparently, the "Value" field of a File Column comes back to power apps as Hyperlink, that is probably why JSON(ThisItem.File.Value) doesn't help. Any help on how to achieve this is appreciated.

Categories:

Building Power Apps

All responses (2)

Answers (1)

Sort by

Verified answer

gidiscacciati 69 on at

Like
a
(0)

Report
Copy link

Link copied!

If anyone ever comes across a situation like this, I finally figured it out.

I've put an Image control inside my gallery with its image property set to ThisItem.File.Value. Then, I ran a ForAll loop on Gallery.AllItems. With this, I could use "ThisRecord" to acess the image control, like ThisRecord.Image_1.Image. Then I just parsed it with JSON(ThisRecord.Image_1.Image; JSONFormat.IncludeBinaryData) and I finally got the base64 data.
pp365 450 Season of Giving Solutions 2025 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi everyone, @gidiscacciati ,
What would be the equivalent method to do do this in Power Automate? The file resides in a record in Dataverse but needs to be exposed as base64 in a Flow for another function. Thank you!