Unanswered

text input convert into varbinary and update to SQL table

(0) Share

Report

Posted on by ruwna

Hi all, I am creating an app that user can update some loging information and account details throguh the app and it will update to SQL table.

However ,in SQL table strcure password column data type is "varbinary(MAX)" . So my question is how to update the password that user input through the "txt input" to SQL table with conversion of varbinary

Example;
SQL Code : update [tbldialog] set AccountPassword = CONVERT(varbinary,'test@1234') from [tbldialog)] where userId = '256' ;

Thanks in advance!.

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (0)

Sort by

RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
@ruwna

Your varbinary column is not supported by the SQL connector.

As per the documentation:

Unsupported data types include the following examples: binary(), varbinary(), image, cursor, rowversion, hierarchyid, sql_variant xml, Spatial Geometry Types, Spatial Geography Types, and table.

Consider using another data type for your column.

I hope this is helpful for you.

Was this reply helpful? Yes No
ruwna 29 on at

Like
a
(0)

Report
Copy link

Link copied!

Is there any other way of doing this action ? like connect with power automation + power Apps ?

Was this reply helpful? Yes No
RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@ruwna

PowerAutomate uses the same SQL connector. So it is not supported their either.

If you have some need to convert to binary, then you will need to utilize a stored procedure and PowerAutomate to achieve that.

Was this reply helpful? Yes No