How to Convert True to Yes in Power Automate?

Do you need to change true false to yes no in Power Automate? Then, this Power Automate tutorial will guide you to convert true to Yes and false to No in Power Automate in different ways with examples. I will also show you how to convert a boolean to a string in Power Automate.

Scenario:

The flow will trigger When an item is created in the SharePoint List, and an email will go to the Employees to check whether the details are correct or not.

So, by default, when we get items from the SharePoint list for the Yes/No column data type, it returns the values as true or false. The screenshot below shows that the Yes/No column types (highlighted in red) are presented in my SharePoint list.

As per my requirement, I want to convert a boolean to a string and display the Yes/No fields in the email notification.

power automate convert true to yes

Now, we will create a flow to convert a boolean to a string using Power Automate.

Power Automate convert Boolean to String

Let us see how to convert a boolean to a string using Power Automate flow.

In this example, I am going to use the below SharePoint Employee list, consisting of different columns.

power automate convert string to boolean
Column NameColumn Data type
EmployeeIDdefault title column
EmployeeNameperson or Group type
EmployeeDesignationText type
DateofJoiningDate type
EmployeeStatusChoice type
ContactNumberNumber type
EmployeeEmailAddressText type
PreviouslyWorked Yes/No type
Disablity Person Yes/No type

Step-1:

  • Based on my requirement, the flow will trigger when an item is added to the SharePoint list. So create an automated cloud flow and choose the trigger as when an item is created.
  • Expand the created trigger action and configure the required parameters.
    • SharePoint Site Address – select the SharePoint site address
    • List Name – I have selected my SharePoint list (Employee list)
power automate convert yes no to boolean

Step-2:

Select + new step and add a send email action from the action triggers. Provide the required parameters

  • To – Pass the Employee email address from dynamic content values
  • Subject – Enter the Subject of the mail
  • Body – Provide the body of the mail
See also  How to Create a Word Document from a SharePoint list item using Power Automate?

Here, if we directly pass the yes/no field from the dynamic content value, it returns the boolean value as true or false. So we will convert the boolean to a string and then send an email to the Employee to check whether the details are correct.

In my SharePoint list, I have two yes/no fields.

PreviouslyWorked (Yes/No type)

if(equals(triggerOutputs()?['body/PreviouslyWorked'],true),'Yes','No')

where,

PreviouslyWorked = column internal name

Disability Person (Yes/No type)

if(equals(triggerOutputs()?['body/DisablityPerson'],true),'Yes','No')

where,

DisablityPerson = column internal name

power automate convert boolean to string

Save and Run the flow, The flow will trigger only when I add a new item to the SharePoint list. Here, I have added the highlighted list item

power automate convert yes to boolean

Once the flow runs successfully, now you can see that all the Yes/No fields will be converted from True/False values to Yes/No values, as shown below.

power automate convert false to No

This is how to change true false to yes no using Power Automate flow.

Power Automate convert String to Boolean

Now, we will see how to convert String to Boolean using Power Automate flow.

We can convert yes no to a boolean using Power Automate flow in three ways. They are,

  1. Using If Function
  2. Bool function
  3. Condition action

Using If Function

Yes, we can easily convert the string to a boolean by using the if function in Power Automate flow. We are going to use this expression to get the string value, compare it with the required value, and finally return the corresponding boolean value.

If function syntax:

if(condition, true, false)

Where the condition checks the string is Yes or No, If yes, then it returns true. If No, it returns false.

Step-1:

Create an instant cloud flow with a manual trigger, Add a new step, and choose the compose data operation from the action trigger. Manually pass the input value, here, I have passed the value as NO.

power automate convert yes to true

Step -2:

See also  BadRequest. The property 'columns' must be specified unless the 'from' property value is an array of objects

Add a new step, then select a compose data operation and pass the below expression.

  • The equals function compares the value from the outputs of the compose action is equal to Yes. If yes, then the result is true if no it returns false.
  • We are using the tolower() function to make the input value case-insensitive.
if(equals(toLower(outputs('Compose')),'yes'),true,false)
power automate change string to boolean

Save and Run the flow; once the flow runs successfully, like below, We can see that the string value no returns the boolean value false.

power automate change no to false

This is one way that we can convert String to Boolean using Power Automate flow.

Using Bool function

Here, we will see how to change yes no to true false using the bool function in Power Automate.

Step-1:

Similarly, choose the compose data operation from the action trigger in an instant cloud flow. Manually pass the input value, here, I have passed the value as Yes.

Convert yes no to true false in Power Automate

Step-2:

Select a compose data operation and pass the below expression.

  • The bool function compares the value from the outputs of the compose action is equal to Yes. If yes, then the result is true else false.
  • We are using tolower() function to make the input value case-insensitive.
bool(equals(toLower(outputs('Compose')),'yes'))
power automate change yes no to true false

Save and Run the flow once the flow runs successfully, like below: We can see that the string value Yes returns the boolean value true.

power automate change yes to true

This is another way to convert String to Boolean in Power Automate flow.

Using Condition Action

Now we will learn how to change yes/no values to true or false by using condition action in Power Automate.

In this example, we are using condition action to avoid using functions or expressions in our flow. Now, we will see how we can do it.

Step-1:

Select instant cloud flow and choose the compose data operation from the action trigger. Manually pass the input value; here, I have passed the value as NO.

power automate convert yes to true

Step-2:

See also  How to Create an HTML Table from an Array in Power Automate?

Add an Initialize variable action from the action trigger. Enter the variable name and choose the variable type as a string. Leave the value as empty. Later, we will use it in our flow to set a value to either true or false depending on the Condition action.

How to convert yes no to true false in Power Automate

Step-3:

Select the condition action from the action control and check the condition if the output of the compose action is equal to no. We are using tolower() function to make the input value case-insensitive.

If the input value yes is equal to yes then it returns the boolean value true. Similarly, it checks the condition for in no is equal to yes and returns the boolean value as false.

If yes, select the set variable action, choose the initialized variable value from the dropdown, and pass the expression value as true.

If No, select the set variable action, choose the initialized variable value from the dropdown, and pass the expression value as false.

toLower(outputs('Compose')) is equal to yes
How to convert yes no to true false in Power Automate flow

Save and Run the flow; once the flow checks, the condition runs successfully like below: We can see that the string value No returns the boolean value false.

How to change yes no to true false in Power Automate flow

This is how to change yes/no values to true or false by using condition action to avoid expressions in Power Automate flow.

Conclusion

I hope you understand how to convert a boolean to a string and also how to convert a string to a boolean in Power Automate flow with a manual approach and a dynamic approach—also covered in different ways by using the if function and bool function and condition control to convert yes no to a boolean in a Power Automate flow.

You may like the following tutorials:

>