How to get base64 data from a Dataverse File Column

[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.

[gidiscacciati · Accepted solution]

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.