cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
alietzau
Level: Powered On

Convert Strings to Boolean

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?

1 ACCEPTED SOLUTION

Accepted Solutions
Microsoft dinusc
Microsoft

Re: Convert Strings to Boolean

The following should work:

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

View solution in original post

2 REPLIES 2
Microsoft dinusc
Microsoft

Re: Convert Strings to Boolean

The following should work:

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

View solution in original post

david3000
Level: Powered On

Re: Convert Strings to Boolean

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

 

Set Default: Value(ThisItem)

Helpful resources

Announcements
thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Power Platform World Tour

Find out where you can attend!

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

Top Kudoed Authors (Last 30 Days)
Users online (3,917)