Boolean, save to MySQL as -1, not as 1

(0) Share

Report

Posted on by Ferdl

Hello community,

I have an App with functions like this:

Patch('Backend.tblNachverfolgung';
 First(Filter('Backend.tblNachverfolgung';nachvID = First(colProjektDetails).nachverfolgungID));{nachvTagesplan: If(chkTagesplan.Value;-1;0)})

I simply try to patch a boolean value into a MySQL table. The field is 'nachvTagesplan' and of the type tinyint(1) in MySQL. The Table stores false as 0 and true as -1. I am using this table also in MS Access and works fine there.

If I now try to patch a true Value from my PowerApps it always stores it as 1. So I have the problem, that my MS Access isnt working any longer because of the missing '-'.

Is there a possibilty to tell Powerapps it has to store true values as '-1' and not as '1'?

i also tried things like

{nachvTagesplan: chkTagesplan.Value}
or
{nachvTagesplan: If(chkTagesplan.Value;Int(-1);0)}

Any ideas?

Thanks a lot!

Categories:

Building Power Apps

I have the same question (0)

All responses (1)

Answers (0)

timl 37,246 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@Ferdl

If the underlying data type of your nachvTagesplan column is tinyint, it's necessary to patch either -1 or 0 in the way that you're currently doing.

There's no way in Power Apps to automatically coerce Boolean true values to -1.

Was this reply helpful? Yes No