Power Automate

Power Automate error - 'null' values

(1) Share

Report

Posted on by JJP1

Hello.

I am receiving the following errors regarding some workflows:

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

"InvalidTemplate. Unable to process template language expressions in action 'Send_an_email_notification_(V3)_2' inputs at line '0' and column '0': 'The template language function 'replace' expects its first parameter 'string' to be a string. The provided value is of type 'Null'. Please see https://aka.ms/logicexpressions#replace for usage details.'."

I am seeking assistance with how to fix these errors. I am thinking a 'replace' function should work if the field's value is 'null'. I found the following expression online: if(equals(<VALUE TO TEST>, null), 'Value if null', 'Value if not null')

If the value is 'null', I would like it to be replaced with a space (if not possible, a period or dash will work). If it is not 'null' I want the field to execute another 'replace' function, so plain text can have line breaks. For the line breaks, I am using this expression and it is working so far on its own when the field is not 'null': replace(triggerOutputs()?['body/SMComments'],outputs('NewLine'),'')

When I try to combine the expressions, Power Automate says the expression is invalid. May some assist me with trying to combine these expressions into one or provide an alternative that would have the same result I am looking for? This is the invalid expression I have been attempting: if(equals(triggerOutputs()?['body/SMComments'], null), -, replace(triggerOutputs()?['body/SMComments'],outputs('NewLine'),''))

Any help would be greatly appreciated!

Categories:

Building flows

I have the same question (0)

All responses (4)

Answers (0)

JJP1 23 on at

Like (1)

Report

Figured it out... It had to do with formatting.

The following expression works and resulted in successful testing:

if(equals(triggerOutputs()?['body/SMComments'],null),'',replace(triggerOutputs()?['body/SMComments'],outputs('NewLine'),''))

Null values are replaced with a blank space.

Was this reply helpful? Yes No
eliphalet 4 on at

Like (0)

Report

Instead of testing a string as equal to null, you can use the empty([string]) function, which returns a true or false value.

Was this reply helpful? Yes No
Suggested answer

chanzy 2 on at

Like (0)

Report

Another way to account for this is to use the string function around the variable you are testing. Using your example:

replace(string(triggerOutputs()?['body/SMComments']),outputs('NewLine'),'')

Was this reply helpful? Yes No
AbacusBob 2 on at

Like (0)

Report

I'm really a beginner and it appears that I'm in well over my head...

1) I'm glad you discovered a solution... and it looks great but where do you insert this expression... in the get response?

2) I found this and am trying it: https://learn.microsoft.com/en-us/troubleshoot/power-platform/power-automate/flow-run-issues/getting-errors-null-fields

So far it's not doing anything but stalling the flow.

so I'm going to just get rid of everything that I've put in.. the parts of the flow that are working, are apparently working enuf to get me what I need... but I need this fixed somehow...

Here's an assumption:

if(equals(triggerOutputs()?['body/field name here '],null),'',replace(triggerOutputs()?['body/field name here '],outputs('NewLine'),''))

so where do i put this, I've got a "when a new response is submitted", a "get response details" and a "Send and email(v2)"

Im thinking it's gotta go in the "get response details", as that will be before the error in "send and email)v2)" so where does it go??

Was this reply helpful? Yes No