Set Checkbox value return query from database MSSQL

(0) Share

Report

Posted on by Soundjam

Good afternoon,

I have run into a bit of an issue that I've been struggling with for a while now and hope someone can help.

I can retrieve the information from the database and put into a collection, but when i compare through an if statement, the value of the "Set(x)" doesn't seem to update the checkbox default field.

Since MSSQL doesn't have a Boolean option for a datatype, i have tried "tiny-int", Char(10), nvarchar(10) but that doesn't seem to make a difference. Does anyone have the proper way to do this?

Is there another way a text value can be converted to a Boolean value?

this is one thing I have tried: Set the default value of the checkbox to:

Here is another: On Visible of the page start, the

checkbox default = xA1, 

xDone1 value = true (text value from database)

I have also tried:

If(First(HistCollection).xDone1 = "true", Set(xA1,true), Set(xA1, false));

the same as below, just broken down more.

For some reason with whatever i do, i can not seem to "Set" the variables. This is a large program and have done it in many other parts of it, but this one has got me.

Thank you

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Sort by

Soundjam 17 on at

Like
a
(0)

Report
Copy link

Link copied!
I have also tried this as well, but still doesn't seem to work

Set(xA1, If(First(HistCollection).xDone1 = "true", true,false ))

Was this reply helpful? Yes No
Verified answer

Soundjam 17 on at

Like
a
(0)

Report
Copy link

Link copied!
I think I've finally found my solution to the problem.
For testing purposes, I set some of the fields in the database to be nvarchar(10), and some to be char(10) to see what would work best, even tinyInt (i abandoned this one).

However, after the last few hours of going through this and i couldn't figure out why this would not pass through and work 😞

If(First(HistCollection).xDone1 = "false", Set(cBox, true), Set(cBox, false)); Set(xA1, cBox)

the result would not set cBox to true, whether the result from xDone1 was true or false

Solution: The field length in the database was set to 10.
In reality,, Len("true") = 4 and Len("false") = 5, but the "true" result I was expecting was a length of 10. Yip,, the field length in the database, but powerapps was not comparing the text it was including the spaces left over!.. bummer.

So after adding in the Trim function to tear off the extra space... Everything is fine.

Now i just paste the code into the Default field of the Checkbox:

Trim(First(HistCollection).xDone1)

and all is good. Now i'm off to the races again.
However, one thing better to do is: Set the Default of the Checkbox to a variable,, such as xA1 and on the select button that takes me to this screen, set the variable with this:

If(Trim(First(HistCollection).xDone1) = "true", Set(xA1,true), Set(xA1,false))

Hope this helps anyone with the same problem

Was this reply helpful? Yes No
v-siky-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Soundjam

Gald to see you have found the resolution.
Could you please mark your answer as a solution to help other members find it quickly?
Sik

Was this reply helpful? Yes No