web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

Welcome to the Power Platform Communities
News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Convert Varbinary to V...
Power Apps
Answered

Convert Varbinary to Varchar

(0) ShareShare
ReportReport
Posted on by Kayssarr 11

Hi , 

I have an Canvas app with a Vertical gallery that is based on an SQL query. The query for the gallery is as follows:

 

Filter(SqlTable1, column1 = DropdownBox.Selected.Result)

 

One of the columns in my database is a VARBINARY data type, which is created on data import: 

 

Code for column creation: CONVERT(VARBINARY(Max), Concat(column1, ';', column2,...)

 

If I was to change this in SQL,  I would use the SELECT CONVERT(VARCHAR(Max), binaryColumn) FROM Table1.

 

Is there a way I can do the varbinary to varchar conversion in powerapp?

 

The gallery line entry is ThisItem.binaryColumn

 

 

Any help is appreciated, I have tried:

 

Substitute(JSON(varbinary, JSONFormat.IncludeBinaryData), """", "")

 

unsuccessfully of course.

 

 

Categories:
Building Power Apps
I have the same question (0)
  • Verified answer
    v-xiaochen-msft Profile Picture
    v-xiaochen-msft Microsoft Employee on at

    Hi @Kayssarr ,

     

    Powerapps does not support converting blob data into text data.

    But you could use flow get the value of sql server .

    Then you could pass it from flow to powerapps.

     

    For example:

    I have a table. PriKey is a primary key .It's a int column. Test is a varbinary  column.

    v-xiaochen-msft_1-1621499343691.png

    v-xiaochen-msft_0-1621499276176.png

    I want to get the value of 'Test' of the last item and change it to a char value.

    So i use flow.

    v-xiaochen-msft_2-1621499500274.png

    v-xiaochen-msft_3-1621499535744.png

     

    The result is as follows:

    v-xiaochen-msft_4-1621499588429.png

     

    Finally, this is just an example of getting a value.

    You could create your own flow and powerapps according to your needs

     

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

     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

Welcome to the Power Platform Communities

Quick Links

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 305 Most Valuable Professional

#2
11manish Profile Picture

11manish 212

#3
Valantis Profile Picture

Valantis 167

Last 30 days Overall leaderboard

Featured topics

Auto-Populate field Power Pages
Gallery Tabs - Show or Hide Tabs based on Field Value
How to patch multiple records at once
Enable Copilot for end users in model-driven apps
Question for everyone : How are you using Create Text GPT in AI Builder?
Community content - sample components, blogs etc. - Link to this page (http://aka.ms/PCFdemos)
Welcome to the Power Apps forum!

Product updates

Microsoft Power Platform Community release plans