Data Table Issue with Bit Column

(0) Share

Report

Posted on by WillPage

2,307 Super User 2025 Season 2

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?

Categories:

Building Power Apps

I have the same question (0)

All responses (11)

Answers (1)

Vijay Tailor 2,961 on at

Like (0)

Report

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."

Was this reply helpful? Yes No
WillPage 2,307 Super User 2025 Season 2 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Vijay Tailor 2,961 on at

Like (0)

Report

Yes In Data table CheckBox not Possible .

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

Thanks.

Was this reply helpful? Yes No
WillPage 2,307 Super User 2025 Season 2 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Vijay Tailor 2,961 on at

Like (0)

Report

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

Was this reply helpful? Yes No
Vijay Tailor 2,961 on at

Like (0)

Report

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

Was this reply helpful? Yes No
WillPage 2,307 Super User 2025 Season 2 on at

Like (0)

Report

@VijayTailor Same:

Also:

Was this reply helpful? Yes No
Vijay Tailor 2,961 on at

Like (0)

Report

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

Was this reply helpful? Yes No
WillPage 2,307 Super User 2025 Season 2 on at

Like (0)

Report

@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.

Was this reply helpful? Yes No
Vijay Tailor 2,961 on at

Like (0)

Report

Are you sure you setting this code on Default Property? Like I mentioned in the screenshot

Was this reply helpful? Yes No