Search code examples
sharepointpowerapps

Base64 images from SharePoint multi-line text to PowerApps

Basically, I am trying to set an Image in Power Apps from a multi-line text field in SharePoint that stores the base64 image.

The multi-line text fields in SharePoint stores the base64 image like "data:image/png;base64,iVBORw0KGgoAAAANSUhEU......."

I upload these images to SharePoint entries from PowerApps by doing a Patch and using this JSON formula JSON(penFullMapDrawing.Image, JSONFormat.IncludeBinaryData).

  • The base64 image successfully writes to SharePoint and when I copy and paste the base64 text from SharePoint into the Image property for an Image in PowerApps it displays the proper image.

  • The problem is that when I try to set the Image property via a LookUp function to retrieve the base64 text from SharePoint the image does not display in PowerApps even though it grabs the correct text.

Any ideas how to make this work or what's going on here?

Solution

  • The problem was the “s surrounding the base64 image.

    I had to modify my LookUp function to Substitute(LookUp(), “”””, “”) and it works as intended.