web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps Why are boolean values...

Power Apps

Answered

Why are boolean values different in a table if I change from a text display to a boolean display?

(0) Share

Report

Report

Posted on by MichaelF1

82

Hi everyone,

I'm building a Power App based on a sharepoint list.

One of the fields in sharepoint is yes/no.

When I display this data in a table in my PowerApp it shows correctly if the field is selected as text column:

true

false

true

false

But when I choose the column to be boolean column it shows the data incorrectly as

tick

tick

tick

tick

Functionally it works fine with the text column, but I would prefer stylistically to have ticks in boxes.

Thank you 😃

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (1)

Verified answer

BCBuizer 22,505 Super User 2025 Season 2 on at

Like (1)

Report
Hi @MichaelF1 ,

This seems to be an issue for longer:

https://powerusers.microsoft.com/t5/Building-Power-Apps/how-to-handle-Boolean-value-in-Datatable/td-p/373767

It is suggested to change back to a text column and then use a formula like the below as a workaround:

If(ThisItem.Yourcolumn,"☑","☐")

Was this reply helpful? Yes No
MichaelF1 82 on at

Like (1)

Report

Hi @BCBuizer ,

Yes, that worked - thanks very much for helping me out! 😃

Was this reply helpful? Yes No

Join the conversation