Hello!
At first, I'm quite new to powerapps and hopefully I do explain my problem good enough.
At the moment I want our customer to sign when a job is done. When I click on the button to save the data into a MYSQL column, I do set a couple of variables/parameters.
I do want to make sure one of two the signature fields is empty, to compare if there is a signature.
Therefore I do reset one of the fields on click to make sure its empty. Then I do set 2 variables, one with an empty JSON Base64 string, one with the actual signature JSON base64 string.
First I had troubles with storing SignatureInput.Image. Therefore I put it in a variable and now its pointing to a hidden label where I post it as Text(sigImage) to make 100% sure i'm posting text into the VARCHAR(65535) field in the db.
After putting it into the database, I am validating the actual signature versus the entry in the db, and at this point it gets interesting. Im doing this because I was not sure when it actually stored the signature, and when not.
If i do run the application in the browser, I can store whatever I want, without any problems. Everything gets saved the way it should.
When I do push the app toward the phones, I am not able to store signatures anymore. Some kinda way it doesnt post it at all..
If there is more info nessecary, let me know!
Reset(signatureEmpty);;
Set(
sigImage;
JSON(
signatureInput.Image;
JSONFormat.IncludeBinaryData
)
);;
Set(
sigEmpty;
JSON(
signatureEmpty.Image;
JSONFormat.IncludeBinaryData
)
);;
If(
sigImage = sigEmpty;
Notify("Er is geen handtekening gezet!");
Patch(
'[***].[malfunctionform]';
LookUp(
'[***].[malfunctionform]';
id = Value(DataCardValue29.Text)
);
{signature: SignatureInputString.Text}
)
);;
If(
LookUp(
'[***].[malfunctionform]';
id = Value(DataCardValue29.Text);
signature
) = Text(sigImage);
Patch(
'[***].[malfunctionform]';
LookUp(
'[***].[malfunctionform]';
id = Value(DataCardValue29.Text)
);
{closed: 1}
);;
Navigate(
browseMalfunctions;
ScreenTransition.Fade
);
Notify(
"Er is een fout opgetreden. Probeer opnieuw";
NotificationType.Error
) && Navigate(
browseMalfunctions;
ScreenTransition.Fade
)
)
