Unanswered

Converting image data from Hexadecimal to Binary

(0) Share

Report

Posted on by HeroFS

Hello, I am currently using the patch function to connect to my SQL database. I am actively passing all the data, but need to convert the IMAGEDATA to binary. I think i may be putting the hex2bin code in the wrong place ? Below is my patch function.

Patch(
POWERAPPS_REQUESTWORKORDER_1,
Defaults(POWERAPPS_REQUESTWORKORDER_1),
{
FM: MYUSER,
CORPCODE: "EXFICORP",
CREATEDATE: Now(),
SITENAME: SITENAMEDataCardValue16.Selected.Value,
QR_ID: QRIDDataCardValue11.Text,
OPERATIONAL: OPERADataCardValue10.Value,
EQUIPMENT_NUM: EQUIPDataCardValue9.Text,
DESCRIP: DESCRIPDataCardValue14.Text,
APPROVAL_STATUS: false,
IMAGEDATA: First(RequestWO_Images).Value
}
);Reset(AddMediaButton1);
ResetForm(Form1);

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (0)

Sort by

CarlosFigueira Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

What is the type of the column IMAGEDATA in your POWERAPPS_REQUESTWORKORDER_1 table? And what is the type of the values inside RequestWO_Images (i.e., how is that collection populated)? Sending images (such as those from the Add Picture control, or taken from a camera) to a column of type IMAGE or VARBINARY in SQL Server should just work, you shouldn't need to do any conversion in the Power Fx expression.

Was this reply helpful? Yes No
HeroFS 6 on at

Like
a
(0)

Report
Copy link

Link copied!

In SQL IMAGEDATA is Varbinary(max), when I go to my values inside RequestWO_Images they are being stored as 'appres://blobmanager/9f624ee1145344abaebe0cec5eddaab5/1" and 'appres://blobmanager/9f624ee1145344abaebe0cec5eddaab5/2" etc.. and the image capture is coming from an ADD PICTURE control. The data does store at hexadecimal but for our purposes we need it to be in varbinary to use across other applications once the image is stored and hexadecimal is not compatible.

Was this reply helpful? Yes No