Unanswered

Set Variable empty value

(0) Share

Report

Posted on by KhrystinaM

158

I am trying to build a multiple approval workflow the will return the approval comments in the email I tried setting it up multiple times.

Test 1

If approved, update SharePoint
send 2nd approval to manager with associate approval comments in email from update SharePoint
- creates an apply to each for every approval comment (Form is built to have up to 3 associate approval comments)

Test 2

Create an initialize variable for each approval comment so apply to each does not happen on manager approval flow
- error message when Associate 3 comment section blank
  - How do I set my variable to return NA if null?

Categories:

Building flows

I have the same question (0)

All responses (6)

Answers (0)

Sundeep_Malik 6,484 on at

Like (0)

Report

Hey @KhrystinaM

You can write a similar expression as below:

1)

If(equals(variables('VariableName'),''),'NA',variables('VariableName'))

2)

If(equals(variables('VariableName'),null),'NA',variables('VariableName'))

I hope this helps 🙂

Was this reply helpful? Yes No
KhrystinaM 158 on at

Like (0)

Report

@Sundeep_Malik Do I apply option 2 to the set variable? I tried that and I'm getting an error.

Was this reply helpful? Yes No
Sundeep_Malik 6,484 on at

Like (0)

Report

Oh my bad.

Actually replace variables('VariableName')

part with the comment expression.

Was this reply helpful? Yes No
KhrystinaM 158 on at

Like (0)

Report

@Sundeep_Malik I input the following.

if(equals(variables('Associate_3_Approval')?['body/outcome']),null),'NA',variables('Associate_3_Approval')?['body/responseSummary']))

I'm getting this error
Flow save failed with code 'WorkflowRunActionInputsInvalidProperty' and message 'The inputs of workflow run action 'Set_variable_4' of type 'SetVariable' are not valid. Self reference is not supported when updating the value of variable 'varAssociate3'.'.

Should my initialize variable have a value? I tried adding a value and removing the set variable, but I got an error for that as well.

Was this reply helpful? Yes No
Sundeep_Malik 6,484 on at

Like (0)

Report

@KhrystinaM

You can directly write the following expression:

if(equals(items('Apply_to_each_-_Associate_3')?['comments'],''),null,items('Apply_to_each_-_Associate_3')?['comments'])

If the above does not work, replace '' with null

I hope this helps 🙂

Was this reply helpful? Yes No
KhrystinaM 158 on at

Like (0)

Report

@Sundeep_Malik Hello, I tried both options on the set variable field and got this error.

ExpressionEvaluationFailed. The execution of template action 'Apply_to_each_-_Associate_3' failed: the result of the evaluation of 'foreach' expression '@outputs('Associate_3_Approval')?['body/responses']' is of type 'Null'. The result must be a valid array.

Was this reply helpful? Yes No