Getting Yes/No value into word document?

[sudosaurus]

Hello,

I'm trying to get Yes/No value into a word document using the 'Populate a Microsoft Word Document' action.

I've tried this formula in Power Automate however even if the value is set to "Yes", in the word document it shows as "No":

if(equals(outputs('Get_item')?['SF01_ClientPrivacyYesNo'],true),'Yes','No')

The trigger in my workflow is 'For a Selected Item'.

Thanks,

[vikulkar]

hi @sudosaurus ,

I tried to setup a similar flow (with same trigger) and used the same expression with a yes/no column but did not have any issue.

if(equals(outputs('Get_item')?['body/Employed'],true),'Yes','No')

Thanks and Regards,

Vikas K

[sudosaurus]

@vikulkar and it appeared in the word template correctly?

[vikulkar]

@sudosaurus , Yes
I would recommend using a variable and then try to populate the template.

[sudosaurus]

@vikulkar could you suggest a good way of doing this? I'm still quite new to variables.

Thanks

[vikulkar · Accepted solution]

Using the initialize variable action, you will have to store the result of the expression 
then populate the template using the variable's output:

Thanks and Regards,
Vikas K

[sudosaurus]

Thanks @vikulkar 

That did it!

Although just had to update my formula to this:

if(equals(outputs('Get_item')?['body/SF01_ClientAccessYesNo'],true),'Yes','No')