Data Table Issue with Bit Column

[WillPage]

Hello,

I have a SQL view with a bit (Boolean) column. The column is called 'Description Edited'.

If I add a Data Table to my app and connect to this view, the data card for this column defaults to a checkbox. The data card has a Text property which defaults to ThisItem.'Description Edited'

In the data table, all the check boxes are checked despite the value in the database.

Now, if I deliberately make an error in the formula for that Text property, it works!

What's up with that?

[VijayTailor]

Hi @WillPage ,

You have to set the Default Property for CheckBox Like below.

Thanks,
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."

[WillPage]

Hi @VijayTailor that would be great if it was a Gallery, but it's not, it's a Data table where you don't have that option.

[VijayTailor]

Yes In Data table CheckBox not Possible .

You can just Manupulate Value Like if(ThisItem.Edit=1,"Yes","No") Like that.

Thanks.

[WillPage]

Same result @VijayTailor but it's not delegable.

I might just update the view to make string column instead of boolean and be done with this. It's clearly a bug in Power Apps.

[VijayTailor]

Instead of "Yes" , "No" plz try true, false. Once

[VijayTailor]

One more thing, How you Added checkbox in DataTable. you can tell me then will check from my side. also regarding your issue.

[WillPage]

@VijayTailor  Same:

Also:

[VijayTailor]

Ohk Last try. if(Value(ThisItem.'Description Edit')=1,true,false)

[WillPage]

@VijayTailor  I didn't add the checkbox in the data table, it was automatic when I added the boolean column to the table via the "Edit fields" button.

No choice to change it in the data card properties.