Answered

Converting data from True/False to another form

(1) Share

Report

Posted on by FN-30071725-0

I have a flow where the data that is being extracted from MS Excel is in the TRUE/FALSE form (these are checkboxes, which are either ticked or left blank). I would like to convert them to another form, say "Yes" for "TRUE" and just a blank for "FALSE".

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (1)

Suggested answer

Tomac 4,048 Moderator on at

Like (0)

Report
Copy link

Link copied!
You can initialize a variable and use it to store your custom value like this:

I'm using the following snippet for my expression:

if(outputs('Get_a_row')?['body/VulnCat'],'Yes','')

You'll want to change the outputs() part to match the Excel value you want to convert to a custom value. Then reference this string variable instead of the Excel value.

Was this reply helpful? Yes No
FN-30071725-0 62 on at

Like (0)

Report
Copy link

Link copied!

@Tomac I have the flow as such. Would the "Initialize Variable" action right after the "Select" action help me accomplish this?

Was this reply helpful? Yes No
Verified answer

Tomac 4,048 Moderator on at

Like (1)

Report
Copy link

Link copied!

@FN-30071725-0 In this case you would but that expression right in the Select action instead of using a variable

1 people found this reply helpful.

Was this reply helpful? Yes No