One or more fields provided is of type 'Null', a different type is expected.

(0) Share

Report

Posted on by TB-20081424-0

220

Good Morning,

I have a word document template and I use Power Automate to fill the template and save the file.

The flow works great , except that my toggle values are showed as true/false on the document. I would like to change them so that true is displayed as 'Yes' and false is displayed on the document as 'No'.

I would like the values changed to a Yes or No in the word document.

So I have entered the following into an expression for each yes/no value, but now I get a null error.

if(triggerOutputs()?['body/OData__x0051_30'],'Yes','No')

I thought about using the following, but not sure how to implement it into my expression.

Any thoughts on how to rid of the null error?

Thanks

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

v-chengfen-msft on at

Like (1)

Report
Hi @TB05 ,

I assume when triggerOutputs()?['body/OData__x0051_30'] is empty and the output is Null.
Here is a formula for your reference:
if(empty(triggerOutputs()?['body/OData__x0051_30']), null ,if(equals(triggerOutputs()?['body/OData__x0051_30'],true),'Yes','No'))

Best Regards
Cheng Feng

Was this reply helpful? Yes No
Verified answer

TB-20081424-0 220 on at

Like (0)

Report

@v-chengfen-msft thank you for your response. Using your expression, I was able to output the true/false to yes/no on the word document with a minor tweak. Thanks for your help.

if(equals(triggerOutputs()?['body/OData__x0051_1'],null), coalesce(triggerOutputs()?['body/OData__x0051_1']) ,if(triggerOutputs()?['body/OData__x0051_1'],'Yes','No'))

Was this reply helpful? Yes No