Convert Strings to Boolean

[alietzau]

I have a powerapp that is connecting to a Excel spreadsheet. One of the columns in the sheet uses TRUE/FALSE values. I would like to use this as a boolean to limit some of the functionalities in my app but I can't convert the text to a Boolean data type. I've looked through the functions but I couldn't find anything. Is there a trick that I should be using?

[dinusc · Accepted solution]

The following should work:

If(Lower(Your_Text)="false", false, true)

[Anonymous]

I prefer this solution since it's less code.  Assuming your text values will either be true or false.

Set Default: Value(ThisItem)

[max81]

@Anonymous strange. For me this doesn't work if the text is "false". I tried it with a simple text_input control and a toggle button.